mysql 五角星评价系统_php+mysql+html实现五角星评论功能

include_once ('connect.php');

$a_score = 0;

$b_score = 0;

$c_score = 0;

$d_score = 0;

$e_score = 0;

if (isset($_POST['a_score'])){

$a_score= $_POST['a_score'];

}

if (isset($_POST['b_score'])){

$b_score=$_POST['b_score'];

}

if (isset($_POST['c_score'])){

$c_score=$_POST['c_score'];

}

if (isset($_POST['d_score'])){

$d_score=$_POST['d_score'];

}

if (isset($_POST['e_score'])){

$e_score=$_POST['e_score'];

}

$vid = 3;

$uid = 5;

if (isset ($vid) && isset ($uid)) {

$query_info_id_sql = mysql_query("select id from start_info where uid=$uidand vid=$vid");

$query_info_id_rs = mysql_fetch_array($query_info_id_sql);

// 如果星星信息表里面没有数据，就插入 if(!$query_info_id_rs){

// 插入info表 $ins_info_sql = "insert into start_info(`uid`,`vid`,`a_score`,`b_score`,`c_score`,`d_score`,`e_score`) values($uid,$vid,$a_score,$b_score,$c_score,$d_score,$e_score)";

mysql_query($ins_info_sql);

// 查询info表 $query_info_sql = mysql_query("select `a_score`,`b_score`,`c_score`,`d_score`,`e_score` from start_info where uid=$uidand vid=$vid");

$query_info_rs = mysql_fetch_array($query_info_sql);

// 查询count表 $query_count_sql = mysql_query("SELECT `id`, `vid`, `a_total_score`, `b_total_score`, `c_total_score`, `d_total_score`, `e_total_score`, `a_total_num`, `b_total_num`, `c_total_num`, `d_total_num`, `e_total_num` FROM `start_count` WHERE vid=$vid");

$query_count_rs = mysql_fetch_array($query_count_sql);

if(!$query_count_rs) {

// 插入count表 $ins_count_sql = "";

if ($a_score > 0){

$a_total_score = $query_count_rs['a_total_score'] + $a_score; // 最新总分 $a_total_num = $query_count_rs['a_total_num'] + 1; // 最新总数 $ins_count_sql = "INSERT INTO `start_count` (`vid`, `a_total_score`, `a_total_num`) VALUES ($vid,$a_total_score,$a_total_num)";

mysql_query($ins_count_sql);

}

if ($b_score > 0){

$b_total_score = $query_count_rs['b_total_score'] + $b_score; // 最新总分 $b_total_num = $query_count_rs['b_total_num'] + 1; // 最新总数 $ins_count_sql = "INSERT INTO `start_count` (`vid`, `b_total_score`, `b_total_num`) VALUES ($vid,$b_total_score,$b_total_num)";

mysql_query($ins_count_sql);

}

if ($c_score > 0){

$c_total_score = $query_count_rs['c_total_score'] + $c_score; // 最新总分 $c_total_num = $query_count_rs['c_total_num'] + 1; // 最新总数 $ins_count_sql = "INSERT INTO `start_count` (`vid`, `c_total_score`, `c_total_num`) VALUES ($vid,$c_total_score,$c_total_num)";

mysql_query($ins_count_sql);

}

if ($d_score > 0){

$d_total_score = $query_count_rs['d_total_score'] + $d_score; // 最新总分 $d_total_num = $query_count_rs['d_total_num'] + 1; // 最新总数 $ins_count_sql = "INSERT INTO `start_count` (`vid`, `d_total_score`, `d_total_num`) VALUES ($vid,$d_total_score,$d_total_num)";

mysql_query($ins_count_sql);

}

if ($e_score > 0){

$e_total_score = $query_count_rs['e_total_score'] + $e_score; // 最新总分 $e_total_num = $query_count_rs['e_total_num'] + 1; // 最新总数 $ins_count_sql = "INSERT INTO `start_count` (`vid`, `e_total_score`, `e_total_num`) VALUES ($vid,$e_total_score,$e_total_num)";

mysql_query($ins_count_sql);

}

}else{

if($a_score > 0){

$update_count_sql = mysql_query("update start_count set a_total_score=a_total_score+$a_score,a_total_num=a_total_num+1 where vid=$vid");

}elseif($b_score > 0){

$update_count_sql = mysql_query("update start_count set b_total_score=b_total_score+$b_score,b_total_num=b_total_num+1 where vid=$vid");

}elseif ($c_score > 0){

$update_count_sql = mysql_query("update start_count set c_total_score=c_total_score+$c_score,c_total_num=c_total_num+1 where vid=$vid");

}elseif ($d_score > 0){

$update_count_sql = mysql_query("update start_count set d_total_score=d_total_score+$d_score,d_total_num=d_total_num+1 where vid=$vid");

}elseif ($e_score > 0){

$update_count_sql = mysql_query("update start_count set e_total_score=e_total_score+$e_score,e_total_num=e_total_num+1 where vid=$vid");

}

}

// 查询count表 $query_count_sql = mysql_query("SELECT `id`, `vid`, `a_total_score`, `b_total_score`, `c_total_score`, `d_total_score`, `e_total_score`, `a_total_num`, `b_total_num`, `c_total_num`, `d_total_num`, `e_total_num`, ROUND(a_total_score/a_total_num,2) as a_avg_score, ROUND(b_total_score/b_total_num,2) as b_avg_score, ROUND(c_total_score/c_total_num,2) as c_avg_score, ROUND(d_total_score/d_total_num,2) as d_avg_score, ROUND(e_total_score/e_total_num,2) as e_avg_score FROM `start_count` WHERE vid=$vid");

$query_count_rs = mysql_fetch_array($query_count_sql);

// 将2个数组合并$query_info_rs、$query_count_rs $rs = array_merge($query_info_rs, $query_count_rs);

echo json_encode($rs);

} else {

if($a_score > 0){

$update_info_sql = mysql_query("update start_info set a_score=$a_scorewhere uid=$uidand vid=$vid");

$update_count_sql = mysql_query("update start_count set a_total_score=a_total_score+$a_score,a_total_num=a_total_num+1 where vid=$vid");

}elseif($b_score > 0){

$update_info_sql = mysql_query("update start_info set b_score=$b_scorewhere uid=$uidand vid=$vid");

$update_count_sql = mysql_query("update start_count set b_total_score=b_total_score+$b_score,b_total_num=b_total_num+1 where vid=$vid");

}elseif ($c_score > 0){

$update_info_sql = mysql_query("update start_info set c_score=$c_scorewhere uid=$uidand vid=$vid");

$update_count_sql = mysql_query("update start_count set c_total_score=c_total_score+$c_score,c_total_num=c_total_num+1 where vid=$vid");

}elseif ($d_score > 0){

$update_info_sql = mysql_query("update start_info set d_score=$d_scorewhere uid=$uidand vid=$vid");

$update_count_sql = mysql_query("update start_count set d_total_score=d_total_score+$d_score,d_total_num=d_total_num+1 where vid=$vid");

}elseif ($e_score > 0){

$update_info_sql = mysql_query("update start_info set e_score=$e_scorewhere uid=$uidand vid=$vid");

$update_count_sql = mysql_query("update start_count set e_total_score=e_total_score+$e_score,e_total_num=e_total_num+1 where vid=$vid");

}

// 查询info表 $query_info_sql = mysql_query("select `a_score`,`b_score`,`c_score`,`d_score`,`e_score` from start_info where uid=$uidand vid=$vid");

$query_info_rs = mysql_fetch_array($query_info_sql);

// 查询count表 $query_count_sql = mysql_query("SELECT `id`, `vid`, `a_total_score`, `b_total_score`, `c_total_score`, `d_total_score`, `e_total_score`, `a_total_num`, `b_total_num`, `c_total_num`, `d_total_num`, `e_total_num`, ROUND(a_total_score/a_total_num,2) as a_avg_score, ROUND(b_total_score/b_total_num,2) as b_avg_score, ROUND(c_total_score/c_total_num,2) as c_avg_score, ROUND(d_total_score/d_total_num,2) as d_avg_score, ROUND(e_total_score/e_total_num,2) as e_avg_score FROM `start_count` WHERE vid=$vid");

$query_count_rs = mysql_fetch_array($query_count_sql);

// 将2个数组合并$query_info_rs、$query_count_rs $rs = array_merge($query_info_rs, $query_count_rs);

echo json_encode($rs);

}

}