$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.'; } } catch (Exception $e) { $success = false; $message = $e->getMessage(); } $return_result = array('success' => $success, 'message' => $message); echo json_encode($return_result); // //add review // $title = $POST['title']; // $content = $_POST['content']; // $rating = $_POST['rating']; // $date = date('Y-m-d'); // $restaurant_id = $POST['restaurant_id'];