投票分类
<!DOCTYPE html><html lang="en"><head> ???<meta charset="UTF-8"> ???<title>Title</title></head><body><?php$db= new Mysqli("localhost","root","root","db_0808");$sql= "select * from fenlei";$result=$db->query($sql);$data_c= $result->fetch_all();?><table border="1"> ???<?php ???foreach ($data_c as $i){ ???echo" <tr><th><a href=‘vote.php?id={$i[0]}&is_radio={$i[2]}‘>{$i[1]}</a></th></tr>"; ???}?></table></body></html>投票界面
<!DOCTYPE html><html lang="en"><head> ???<meta charset="UTF-8"> ???<title>Title</title></head><body><?php$id=$_GET[‘id‘];$is_radio=$_GET[‘is_radio‘];$db= new Mysqli("localhost","root","root","db_0808");$sql= "select * from toupiao WHERE category_id=‘{$id}‘";$result=$db->query($sql);$data=$result->fetch_all();?><form action="tongji.php" method="post"><table> ???<tr> ???????<td>名字</td> ???????<td>投票</td> ???</tr> ???<?php ???if ($is_radio==1){ ???foreach ($data as $i){ ???????echo "<tr> ?????????????<td>{$i[1]}</td> ?????????????<td><input type=‘radio‘ name=‘r‘ value=‘{$i[0]}‘></td> ?????????????</tr>"; ???} ???}else{ ???????foreach ($data as $i){ ???????????echo "<tr> ?????????????<td>{$i[1]}</td> ?????????????<td><input type=‘checkbox‘ name=‘r[]‘ value=‘{$i[0]}‘></td> ?????????????</tr>"; ???????} ???} ????></table> ???<input type="submit" value="提交"></form></body></html>投票处理
<!DOCTYPE html><html lang="en"><head> ???<meta charset="UTF-8"> ???<title>Title</title></head><body><table> ???<tr> ???????<td>名字</td> ???????<td>票数</td> ???</tr><?php//$db= new Mysqli("localhost","root","root","db_0808");require_once "../ZY/YIN.class.php";$db = new YIN();$ip=$_SERVER[‘REMOTE_ADDR‘];//获取ip$sql="select count(*) from table2 where ip=‘{$ip}‘";$data = $db->StrQuery($sql);if($data!=‘0‘){ ???echo "每个人一天只能投一次";$r=$_POST[‘r‘]; ???????if (is_array($r)){ ???????????$s=implode(‘,‘,$r); ???????????$sq="select * from toupiao where id in ({$s})"; ???????}else{ ???????????$sq="select * from toupiao where id = {$r}"; ???????} ???????$qurle=$db->Query($sq); ???????foreach ($qurle as $i){ ???????????echo "<tr><td>{$i[1]}</td><td>{$i[2]}</td></tr>"; ???????}}else{ ???$sql = "INSERT INTO table2 VALUES (null,‘{$ip}‘,DEFAULT)"; ???$squel=$db->strQuery($sql,0); ???if($squel){// ???$upsql=update table_name set votes = votes + 1 where ...//然后把数据insert into 到table2中$r=$_POST[‘r‘];if (is_array($r)){ ???$s=implode(‘,‘,$r); ???$sql="update toupiao set count=(count+1) where id in ({$s})";}else{$sql="update toupiao set count=(count+1) where id = {$r}";}$data=$db->query($sql,0);if ($data){//echo "success"; ???if (is_array($r)){ ???????$s=implode(‘,‘,$r); ???????$sq="select * from toupiao where id in ({$s})"; ???}else{ ???????$sq="select * from toupiao where id = {$r}";} ???$qurle=$db->Query($sq); ???foreach ($qurle as $i){ ???????echo "<tr><td>{$i[1]}</td><td>{$i[2]}</td></tr>"; ???}} ???}}?></table></body></html>PHP投票系统
原文地址：http://www.cnblogs.com/little-rock/p/8056182.html