前端页面:
error_reporting(0);
mysql_connect("localhost","root","root");
mysql_select_db('bckq##!~%^#');
mysql_query("set names gb2312");
$sql="select dede_vote.aid,dede_vote.spec,dede_vote.votename,dede_vote.arcpic,dede_vote.info,
dede_vote.totalcount from dede_vote where dede_vote.isenable=0";
?>
html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
php利用ajax实现无刷新投票-云博客.aa{ font-size:24px;}
function AddPoll(pollid,i) {
$.ajax({
url: 'chk.php',
data: "pollid=" + pollid+"&totalcount="+$('#totalcount'+i).html() ,
type: 'POST',
success: function(msg){
$('#totalcount'+i).html(msg);
alert("数据提交成功");
}
});
}
$query=mysql_query($sql);
$i=1;
while($row=mysql_fetch_array($query))
{
?>
$i++;}?>
后端页面:
error_reporting(0);
mysql_connect("localhost","root","root");
mysql_select_db('bckq##!~%^#');
mysql_query("set names gb2312");
$aid=$_POST["pollid"];
$totalcount=$_POST["totalcount"];
$sql= "update dede_vote set totalcount='$totalcount'+1 where aid='$aid'";
mysql_query($sql) or die(mysql_error());
$sql1= "select totalcount from dede_vote where aid='$aid'";
$query=mysql_query($sql1);
while($row=mysql_fetch_assoc($query))
{
echo $row['totalcount'];
}
?>
记住一定要有就jQuery.1.8.2.min.js,不然不会显示出来。