?? vote.php
字號:
<html><HEAD><TITLE>環(huán)保設(shè)計(jì)大賽</TITLE></HEAD><BODY><?php if (""==$id) { echo "退出！"; exit; } echo "<br><a href=\"show.php\">查看投票結(jié)果</a><br><br><br>"; include "./huanbao.connect.php"; $table_vote_ip='huanbao_vote_ip'; $table_vote_list='huanbao_vote_list'; $userip=$REMOTE_ADDR; $query="select * from ".$table_vote_ip." where ip='$userip'"; $result = mysql_query ($query,$db); $num = mysql_num_rows($result); if($num>=1) { echo "很遺憾，您已經(jīng)投過1次票了。系統(tǒng)不接收同一IP多于1次的投票。謝謝您的支持。"; mysql_close($db); exit; } else { $joindate = date("Y-m-d H:i:s"); $query="insert into ".$table_vote_ip." (ip,datetime,vote_id) values ('$userip','$joindate','$id')"; $result = mysql_query ($query,$db); $query="select * from ".$table_vote_list." where id='$id'"; $result = mysql_query ($query,$db); if(mysql_num_rows($result)>0) { $row=mysql_fetch_array($result); $id_number=$row[number]; $id_number++; $query="update ".$table_vote_list." set number='$id_number' where id='$id'"; $result = mysql_query ($query,$db); } else //該id還未存在 { $query="insert into ".$table_vote_list." (id,number) values ('$id','1')"; $result = mysql_query ($query,$db); } echo "謝謝您的投票。"; } @mysql_close($db);?></BODY></HTML>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -