1#@!#!123s

22527 1#@!#!123s
: / home / journeyindianow / public_html / admin /
Filename : testimonial.php
back
<?php 
include("main.php");
/* show div on front page */
if(isset($_POST['permission'])){
	$id  	= mysqli_real_escape_string($con,$_POST['id']);
	$val 	= mysqli_real_escape_string($con,$_POST['permission']);
	//echo "UPDATE `permission` SET `enumStatus`='$val' WHERE `intId` = $id";
	$update = mysqli_query($con,"UPDATE `permission` SET `enumStatus`='$val' WHERE `intId` = $id");
	if($update){
			echo "<script>alert('Updated Successfully');</script>";
			echo "<script>window.location.replace('testimonial.php');</script>";
	}else{
		echo "<script>alert('Something Went Wrong');</script>";
	}
}

/* show div on front page */


/*  testimonial insert  */
if(isset($_POST['testimonial_insert']) and $_POST['name']!=''   and $_POST['comment']!=''){
	$name 		 =  mysqli_real_escape_string($con,$_POST['name']);
	$des  		 =  mysqli_real_escape_string($con,$_POST['comment']);
	$designation  =  mysqli_real_escape_string($con,$_POST['designation']);
	$pic  =  $_FILES['picture']['name'];
	
	 if($pic != ''){
		$extension		= end(explode(".", $pic));
			$targate_file	= time().rand(10,100).".".$extension;
			if (move_uploaded_file($_FILES['picture']['tmp_name'], "testimonial/".$targate_file)){
			$query = "INSERT INTO testimonial (varName, txtDescription, `varImage`,intStatus ,`varDesignation`)VALUES ('$name', '$des','$targate_file',0,'$designation')";
					if($insert = mysqli_query($con,$query)){
						echo '<script>window.location.href("testimonial.php");</script>';
					}else{
						echo '<script>alert("Something went wrong");</script>';
					}
			}else{
						echo '<script>alert("Something went wrong");</script>';
					}
	}else{
		echo '<script>alert("Select Image First");</script>';
	}
		
}
/*end  testimonial insert  */
/* testimonial update */
if(isset($_POST['testimonial_update'])){
	$id 		  =  mysqli_real_escape_string($con,$_POST['testimonial_update']);
	$name 		  =  mysqli_real_escape_string($con,$_POST['name']);
	$des  		  =  mysqli_real_escape_string($con,$_POST['comment']);
	$designation  =  mysqli_real_escape_string($con,$_POST['designation']);
	$pic  =  $_FILES['picture']['name'];
	$update1 = "UPDATE `testimonial` SET `varName`='$name',`varDesignation`='$designation',`txtDescription`='$des'";
	if($pic !=''){
		$extension		= end(explode(".", $pic));
			$targate_file	= time().rand(10,100).".".$extension;
			if (move_uploaded_file($_FILES['picture']['tmp_name'], "testimonial/".$targate_file)){
				$update2 = ", `varImage`='$targate_file'";
			}
	}
	$update3= "WHERE intId=$id";
	$update = $update1.$update2.$update3;
	   if($insert = mysqli_query($con,$update))
		{
			echo "<script>alert('Updated Successfully');</script>";
			echo "<script>window.location.replace('testimonial.php');</script>";
		}else{
			echo "Something went wrong";
		}
} 
/*  testimonial update */
/*  testimonial Delete */
if(isset($_POST['testimonial_delete'])){
	$id 	=  mysqli_real_escape_string($con,$_POST['testimonial_delete']);
	$query 	 = mysqli_query($con,"SELECT `varImage` FROM `testimonial` WHERE intId=$id");
	$res     = mysqli_fetch_object($query);
	unlink("testimonial/$res->varImage");
	$updatequery = "DELETE FROM `testimonial` WHERE intId=$id";
	   
	   if($update = mysqli_query($con,$updatequery))
		{
			echo "<script>alert('Deleted Successfully');</script>";
			echo "<script>window.location.replace('testimonial.php');</script>";
		}else{
			echo "<script>alert('Something went wrong');</script>";
		}
} 
/* end testimonial Delete */
?>
<!--  page-wrapper -->
<div id="page-wrapper">

	<div class="row">
		<!-- Page Header -->
		<div class="col-lg-12">
			<h1 class="page-header">Reviews </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 Reviews
					 <span style="color:red;float:right">* Required</span>
					<!--<span style="float:right;"><button class="btn btn-info btn-xs text-right" data-toggle="modal" data-target="#permission">Testimonial On/Off</button></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" >
								</div>
							</div>
							<div class="form-group ">
								<label for="cemail" class="control-label col-lg-2">Designation</label>
								<div class="col-lg-10">
									<input class="form-control " id="cemail" type="text" name="designation" required="required" >
								</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="" >
								</div>
							</div>
							<div class="form-group ">
								<label for="ccomment" class="control-label col-lg-2">Description </label>
								<div class="col-lg-10">
									<textarea class="form-control ckeditor" id="js-my-textarea1" name="comment"  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="testimonial_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="datatable-editable">
				<thead>
					<tr>
						<th>S.no.</th>
						<th>Picture</th>
						<th>Name</th>
						<th>Designation</th>
						<th>Edit</th>
						<th>Delete</th>
					</tr>
				</thead>
				<tbody>
					<?php  
						$q      = "SELECT `intId`, `varName`, `txtDescription`, `varDesignation`, `varImage`, `intStatus` FROM `testimonial`";
						$query  = mysqli_query($con,$q);
						$sno=1;
						while($row = mysqli_fetch_object($query)){
							echo '<tr class="gradeX">
										<td>'.$sno.'</td>
										<td><img src="testimonial/'.$row->varImage.'" height="75" widht="75"></td>
										<td>'.$row->varName.'</td>
										<td>'.$row->varDesignation.'</td>
										<td class="actions">
											<a href="#" class="on-default edit-row"><i class="fa fa-pencil" data-toggle="modal" data-target="#edit_'.$row->intId.'"></i></a>
										</td>
										<td>
											<a href="#" class="on-default remove-row"><i class="fa fa-trash-o" data-toggle="modal" data-target="#del_'.$row->intId.'"></i></a>
										</td>
																								 <!--Update Testimonial Modal -->
<div class="modal fade" id="edit_'.$row->intId.'" role="dialog">
<div class="modal-dialog modal-lg">

<!-- 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 Reviews</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="" >
	</div>
	<div class="col-lg-5">
		<img src="testimonial/'.$row->varImage.'" 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"  value="'.$row->varName.'">
	</div>
</div> 
</div> 
<br/>
<div class="row">
<div class="form-group ">
	<label for="cemail" class="control-label col-lg-2">Designation</label>
	<div class="col-lg-10">
		<input class="form-control " id="cemail" type="text" name="designation" required="required"  value="'.$row->varDesignation.'">
	</div>
</div>
</div> 
<br/>
<div class="row">
<div class="form-group ">
	<label for="ccomment" class="control-label col-lg-2">Description </label>
	<div class="col-lg-10">
		<textarea class="form-control ckeditor" id="js-my-textarea1" name="comment"  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="testimonial_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>
<!-- 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 Reviews</h4>
</div>
<div class="modal-body">
<p>Are you sure, you want to delete this Record?</p>
</div>
<div class="modal-footer">
<form method="post">
<button class="btn btn-danger waves-effect waves-light"  name="testimonial_delete" type="submit" value="'.$row->intId.'">Yes</button>
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</form>
</div>
</div>

</div>
</div>	
										
									</tr>';
									$sno++;
						}
					?>
					
				</tbody>
			</table>
		</div>
		<!-- end: page -->

	</div> <!-- end Panel -->

						
						<div class="modal fade" id="permission" 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"> Testimonial Section</h4>
        </div>
		<?php 
			$perquery = mysqli_query($con,"SELECT * FROM `permission` WHERE `intId`=1");
			
			$perrow = mysqli_fetch_object($perquery);
				
			
			
		?>
        <div class="modal-body">
			<p>Are you sure, you want to <?php echo (($perrow->enumStatus == '1')?'Hide':'Show');?> Section Of Testimonial.  </p>
        </div>
        <div class="modal-footer">
			<form method="post">
				<input type="hidden" value="<?php echo $perrow->intId;?>" name="id">
				<button class="btn btn-danger waves-effect waves-light"  name="permission" type="submit" value="<?php echo (($perrow->enumStatus == '1')?'0':'1');?>">Yes</button>
				<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
			</form>
        </div>
      </div>
      
    </div>
  </div>	

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