if (empty($_POST)) { header('Location: index.php'); } else { require_once '../lib/Review.class.php'; require_once '../lib/User.class.php'; require_once '../lib/Restaurant.class.php'; $user_id = $_POST['user_id']; $restaurant_id = $_POST['restaurant_id']; $rate = $_POST['rating']; $content = $_POST['content']; $fields = array('user_id' => $user_id, 'restaurant_id' => $restaurant_id, 'rating' => $rate, 'content' => $content); try { $new_review = new Review(); $restaurant = new Restaurant(); if ($restaurant->find($restaurant_id)) { $original_rating = $restaurant->get_rating(); $new_rating = $rate; $all_reviews = Review::get_all_reviews_by_restaurant($restaurant_id); // var_dump($all_reviews); if ($all_reviews) { $overall_rate = 0; while ($a_review = $all_reviews->fetch_row()) { $overall_rate += $a_review[4]; } $new_rating = ($overall_rate + $rate) / ($all_reviews->num_rows + 1); } $new_review->create($fields); $restaurant->update_rating($new_rating); $success = true; $message = 'Adding review complete! Your review will be attached to the restaurant page shortly.'; }