首先是实现的原理
从上一个css实现星级评分I 、II，可是看出，只要能识别onclick和将数据记录至数据库中存储，然后从数据库中调用出数据进行计算就
可以得到当前的评分均值——当前的分值。
1.下面是建立数据库的sql
| 以下是引用片段： CREATE TABLE ratings( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, total_votes INT NOT NULL, total_value INT NOT NULL, which_id INT NOT NULL, which_table VARCHAR(255), used_ips LONGTEXT NULL ); |
| 以下是引用片段： <?php require("connectDB.php"); require("closeDB.php"); require("tableName.php"); require("openDB.php"); ?> |
3.显示投票程序和更新投票数据程序
| 以下是引用片段： <?php $rating_posted=$_GET['vote'];//pased variable by the the stars value $id=$_GET['id']; $query=mysql_query("SELECT total_votes, total_value, used_ips FROM $tableName WHERE id='".$id."' ")or die(" Error: ".mysql_error()); $numbers=mysql_fetch_assoc($query); $checkIP=unserialize($numbers['used_ips']); $count=$numbers['total_votes'];//how many votes total $current_rating=$numbers['total_value'];//total number of rating added together and stored $sum=$rating_posted+$current_rating;// add together the current vote value and the total vote value $tense=($count==1) ? "vote" : "votes";//plural form votes/vote $voted=@mysql_fetch_assoc(@mysql_query("SELECT title FROM $tableName WHERE used_ips LIKE '%".$_SERVER['REMOTE_ADDR']."%' AND id='$id' ")); //Pattern match ip:suggested by Bramus! http://www.bram.us/ - this variable searches through the previous ip address that have voted and returns true or false if($voted){ echo "<div class=\"rating\">". "<ul class=\"star-rating\">". "<li class=\"current-rating\" style=\"width:". @number_format($current_rating/$count,2)*20 ."px;\">Current rating.</li>". "<li class=\"one-star\">1</li>". "<li class=\"two-stars\" >2</li>". "<li class=\"three-stars\">3</li>". "<li class=\"four-stars\">4</li>". "<li class=\"five-stars\">5</li>". "</ul>". "<p>Rating: <strong>".@number_format($current_rating/$count,2)."</strong> {".$count." ".$tense." cast} <br />You have previously voted.</p></div>";//show the current value of the vote with the current numbers }else{ if(isset($_GET['vote'])){ if($sum==0){ $added=0;//checking to see if the first vote has been tallied }else{ $added=$count+1;//increment the current number of votes } if(is_array($checkIP)){ array_push($checkIP,$_SERVER['REMOTE_ADDR']);//if it is an array i.e. already has entries the push in another value }else{ $checkIP=array($_SERVER['REMOTE_ADDR']);//for the first entry } $insert=serialize($checkIP); mysql_query("UPDATE $tableName SET total_votes='".$added."', total_value='".$sum."', used_ips='".$insert."' WHERE id='".$_GET['id']."'"); echo "<div class=\"rating\"><p>Rating: <strong>".@number_format($sum/$added,2)."</strong> {".$added." ".$tense." cast} <span>Thank you for your vote!</span></p></div>";//show the updated value of the vote }else{ ?> |
| 以下是引用片段： <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>CSS: Star Rater Example</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <link href="styles2-1.css" rel="stylesheet" type="text/css" media="all"> </head> <body> <div class="rating"> <p>How clear was this tutorial?</p> <ul class="star-rating"> <li class="current-rating" style="width:<?php echo @number_format($current_rating/$count,2)*20 ?>px;">Current rating</li> <li><a href="<?php echo $_SERVER['PHP_SELF'] . "?" .$_GET['section'] . "&id=" . $_GET['id'] . "&vote=1";?>" title="Rate this 1 star out of 5" class="one-star">1</a></li> <li><a href="<?php echo $_SERVER['PHP_SELF'] . "?" .$_GET['section'] . "&id=" . $_GET['id'] . "&vote=1";?>" title="Rate this 2 stars out of 5" class="two-stars" >2</a></li> <li><a href="<?php echo $_SERVER['PHP_SELF'] . "?" .$_GET['section'] . "&id=" . $_GET['id'] . "&vote=1";?>" title="Rate this 3 stars out of 5" class="three-stars" >3</a></li> <li><a href="<?php echo $_SERVER['PHP_SELF'] . "?" .$_GET['section'] . "&id=" . $_GET['id'] . "&vote=1";?>" title="Rate this 4 stars out of 5" class="four-stars" >4</a></li> <li><a href="<?php echo $_SERVER['PHP_SELF'] . "?" .$_GET['section'] . "&id=" . $_GET['id'] . "&vote=1";?>" title="Rate this 5 stars out of 5" class="five-stars" >5</a></li> </ul> </body></html> |
| 以下是引用片段： <?php echo "<p>Rating: <strong>".@number_format($sum/$count,2)."</strong> {".$count." ".$tense." cast}</p></div>";//show the current updated value of the vote } // end isset get vote } //end voted true, false ?> |
原文：Creating a star rating system part (3)
链接：http://slim.climaxdesigns.com/tutorial.php?id=3
版权：版权归原作者所有，翻译文档版权归本人|greengnn，转载请注明出处www.jluvip.com/blog
我们用php来实现
先看看效果：http://gnn.80x86.cn/starrating