wordpress做h5/seo运营是什么意思

我们用php来实现

首先是实现的原理

从上一个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

);

2.参数文件引用

require("connectDB.php");

require("closeDB.php");

require("tableName.php");

require("openDB.php");

?>

3.显示投票程序和更新投票数据程序

$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 "

}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  "

}else{

?>

4.访问者评分程序

} // end isset get vote

} //end voted true, false

?>

下一步是将结果记入数据库，现在没有时间去研究了，请大家等待下一篇文章或者去原出处阅读！