MAINHACK

Viewing / Editing File: given-reviews.php

<?php
		include("header.php");
$uid=base64_decode($_REQUEST['uid']);
		$pid=base64_decode($_REQUEST['pid']);

if($_SESSION['login_id']==''){header("location:index.php"); }
$stmt1=$show->readwithdata('user','user_id',$_SESSION['login_id']);
$num1=$stmt1->rowCount();
if($num1>0){
	while($row=$stmt1->fetch(PDO::FETCH_ASSOC)){
	  
	  $uname=$row['name'];
        $uphone=$row['phone'];
        $uemail=$row['email'];
        $upassword=$row['password'];
        $usex=$row['sex'];
        $ustate=$row['state'];
        $ucity=$row['city'];
        $uaddress=$row['address'];
        $upincode=$row['pincode'];

}
    
}

$sq1=$show->readwithdata('product','product_id',$pid);
while($row1=$sq1->fetch(PDO::FETCH_ASSOC)){
$rtotal=$row1['review_total_num'];	    
$rating=$row1['review_num'];	    
}
	?>

<div class="inner-banner">
  <img src="images/banner2.jpg" alt="" class="inner-banner-img">
  <div class="container">
    <ul>
      <li><a href="given-reviews.php" class="active">Given Reviews</a></li> |
      <li><a href="index.php" class="">Home</a></li>    
    </ul>
  </div>
</div>

<div class="reviews-container">
        
    <div class="inner-title">
        <h2>Given Reviews</h2>
        <h3>Reviews</h3>
    </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">
                            <span class="RatingGive">Rating - </span>
                            <div class="rate">
                                <input type="radio" id="star5" name="rating" value="5" required="">
                                <label for="star5" title="text">5 stars</label>
                                
                                <input type="radio" id="star4" name="rating" value="4" required="">
                                <label for="star4" title="text">4 stars</label>
                                
                                <input type="radio" id="star3" name="rating" value="3" required="">
                                <label for="star3" title="text">3 stars</label>
                                
                                <input type="radio" id="star2" name="rating" value="2" required="">
                                <label for="star2" title="text">2 stars</label>
                                
                                <input type="radio" id="star1" name="rating" value="1" required="">
                                <label for="star1" title="text">1 star</label>
                              </div>
                           	<input type="text" name="name" readonly value="<?=$uname?>" placeholder="Name *">
					    	<input type="text" name="phone" readonly value="<?=$uphone?>"  placeholder="Phone *"> 
							<input type="text" name="email" readonly value="<?=$uemail?>" placeholder="Email *"> 
							<input type="hidden" name="uid" value="<?=$_SESSION['login_id']?>"> 
							<input type="hidden" name="product_id" value="<?=$pid?>"> 	
                            <textarea name="review" 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(
    'name'=>$_POST['name'],
    'email'=>$_POST['email'],
    'review'=>$_POST['review'],
    'rating'=>$_POST['rating'],
    'user_id'=>$_POST['uid'],
    'status'=>'Not-Published',
    'date'=>date('Y-m-d'),
    'product_id'=>$_POST['product_id'],
       ); 
      $r=$show->insert('review',$data);
//   print_r($data); 
   if($r){
     if($rating==0){ 
         $rt=$_POST['rating']; 
              $rating_num=($rt)/1;

}else{
     $rt=($_POST['rating']+$rtotal);
      $rating_num=($rt)/($rating+1);
    }
     
     $sq1="update product set review_num=review_num+1,review_total_num=$rt,rating_num=".$rating_num." where product_id='".$_POST['product_id']."' ";
    //  echo $sq1;
      $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 = "review.php?pid='.$_REQUEST['pid'].'";
        });
    }, 1000);
</script>';
}
}

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

</div>

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

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: given-reviews.php

Server Info

System Features

User Info