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;
}
?>