前端页面:
<?
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";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>php利用ajax实现无刷新投票-云博客</title>
<meta name="keywords" content="{dede:global.cfg_keywords/}" />
<meta name="description" content="{dede:global.cfg_description/}" />
<style>
.aa{ font-size:24px;}
</style>
<SCRIPT src="js/jQuery.1.8.2.min.js" type=text/javascript></SCRIPT>
<script>
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("数据提交成功");
}
});
}
</script>
</head>
<body>
<?
$query=mysql_query($sql);
$i=1;
while($row=mysql_fetch_array($query))
{
?>
<input type='hidden' name='dopost' value='send' />
<input type='hidden' name='aid' value='[field:aid/]' />
<input type='hidden' name='ismore' value='0' />
<div class="aa">编号:<?=$row['aid']?></div><br />
<div class="aa"><?=$row['votename']?></div><br />
<div><img src="<?=$row['arcpic']?>" /></div><br />
<div><?=$row['info']?></div><br />
<div>投票人数:<span id="totalcount<?=$i?>"><?=$row['totalcount']?></span>
</div><br />
<div>投上一票:<input type="submit" name="vbt1" size="100" value="投票" onclick="AddPoll(<?=$row['aid']?>,<?=$i?>)" / ></div><br />
<? $i++;}?>
</body>
</html>
后端页面:
<?
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,不然不会显示出来。