PHP Restaurant::get_rating示例

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.';
        }