1. 云栖社区>
  2. PHP教程>
  3. 正文

php投票系统

作者:用户 来源:互联网 时间:2017-11-30 13:43:29

php系统投票

php投票系统 - 摘要: 本文讲的是php投票系统, 投票分类 <!DOCTYPE html><html lang="en"><head> <meta charset="UTF-8"> <title>Title</

投票分类

<!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 , 系统 投票 ,以便于您获取更多的相关知识。