PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
Copy Clear
Copy Format Clear
<?php //submit_rating.php date_default_timezone_set("Asia/Calcutta"); include 'config.php'; $order_id = $_POST["order_id"]; if(isset($_POST["rating_data"])) { $data = array( ':order_id' => $order_id, ':user_name' => $_POST["user_name"], ':user_rating' => $_POST["rating_data"], ':user_review' => $_POST["user_review"], ':datetime' => time() ); $query = " INSERT INTO review_table (order_id,user_name, user_rating, user_review, datetime) VALUES (:order_id,:user_name, :user_rating, :user_review, :datetime) "; $statement = $conn->prepare($query); $statement->execute($data); echo "Your Review & Rating Successfully Submitted"; } if(isset($_POST["action"])) { $average_rating = 0; $total_review = 0; $five_star_review = 0; $four_star_review = 0; $three_star_review = 0; $two_star_review = 0; $one_star_review = 0; $total_user_rating = 0; $review_content = array(); $stmt = $conn->prepare("SELECT * FROM review_table where order_id = :order_id"); //$stmt = $conn->prepare("SELECT * FROM review_table where order_id = 1"); $stmt = $conn->prepare("SELECT * FROM review_table"); $stmt->execute(['order_id' => $order_id]); $result = $stmt->fetchall(PDO::FETCH_ASSOC); foreach($result as $row) { $review_content[] = array( 'order_id' => $row["order_id"], 'user_name' => $row["user_name"], 'user_review' => $row["user_review"], 'rating' => $row["user_rating"], 'datetime' => date('l jS, F Y h:i:s A', $row["datetime"]) ); if($row["user_rating"] == '5') { $five_star_review++; } if($row["user_rating"] == '4') { $four_star_review++; } if($row["user_rating"] == '3') { $three_star_review++; } if($row["user_rating"] == '2') { $two_star_review++; } if($row["user_rating"] == '1') { $one_star_review++; } $total_review++; $total_user_rating = $total_user_rating + $row["user_rating"]; } $average_rating = $total_user_rating / $total_review; $output = array( 'average_rating' => number_format($average_rating, 1), 'total_review' => $total_review, 'five_star_review' => $five_star_review, 'four_star_review' => $four_star_review, 'three_star_review' => $three_star_review, 'two_star_review' => $two_star_review, 'one_star_review' => $one_star_review, 'review_data' => $review_content ); echo json_encode($output); } ?>
Show:  
Copy Clear