A. 在用php做一个投票系统,当用户投票后,希望能实时的看到投票结果的变化,请问怎么实现
实时看到投票结果,也就是web页面局部刷新,这种效果仅依靠PHP是做不出来的,因为PHP是服务端脚本,通常是使用ajax技术来实现。
B. 用php制作一个网页来实现简易网上投票系统
<?php
header("Content-type:text/html;charset=utf-8");
$link=mysql_connect('localhost','root','')ordie('Couldnotconnecttomysqlserver');
mysql_select_db('tpxt',$link)ordie('Couldnotselectdatabase');
if(isset($_POST['submit'])){
$sql="SELECT`id`FROM`table`WHERE`uid`=".$_POST['uid'];
$result=mysql_query($sql);
if($result&&mysql_num_rows($result)){
$sql="UPDATE`table`SET`vote`=`vote`+1WHERE`uid`=".$_POST['uid'];
mysql_query($sql);
}else{
$sql="INSERTINTO`table`(uid,vote)VALUES('".$_POST['uid']."','1')";
mysql_query($sql);
}
echo"<script>alert('Ok投票成功!');</script>";
echo"<script>window.location.reload();</script>";
exit();
}else{
$sql="SELECT`vote`FROM`table`WHERE`uid`=3";
$result=mysql_query($sql);
if($result&&mysql_num_rows($result)){
$t3=mysql_fetch_assoc($result);
}else{
$t3['vote']=0;
}
$sql="SELECT`vote`FROM`table`WHERE`uid`=4";
$result=mysql_query($sql);
if($result&&mysql_num_rows($result)){
$t4=mysql_fetch_assoc($result);
}else{
$t4['vote']=0;
}
$sql="SELECT`vote`FROM`table`WHERE`uid`=5";
$result=mysql_query($sql);
if($result&&mysql_num_rows($result)){
$t5=mysql_fetch_assoc($result);
}else{
$t5['vote']=0;
}
$sql="SELECT`vote`FROM`table`WHERE`uid`=6";
$result=mysql_query($sql);
if($result&&mysql_num_rows($result)){
$t6=mysql_fetch_assoc($result);
}else{
$t6['vote']=0;
}
$sql="SELECT`vote`FROM`table`WHERE`uid`=7";
$result=mysql_query($sql);
if($result&&mysql_num_rows($result)){
$t7=mysql_fetch_assoc($result);
}else{
$t7['vote']=0;
}
$count=$t3['vote']+$t4['vote']+$t5['vote']+$t6['vote']+$t7['vote'];
$t3_b=$t3['vote']/$count;
$t4_b=$t4['vote']/$count;
$t5_b=$t5['vote']/$count;
$t6_b=$t6['vote']/$count;
$t7_b=$t7['vote']/$count;
}
?>