1、数据库链接文件conn.php<?phpheader ('Content-Type:text/html;charset=gb2312');mysql_connect("localhost","root","root") or die('The database connection failed');mysql_select_db("vote") or die('The database is wrong choice');mysql_query('SET NAMES gb2312');?>
2、投票文件vote.php<?php session_start(); include("conn.php"); $user=$_SESSION["user"]; if(!isset($user)) {echo "<script language=\"javascript\">alert('请登录后投票!'); location=('admin.php');</script>";} $result = @mysql_query("SELECT * FROM list"); echo "你觉得本网站怎么样："; ?> <form name="form" action="xs.php" method="post"> <table width="365" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#C2C2C2"> <?php while ($rows = mysql_fetch_array($result)) { ?> <tr> <td bgcolor="#FFFFFF"><input type="radio" name="id" value="<?php echo $rows["id"]?>" /> <?php echo $rows["name"]?></td> </tr> <?php } ?> <tr> <td align="center" bgcolor="#FFFFFF"><input type="submit" name="submit" value="投票"/> </tr> </table> </form>
3、投票显示文件xs.php<?phpinclude("conn.php");$userIP = $_SERVER["REMOTE_ADDR"];$sql="SELECT * FROM ip";$ok1=mysql_query($sql);$rs=mysql_fetch_array($ok1);if(isset($_POST["submit"])){if($rs['ip']==$_SERVER["REMOTE_ADDR"]){echo "<script language=\"javascript\">alert('您已投票,请不要重复投票!'); location=('vote.php');</script>";exit(); } $sql2="insert into ip (id,ip)values('', '$userIP')"; mysql_query($sql2); $id=$_POST["id"]; $s1="update list set votes=votes+1 where id=$id"; $res1 = mysql_query($s1); $s2="SELECT * FROM list"; $res2 = mysql_query($s2);} echo "当前票数：";?> <table width="365" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#C2C2C2"> <?php while ($rows = mysql_fetch_array($res2)) { ?> <tr> <td bgcolor="#FFFFFF"><?php echo $rows['name'];?>.<?php echo $rows['votes'];?></td> </tr> <?php } ?> <tr><td bgcolor="#FFFFFF"><a href="vote.php">返回投票</a></td></tr> </table>
