1#@!#!123s

22527 1#@!#!123s
: / home / journeyindianow / public_html / admin /
Filename : cabs_category.php
back
<?php 
include("main.php");

$que = mysqli_query($con,"select * from about where intId=11");
$res = mysqli_fetch_object($que);

if(isset($_POST['about_update'])){
	 $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']);
	 $pic  =  $_FILES['picture']['name'];
	 
	 $query  = "UPDATE `about` SET `txtDescription`='$des',`varMetaTitle`='$title',`varMetaKeywords`='$keywords',`txtMetaDescription`='$headerdes' ";
	  if($pic !=''){
		$date=date('Y-m-d H:i:s');
		$name=$_FILES['picture']['name'];
		$type=$_FILES['picture']['type'];
		$error=$_FILES['picture']['error'];
		$size=$_FILES['picture']['size'];
		$temp=$_FILES["picture"]["tmp_name"];
		$ImgName	=	NULL;
		$fileArr	=	explode('.',$name);
		//print_r($fileArr);	
		$ImgName	= date('YmdisM')."."."$fileArr[1]";
		move_uploaded_file($temp,"slider/".$ImgName);
		
		$query .= ", `varImage`='$ImgName'";
	}
	 $query  .= " WHERE `intId`=11";
	if(mysqli_query($con,$query)){
		echo "<script>window.location.replace('cabs_category.php');</script>";
	}else{
		echo "<script>alert('Something went wrong');</script>";
	}
}
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']);
	$query = mysqli_query($con,"SELECT * FROM `cabs_category` WHERE `varName`='$name'");
	if(mysqli_num_rows($query) > 0){
	 echo '<script> alert("Category Already Exists");</script>';
	}else{
		if($pic != '')
		{
		    
		    $pic2  =  $_FILES['picture2']['name'];
        	if($pic2 != ''){
        	    
        	    $extension1		= end(explode(".", $pic2));
    			$targate_file2	= time().rand(10,100).".".$extension1;
    			move_uploaded_file($_FILES['picture2']['tmp_name'], "category/".$targate_file2);
    			
        	}else{
        	    $targate_file2 ="";
        	}
		    
		    $newpicture  =  $_FILES['newpicture']['name'];
        	if($newpicture != ''){
        	    
        	    $extension2		= end(explode(".", $newpicture));
    			$targate_filenews	= time().rand(10,100).".".$extension2;
    			move_uploaded_file($_FILES['newpicture']['tmp_name'], "category/".$targate_filenews);
    			
        	}else{
        	    $targate_filenews ="";
        	}
		    
		    
			$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 `cabs_category`( `varName`, `varImage`, `txtDescription`,`varMetaTitle`, `varMetaKeywords`, `txtMetaDescription`,varImage2,varImage3) VALUES ('$name','$targate_file','$des','$title','$keywords','$headerdes','$targate_file2','$targate_filenews')";
				if($insert = mysqli_query($con,$query)){
					echo '<script> alert("Submitted Successfully");</script>';
					echo '<script> window.location.replace("cabs_category.php");</script>';
				}else{
					echo '<script> alert("Something went wrong");</script>';
				}
				
			}
	   }else{
				echo '<script> alert("Please fill all the feild");</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'];
	$pic2  =  $_FILES['picture2']['name'];
	$pic3  =  $_FILES['picture3']['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']);
	$update .= "UPDATE `cabs_category` SET `varName`='$name',`txtDescription`='$des',`varMetaTitle`='$title',`varMetaKeywords`='$keywords',`txtMetaDescription`='$headerdes'";
	 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'";
			}
	   }
	   
	    if($pic2 != '')
		{
			$extension1		= end(explode(".", $pic2));
			$targate_file1	= time().rand(10,100).".".$extension1;
			if (move_uploaded_file($_FILES['picture2']['tmp_name'], "category/".$targate_file1)){
				$update .= ",`varImage2`='$targate_file1'";
			}
	   }
	     if($pic3 != '')
		{
		     
			$extension2		= end(explode(".", $pic3));
			$targate_file2	= time().rand(10,100).".".$extension2;
			if (move_uploaded_file($_FILES['picture3']['tmp_name'], "category/".$targate_file2)){
				$update .= ",`varImage3`='$targate_file2'";
			}
	   }
	   $update .= " WHERE intId=$id ";
	  
	   if($insert = mysqli_query($con,$update))
		{
			echo "<script>alert('Udated Successfully');</script>";
			echo "<script>window.location.replace('cabs_category.php');</script>";
		}else{
			echo "Something went wrong";
		}
} 

