submit_rating.php

    <?php

    //submit_rating.php
    $conn = mysqli_connect("localhost", "root", "", "admin1");

    if(isset($_POST["rating_data"])) {
        $query = "INSERT INTO review_table (user_name, user_rating, user_review, datetime) VALUES (?, ?, ?, ?)";
        
        $statement = mysqli_prepare($conn, $query);
        mysqli_stmt_bind_param($statement, "siss", $_POST["user_name"], $_POST["rating_data"], $_POST["user_review"], time());
        mysqli_stmt_execute($statement);
        
        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();
        
        $query = "SELECT * FROM review_table ORDER BY review_id DESC";
        $result = mysqli_query($conn, $query);
        
        while($row = mysqli_fetch_assoc($result)) {
            $review_content[] = array(
                '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"])
            );

            switch($row["user_rating"]) {
                case 5:
                    $five_star_review++;
                    break;
                case 4:
                    $four_star_review++;
                    break;
                case 3:
                    $three_star_review++;
                    break;
                case 2:
                    $two_star_review++;
                    break;
                case 1:
                    $one_star_review++;
                    break;
            }

            $total_review++;
            $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);
    }

    ?>