1#@!#!123s

22527 1#@!#!123s
: / home / journeyindianow / public_html / admin /
Filename : footer_data.php
back
<?php 
include("main.php");
if(isset($_POST['category_insert'])){
	$name =  mysqli_real_escape_string($con,$_POST['name']);
	$pic  =  $_FILES['picture']['name'];
	 $title    	  = mysqli_real_escape_string($con,$_POST['title']);
	 $keywords    = mysqli_real_escape_string($con,$_POST['keywords']);
	 $headerdes   = mysqli_real_escape_string($con,$_POST['description']);
	$des  =  mysqli_real_escape_string($con,$_POST['comment']);
 	$type  =  mysqli_real_escape_string($con,$_POST['type']);
 	$link  =  mysqli_real_escape_string($con,$_POST['link']);
		if($pic != '')
		{
			$extension		= end(explode(".", $pic));
			$targate_file	= time().rand(10,100).".".$extension;
			if (move_uploaded_file($_FILES['picture']['tmp_name'], "category/".$targate_file)){
				
				$query = "INSERT INTO `footer_data`( `varName`, `varImage`, `txtDescription`,`varMetaTitle`, `varMetaKeywords`, `txtMetaDescription`) VALUES ('$name','$targate_file','$des','$title','$keywords','$headerdes')";
				if($insert = mysqli_query($con,$query)){
					echo '<script> window.location.replace("footer_data.php");</script>';
				}else{
					echo '<script> alert("Something went wrong");</script>';
				}
				
			}
	   }else{
				$query = "INSERT INTO `footer_data`( `varName`, `varImage`, `txtDescription`,`varMetaTitle`, `varMetaKeywords`, `txtMetaDescription`,varLink,varType) VALUES ('$name','$targate_file','$des','$title','$keywords','$headerdes','$link','$type')";
				if($insert = mysqli_query($con,$query)){
					echo '<script> window.location.replace("footer_data.php");</script>';
				}else{
					echo '<script> alert("Something went wrong");</script>';
				}
			}
 
	 
}
if(isset($_POST['category_update'])){
	$id =  mysqli_real_escape_string($con,$_POST['category_update']);
	$name =  mysqli_real_escape_string($con,$_POST['name']);
	$pic  =  $_FILES['picture']['name'];
	$title    	 = mysqli_real_escape_string($con,$_POST['title']);
	$keywords    = mysqli_real_escape_string($con,$_POST['keywords']);
	$headerdes   = mysqli_real_escape_string($con,$_POST['description']);
	$des  =  mysqli_real_escape_string($con,$_POST['comment']);
	$type  =  mysqli_real_escape_string($con,$_POST['type']);
 	$link  =  mysqli_real_escape_string($con,$_POST['link']);
 	
	$update .= "UPDATE `footer_data` SET `varName`='$name',`txtDescription`='$des',`varMetaTitle`='$title',`varMetaKeywords`='$keywords',`txtMetaDescription`='$headerdes',varType='$type',varLink='$link'";
	 if($pic != '')
		{
			$extension		= end(explode(".", $pic));
			$targate_file	= time().rand(10,100).".".$extension;
			if (move_uploaded_file($_FILES['picture']['tmp_name'], "category/".$targate_file)){
				$update .= ",`varImage`='$targate_file'";
			}
	   }
	   $update .= " WHERE intId=$id ";
	  
	   if($insert = mysqli_query($con,$update))
		{
			echo "<script>alert('Udated Successfully');</script>";
			echo "<script>window.location.replace('footer_data.php');</script>";
		}else{
			echo "Something went wrong";
		}
} 

/* category delete code */
if(isset($_POST['delete'])){
	$id = mysqli_real_escape_string($con,$_POST['delete']);
 
	$delete = mysqli_query($con,"DELETE FROM `footer_data` WHERE `intId`=$id");
	if($delete){
		echo '<script>alert("Deleted Successfully");</script>';
		echo "<script>window.location.replace('footer_data.php');</script>";
		
	}else{
		echo '<script>alert("Something went wrong");</script>';
	}
}
/* end category delete code */