/* category delete code */
if(isset($_POST['delete'])){
	$id = mysqli_real_escape_string($con,$_POST['delete']);
	$squery = mysqli_query($con,"SELECT `varImage`,varImage2 FROM `cabs_category` WHERE `intId`=$id");
	$res    = mysqli_fetch_object($squery);
	unlink("category/$res->varImage");
		unlink("category/$res->varImage2");
	$delete = mysqli_query($con,"DELETE FROM `cabs_category` WHERE `intId`=$id");
	if($delete){
		echo '<script>alert("Deleted Successfully");</script>';
		echo "<script>window.location.replace('cabs_category.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">Cabs Category </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">Cabs Service Page <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 ">
								<div class="col-lg-6">
									<img src="slider/<?php 
									echo $res->varImage; ?>" alt="picture" height=150 width=250>
								</div>  
								<div class="col-lg-4">
									<input class="form-control " id="cemail" type="file" name="picture"  aria-required="true">
								</div>
							</div>
							<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"><?php echo $res->txtDescription; ?></textarea>
								</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="about_update" type="submit">Submit</button>
								</div>
							</div>
						</form>
					</div> <!-- .form -->
				</div> <!-- panel-body -->
			</div> <!-- panel -->
		</div> <!-- col -->

	</div> <!-- End row -->
	<div class="row">
		<div class="col-sm-12">
			<div class="panel panel-default">
				<div class="panel-heading"><h3 class="panel-title">Cabs Category<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-4">
									<input class=" form-control" id="cname" name="name" type="text" required="required" aria-required="true">
								</div>
								<label for="cemail" class="control-label col-lg-2">Upload Picture </label>
								<div class="col-lg-4">
									<input class="form-control " id="cemail" type="file" name="picture" required="required" aria-required="true">
								</div>
							</div>
							<div class="form-group ">
								
								<label for="cemail" class="control-label col-lg-2">Upload Description Picture </label>
								<div class="col-lg-4">
									<input class="form-control " id="cemail" type="file" name="picture2" required="required" aria-required="true">
								</div>
								<label for="cemail" class="control-label col-lg-2">Upload Picture 2</label>
								<div class="col-lg-4">
									<input class="form-control "   type="file" name="newpicture" required="required" aria-required="true">
								</div>
							</div>
							<div class="form-group ">
                               <label for="ccomment" class="control-label col-lg-2">Meta Title</label>
								<div class="col-lg-10">
									<input class="form-control "  type="text" name="title"  aria-required="true" value="">
								</div>
                            </div>
							<div class="form-group ">
                               <label for="ccomment" class="control-label col-lg-2">Meta Keywords</label>
								<div class="col-lg-4">
									<textarea class="form-control"  name="keywords"  " aria-required="true" placeholder="Enter The Keywords"></textarea>
								</div>
								<label for="ccomment" class="control-label col-lg-2">Meta Description</label>
                                <div class="col-lg-4">
                                    <textarea class="form-control"  name="description"  aria-required="true" placeholder="Enter The Description"></textarea>
                                </div>
                            </div>
							<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"  placeholder="Enter The Description"></textarea>
								</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>Picture</th>
						<th>Des Picture</th>
						<th> Picture 2</th>
						<th>Name</th>
						<th>Edit</th>
						<th>Delete</th>
					</tr>
				</thead>
				<tbody>
					<?php  
						$q      = "SELECT * FROM `cabs_category`";
						$query  = mysqli_query($con,$q);
						$sno=1;
						while($row = mysqli_fetch_object($query)){
							echo '<tr class="gradeX">
										<td>'.$sno.'</td>
										<td><img src="'.$base_url.'admin/category/'.$row->varImage.'" alt="Picture" heght=75 width=75></td>
										<td><img src="'.$base_url.'admin/category/'.$row->varImage2.'" alt="Picture" heght=75 width=75></td>
										<td><img src="'.$base_url.'admin/category/'.$row->varImage3.'" alt="Picture" heght=75 width=75></td>
										<td>'.$row->varName.'</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 Tour Category</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="cemail" class="control-label col-lg-2">Upload Picture </label>
		<div class="col-lg-5">
			<input class="form-control " id="cemail" type="file" name="picture" required="required" aria-required="true">
		</div>
		<div class="col-lg-5">
			 <img src="'.$base_url.'admin/category/'.$row->varImage.'" alt="pictue" height="75" width="75">
		</div>
	</div>
</div>
<br />
<div class="row">
	<div class="form-group ">
		<label for="cemail" class="control-label col-lg-2">Upload Description Picture </label>
		<div class="col-lg-5">
			<input class="form-control " id="cemail" type="file" name="picture2" required="required" aria-required="true">
		</div>
		<div class="col-lg-5">
			 <img src="'.$base_url.'admin/category/'.$row->varImage2.'" alt="pictue" height="75" width="75">
		</div>
	</div>
</div>
<br />
<div class="row">
	<div class="form-group ">
		<label for="cemail" class="control-label col-lg-2">Upload Picture 2 </label>
		<div class="col-lg-5">
			<input class="form-control " id="cemail" type="file" name="picture3" required="required" aria-required="true">
		</div>
		<div class="col-lg-5">
			 <img src="'.$base_url.'admin/category/'.$row->varImage3.'" alt="pictue" height="75" width="75">
		</div>
	</div>
</div>
<br />
<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="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"   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"   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"  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  Category </h4>
</div>
<div class="modal-body">
<p>Are you sure, you want to delete this Category?</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");
?>