MAINHACK

Viewing / Editing File: given-reviews.php

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

if($_SESSION['user_id']==''){header("location:index.php"); }
$stmt1=$show->readwithdata('user','user_id',$_SESSION['user_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="given-reviews">	 
	<div class="container">	
        <div class="page-TITLE">
            <h2>Give Your Reviews</h2>
            
        </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">
						    <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['user_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