?>
<div id="page-wrapper">

	<div class="row">
		<!-- Page Header -->
		<div class="col-lg-12">
			<h1 class="page-header">Footer Data </h1>
		</div>
		<!--End Page Header -->
	</div>
	<div class="row">
		<div class="col-sm-12">
			<div class="panel panel-default">
				<div class="panel-heading"><h3 class="panel-title">Add <span style="color:red;float:right">* Required</span></h3></div>
				<div class="panel-body">
					<div class=" form">
						<form class="cmxform form-horizontal tasi-form" id="commentForm" method="post" action="" novalidate="novalidate" enctype="multipart/form-data">
							<div class="form-group ">
								<label for="cname" class="control-label col-lg-2">Name <span style="color:red;">*</span></label>
								<div class="col-lg-10">
									<input class=" form-control" id="cname" name="name" type="text" required="required" aria-required="true">
								</div>
							</div>
							<div class="form-group ">
								<label for="cemail" class="control-label col-lg-2">Link </label>
								<div class="col-lg-10">
								    <input class=" form-control" id="cname" name="link" type="" required="required" aria-required="true">
								</div>
							</div>
							<!--<div class="form-group ">
								<label for="cemail" class="control-label col-lg-2">Choose Type </label>
								<div class="col-lg-10">
								    <select class=" form-control"   name="type" >
								        <option value="Popular Links">Popular Links</option>
								        <option value="Hotels & Restaurants">Hotels & Restaurants</option>
								         <option value="Enquiry">Enquiry</option>
								        <!--<option value="Terms & Conditions">Terms & Conditions</option>-- >
								    </select>   
								</div>
							</div>--> 
                        	<div class="form-group ">
								<label for="cemail" class="control-label col-lg-2">Choose Type </label>
								<div class="col-lg-10">
								    <select class=" form-control"   name="type" >
								        <option value="Popular Links">Popular Links</option>
								        <option value="Blogs & Pages">Blogs & Pages</option>
								         <option value="Other Information">Other Information</option>
								        <!--<option value="Terms & Conditions">Terms & Conditions</option>-->
								    </select>   
								</div>
							</div> 
						   
							<div class="form-group">
								<div class="col-lg-offset-2 col-lg-10">
									<button class="btn btn-success waves-effect waves-light"  name="category_insert" type="submit">Submit</button>
								</div>
							</div>
						</form>
					</div> <!-- .form -->
				</div> <!-- panel-body -->
			</div> <!-- panel -->
		</div> <!-- col -->

	</div> <!-- End row -->
	

	<div class="panel">
		
		<div class="panel-body">
			<div class="row">
				<div class="col-sm-6">
					<div class="m-b-30">
						
					</div>
				</div>
			</div>
			<table class="table table-bordered table-striped" id="">
				<thead>
					<tr>
						<th>S.no.</th>
					
						<th>Name</th>
						<th>Link</th>
						<th>Type</th>
						<th>Edit</th>
						<th>Delete</th>
					</tr>
				</thead>
				<tbody>
					<?php  
						$q      = "SELECT * FROM `footer_data`";
						$query  = mysqli_query($con,$q);
						$sno=1;
						while($row = mysqli_fetch_object($query)){
						        
						    
							echo '<tr class="gradeX">
										<td>'.$sno.'</td>
										
										<td>'.$row->varName.'</td>
										<td>'.$row->varLink.'</td>
									 	<td>'.$row->varType.'</td> 
								 
										<td class="actions">
											<a href="#" class="on-default edit-row"><i class="fa fa-pencil" data-toggle="modal" data-target="#'.$row->intId.'"></i></a>
										</td>
										<td>
											<a href="#" class="on-default edit-row"><i class="fa fa-trash-o" data-toggle="modal" data-target="#del_'.$row->intId.'"></i></a>
										</td>
										<!-- Update Category -->
<div class="modal fade" id="'.$row->intId.'" role="dialog">
<div class="modal-dialog modal-md">

<!-- Modal content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">&times;</button>
<h4 class="modal-title">Update </h4>
</div>
<div class="modal-body">
<form class="cmxform form-horizontal tasi-form" id="commentForm" method="post" action="" novalidate="novalidate" enctype="multipart/form-data">
 
<div class="row">
	<div class="form-group ">
		<label for="cname" class="control-label col-lg-2">Name <span style="color:red;">*</span></label>
		<div class="col-lg-10">
			<input class=" form-control" id="cname" name="name" type="text" required="required" aria-required="true" value="'.$row->varName.'">
		</div>
	</div>
</div>
<br />
  
<div class="row">
	<div class="form-group ">
		<label for="cname" class="control-label col-lg-2">Link <span style="color:red;">*</span></label>
		<div class="col-lg-10">
			<input class=" form-control" id="cname" name="link" type="text" required="required" aria-required="true" value="'.$row->varLink.'">
		</div>
	</div>
</div>
<br />
<div class="row">
	<div class="form-group ">
	<label for="cemail" class="control-label col-lg-2">Choose Type </label>
	<div class="col-lg-10">
	    <select class=" form-control"   name="type" >
	        <option value="Popular Links" '.(($row->varType=='Popular Links')?"selected":"").'>Popular Links</option>
	        <option value="Blogs & Pages" '.(($row->varType=='Blogs & Pages')?"selected":"").'>Blogs & Pages</option>
	         <option value="Other Information" '.(($row->varType=='Other Information')?"selected":"").'>Other Information</option>
	        <!--<option value="Terms & Conditions"  '.(($row->varType=='Terms & Conditions')?"selected":"").'>Terms & Conditions</option>-->
	    </select>   
	</div>
</div> 
</div>
<br />
<!--<div class="row">
	<div class="form-group ">
	   <label for="ccomment" class="control-label col-lg-2">SEO Title</label>
		<div class="col-lg-10">
			<input class="form-control "  type="text" name="title"  aria-required="true" value="'.$row->varMetaTitle.'">
		</div>
	</div>
</div>
<br />
<div class="row">
	<div class="form-group ">
	   <label for="ccomment" class="control-label col-lg-2">SEO Keywords</label>
		<div class="col-lg-10">
			<textarea class="form-control"  name="keywords" required="required" aria-required="true" placeholder="Enter The Keywords">
			'.$row->varMetaKeywords.'</textarea>
		</div>
	</div>
</div>
<br />
<div class="row">
	<div class="form-group ">
		<label for="ccomment" class="control-label col-lg-2">SEO Description</label>
		<div class="col-lg-10">
			<textarea class="form-control"  name="description" required="required" aria-required="true" placeholder="Enter The Description">'.$row->txtMetaDescription.'</textarea>
		</div>
	</div>
</div>
<br />
<div class="row">
	<div class="form-group ">
		<label for="ccomment" class="control-label col-lg-2">Description <span style="color:red;">*</span> </label>
		<div class="col-lg-10">
			<textarea class="form-control ckeditor" id="js-my-textarea1" name="comment" required="required" aria-required="true" placeholder="Enter The Description">'.$row->txtDescription.'</textarea>
		</div>
	</div>
</div>-->
<br />
<div class="row">
	<div class="form-group">
		<div class="col-lg-offset-2 col-lg-10">
			<button class="btn btn-success waves-effect waves-light"  name="category_update" type="submit" value="'.$row->intId.'">Update</button>
		</div>
	</div>
</div>
</form>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</div>

</div>
</div>
<!-- Package Delete Modal -->
<div class="modal fade" id="del_'.$row->intId.'" role="dialog">
<div class="modal-dialog modal-sm">

<!-- Modal content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">&times;</button>
<h4 class="modal-title">Delete   </h4>
</div>
<div class="modal-body">
<p>Are you sure, you want to delete this  ?</p>
</div>
<div class="modal-footer">
<form  method="post">
<button type="submit"  value="'.$row->intId.'" class="btn btn-danger" name="delete">Yes</button></a>
<button type="button" class="btn btn-default" data-dismiss="modal">No</button>
</form>
</div>
</div>

</div>
</div>
									</tr>';
									$sno++;
						}
					?>
					
				</tbody>
			</table>
		</div>
		<!-- end: page -->
<!-- <a href="category.php?id='.$row->intId.'&action=delete" class="on-default remove-row"><i class="fa fa-trash-o"></i></a>  -->
	</div> <!-- end Panel -->

<?php 
include("footer.php");
?>