Php实现投票系统,php实现投票系统的示例代码分析

投票分类

Title

<?php $db= new Mysqli("localhost","root","root","db_0808");$sql= "select * from fenlei";$result=$db->query($sql);$data_c= $result->fetch_all();?>

{$i[1]}";

}?>

投票界面

Title

<?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();?>

名字

投票

";

}

}else{ foreach ($data as $i){ echo "

{$i[1]}";

}

} ?>

投票处理

Title

名字

票数

<?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 "

{$i[1]}{$i[2]}";

}

}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 "

{$i[1]}{$i[2]}";

}

}

}

}?>