MAINHACK

Viewing / Editing File: given-reviews.php

<?php include('header.php');

$mid=base64_decode($_REQUEST['mid']);
$uid=base64_decode($_REQUEST['uid']);
$oid=base64_decode($_REQUEST['oid']);
$url=$_REQUEST['url'];
$menu=base64_decode($_REQUEST['menu']);
  
$stmt1=$show->readwithdata('customers','customer_id',$uid);
$num1=$stmt1->rowCount();
if($num1>0){
	while($row=$stmt1->fetch(PDO::FETCH_ASSOC)){
	  
    $uname=$row['name'];
    $uphone=$row['phone'];
    $uemail=$row['email'];

}
}  
    ?>

<div class="banner-inner">
	<img src="images/inner-banner.jpg" alt="" class="banner-img">
</div>

<div class="given-reviews">	 
	<div class="container">	
        <div class="title-section text-center">
            <p class="w3ls-title-sub">Reviews </p>
            <h3 class="w3ls-title">Give your<span> Reviews</span></h3>
        </div>
        
        
	</div>
</div>

<div class="container">	 
		<div class="w3_login_module1">
				<div class="module form-module" style="max-width:100% !important; margin-top:0;">
				    <div class="form">
						<form method="post">
							<div class="rating1">Give Rating
								<span class="starRating">
								<input id="rating5" type="radio" name="rating" value="5" required>
								<label for="rating5">5</label>
								<input id="rating4" type="radio" name="rating" value="4" required>
								<label for="rating4">4</label>
								<input id="rating3" type="radio" name="rating" value="3" required>
								<label for="rating3">3</label>
								<input id="rating2" type="radio" name="rating" value="2" required>
								<label for="rating2">2</label>
								<input id="rating1" type="radio" name="rating" value="1" required>
								<label for="rating1">1</label>
								</span>
							</div>
							<input type="text" name="name" readonly value="<?=$uname?>" placeholder="Name *">
							<input type="text" name="phone" readonly value="<?=$uphone?>"  placeholder="Phone *"> 
							<input type="email" name="email" readonly value="<?=$uemail?>" placeholder="Email *"> 
							<input type="hidden" name="mid" value="<?=$mid?>"> 
							<input type="hidden" name="uid" value="<?=$uid?>"> 
							<input type="hidden" name="oid" value="<?=$oid?>"> 
							<input type="hidden" name="menu" value="<?=$menu?>"> 
							<textarea name="msg" required="" placeholder="Share your experience with us *"></textarea>
							<input type="submit" name="rev" value="Post your Review" class="btn btn-success">
						</form>
<?php 
if(isset($_POST['rev'])){
   $data=array(
    'user_id'=>$_POST['uid'],
    'name'=>$_POST['name'],
    'email'=>$_POST['email'],
    'review'=>$_POST['msg'],
    'rating'=>$_POST['rating'],
    'maker_id'=>$_POST['mid'],
    'order_id'=>$_POST['oid'],
    'status'=>'Not-Published',
    'date'=>date('Y-m-d'),
    'menu_id'=>$_POST['menu'],
       ); 
      $r=$show->insert('review',$data);
      
   if($r){
       $n_r=$_POST['rating']+$rating; //echo $review;
       $rv=$_POST['review']+1; //echo $rv;
      $sq="update food_maker set no_of_review=no_of_review+1,review_total=review_total+".$_POST['rating'].",rating=review_total/($rv) where maker_id='".$_POST['mid']."' ";
    //  echo $sq;
      $s=$con->prepare($sq);
    $s->execute();
     $sq1="update menu_items set review_num=review_num+1,review_total_num=review_total_num+".$_POST['rating'].",rating_num=review_total_num/($rv) where menu_id='".$_POST['menu']."' ";
      $s1=$con->prepare($sq1);
    $s1->execute();
   echo '<script>
        setTimeout(function() {
        swal({
            title: "OK!",
            text: "Your review has been posted.Thank you for your time.",
            type: "success"
        }, function() {
            window.location = "'.$url.'";
        });
    }, 1000);
</script>';
}
}

?>						
					</div>
				</div>
		</div>
</div>

</div>

<style>

</style>

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

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: given-reviews.php

Server Info

System Features

User Info