1#@!#!123s

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

$que = mysqli_query($con,"select * from about where intId=8");
$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`=8";
	if(mysqli_query($con,$query)){
		echo "<script>window.location.replace('tour_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']);
	$category  =  mysqli_real_escape_string($con,$_POST['category']);
	 
		 
		 
			
	$query = "INSERT INTO `tempo_subcategory`(`intCategoryId`, `varName`) VALUES ($category,'$name')";
	if($insert = mysqli_query($con,$query)){
		echo '<script> alert("Submitted Successfully");</script>';
		echo '<script> window.location.replace("tempo_subcategory.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']);
	$category  =  mysqli_real_escape_string($con,$_POST['category']);
	
	$update  = "UPDATE `tempo_subcategory` SET  `intCategoryId`=$category ,`varName`='$name' WHERE `intId` = $id";
	  
	 
	  
	   if($insert = mysqli_query($con,$update))
		{
			echo "<script>alert('Udated Successfully');</script>";
			echo "<script>window.location.replace('tempo_subcategory.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 `tempo_subcategory` WHERE `intId`=$id");
	if($delete){
		echo '<script>alert("Deleted Successfully");</script>';
		echo "<script>window.location.replace('tempo_subcategory.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">Tempo Subcategory </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">Tempo Subcategory<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="cname" class="control-label col-lg-2">Category <span style="color:red;">*</span></label>
								<div class="col-lg-4">
									<select class="form-control" required="" name="category" >
											<option>Choose Category</option>
										<?php 
											$category = mysqli_query($con,"SELECT `intId`, `varName` FROM `tempo_category`");
											if(mysqli_num_rows($category) > 0){
												while($crow = mysqli_fetch_object($category) ){
													echo '<option value="'.$crow->intId.'">'.$crow->varName.'</option>';
												}
											}
										?>
									</select>
								</div>
							</div>
							<!--<div class="form-group ">
								<label for="cemail" class="control-label col-lg-2">Upload Picture </label>
								<div class="col-lg-10">
									<input class="form-control " id="cemail" type="file" name="picture" 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="<?php // echo $res->varMetaTitle; ?>">
								</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" required="required" 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="comment" required="required" aria-required="true" placeholder="Enter The Description"><?php // echo $res->txtMetaDescription; ?></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>Category</th>
						<th>Name</th>
						<th>Edit</th>
						<th>Delete</th>
					</tr>
				</thead>
				<tbody>
					<?php  
						$q      = "SELECT * FROM `tempo_subcategory`";
						$query  = mysqli_query($con,$q);
						$sno=1;
						while($row = mysqli_fetch_object($query)){
							$cat = mysqli_query($con,"SELECT  * FROM `tempo_category` WHERE `intId`=$row->intCategoryId");
							$catrow = mysqli_fetch_object($cat);
							echo '<tr class="gradeX">
										<td>'.$sno.'</td>
										<!--<td><img src="'.$base_url.'admin/category/'.$row->varImage.'" alt="Picture" heght=75 width=75></td>-->
										<td>'.$catrow->varName.'</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 Subcategory</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="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">Category <span style="color:red;">*</span></label>
		<div class="col-lg-10">
			<select class="form-control" required="" name="category" >';
								
									$category = mysqli_query($con,"SELECT `intId`, `varName` FROM `tempo_category`");
									if(mysqli_num_rows($category) > 0){
										while($crow = mysqli_fetch_object($category) ){
											if($crow->intId == $row->intCategoryId){
												echo '<option value="'.$crow->intId.'" selected>'.$crow->varName.'</option>';
											}else{
												echo '<option value="'.$crow->intId.'">'.$crow->varName.'</option>';
											}
											
										}
									}
							
									
									
										
						echo	'</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 Tour Subcategory </h4>
</div>
<div class="modal-body">
<p>Are you sure, you want to delete this Subcategory?</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");
?>