php投票系统

OGeek|极客世界-中国程序员成长平台 › 门户 › 编程› PHP›PHP编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

投票分类

<!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>