Code php rating review in post năm 2024

Star rating feature allows the user to grade the service, product, web page, etc. Star rating also allows the owner to understand the user preference and improve the quality accordingly. As for the general users, for example, in a shopping cart application with star rating will help users to search for highly rated products.

Implementing five-star rating using PHP is very simple. We have seen several examples for the PHP star rating system. Let us create a PHP star rating system only with JavaScript without loading jQuery or any third party libraries.

See dynamic star rating with jQuery post if you want PHP star rating code with jQuery. In this example, the five-star rating option is shown to collect user rating for restaurants. The user-based rating is added by initializing userid at the beginning of the code. You can replace this initialization by integrating your user authentication code.

Once the user rates a restaurant, then he could not rate the same again.

The restaurant and its ratings are stored in the database. The restaurant results are listed row by row with the star rating option. When the user rates a restaurant the AJAX call will be sent to the PHP to insert rating for the restaurant. The added ratings are displayed with the highlighted stars.

This screenshot shows the list of restaurants with the five-star rating system.

Database Script for Star Rating

This SQL script is with the create statements and the data dump for the tbl_rating and tbl_restaurant tables.

--  
-- Table structure for table `tbl_rating`  
--
CREATE TABLE `tbl_rating` (  
  `id` int(11) NOT NULL,  
  `user_id` int(11) NOT NULL DEFAULT '1',  
  `restaurant_id` int(11) NOT NULL,  
  `rating` int(2) NOT NULL,  
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP  
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--  
-- Table structure for table `tbl_restaurant`  
--
CREATE TABLE `tbl_restaurant` (  
  `id` int(11) NOT NULL,  
  `name` varchar(100) NOT NULL,  
  `address` varchar(150) NOT NULL  
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--  
-- Dumping data for table `tbl_restaurant`  
--
INSERT INTO `tbl_restaurant` (`id`, `name`, `address`) VALUES  
(1, 'Malaysian Multi Cusine Restaurant', '12, FGH Enclave'),  
(2, 'Cafe Monarch', '78, GNT Park');
--  
-- Indexes for dumped tables  
--
--  
-- Indexes for table `tbl_rating`  
--  
ALTER TABLE `tbl_rating`  
  ADD PRIMARY KEY (`id`);
--  
-- Indexes for table `tbl_restaurant`  
--  
ALTER TABLE `tbl_restaurant`  
  ADD PRIMARY KEY (`id`);
--  
-- AUTO_INCREMENT for dumped tables  
--
--  
-- AUTO_INCREMENT for table `tbl_rating`  
--  
ALTER TABLE `tbl_rating`  
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--  
-- AUTO_INCREMENT for table `tbl_restaurant`  
--  
ALTER TABLE `tbl_restaurant`  
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;  
COMMIT;  

List Restaurants with Star Rating Option

This code is used to fetch the restaurants details from the MySQL database and to list them with the star rating option. The stars are highlighted by hovering on the rating element.

On page load, the AJAX call will get and display the user added rating with the highlighted stars. Each restaurant record shows the graphical representation of the five-star rating with overall rating count.

  
    
  
        
Star Rating System using PHP and Javascript
  
          
    
  

  

getRatingData.php

This PHP code is called with an AJAX request to return the restaurant list with user rating data. It forms HTML response that will be received at the AJAX success callback.

  
 
' . $row['name'] . '
 
  
 
 ';  
    for ($count = 1; $count <= 5; $count ++) {  
        $starRatingId = $row['id'] . '_' . $count;  
        if ($count <= $userRating) {  
            $outputString .= '
&
# 9733;
';  
        } else {  
            $outputString .= '
&
# 9733;
';  
        }  
    } // endFor  
    $outputString .= '  
 
  
 
Total Reviews: ' . $totalRating . '
  
 
' . $row["address"] . '