php+mysql投票系统
1、数据库链接文件conn.php
<?php
header ('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
<?php
include("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>