Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /var/www/html/netphim/code/ajax/ |
<?php
global $CORE,$DB,$ob_user,$func;
$user_id = intval($ob_user->user_id);
$phim_id = $CORE->input['phim_id'];
$rating = $CORE->input['rating'];
$rating_ip = $ip;
// Check rating inside the table
$row_check = $DB->fetch_row($DB->query("SELECT rating_id FROM tb_rating WHERE phim_id='$phim_id' AND rating_ip='".$rating_ip."' LIMIT 1 "));
if(!$row_check){
$arr_insert = array('phim_id'=>$phim_id,'rating_ip'=>$rating_ip,'rating_value'=>$rating,'user_id'=>$user_id,'rating_timestamp'=>time());
$DB->do_insert('tb_rating',$arr_insert);
}else {
$arr_update = array('rating_value'=>$rating,'rating_timestamp'=>time());
$DB->do_update('tb_rating',$arr_update," WHERE rating_id='".$row_check['rating_id']."' ");
}
// fetch rating
$r_rating = $DB->fetch_row($DB->query("SELECT ROUND(AVG(rating_value),1) as numRating,count(*) as total FROM tb_rating WHERE phim_id='$phim_id' "));
$numRating = $r_rating['numRating'];
$DB->query("UPDATE tb_phim SET phim_danhgia='".$numRating."',phim_count_danhgia='".$r_rating['total']."' WHERE phim_id='$phim_id' ");
$return_arr = array("numRating"=>$numRating,'total_rating'=>$r_rating['total']);
echo json_encode($return_arr);
?>