Sample code analysis of php implementation of voting system-PHP Tutorial-php.cn

Sample code analysis of php implementation of voting system

黄舟

Release： 2023-03-16 19:08:01

Original

2633 people have browsed it

Voting classification

<!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=&#39;vote.php?id={$i[0]}&is_radio={$i[2]}&#39;>{$i[1]}</a></th></tr>";
    }?>
</table>
</body>
</html>

Copy after login

Voting interface

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
<?php$id=$_GET[&#39;id&#39;];$is_radio=$_GET[&#39;is_radio&#39;];$db= new Mysqli("localhost","root","root","db_0808");$sql= "select * from toupiao WHERE category_id=&#39;{$id}&#39;";$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=&#39;radio&#39; name=&#39;r&#39; value=&#39;{$i[0]}&#39;></td>
              </tr>";
    }
    }else{        foreach ($data as $i){            echo "<tr>
              <td>{$i[1]}</td>
              <td><input type=&#39;checkbox&#39; name=&#39;r[]&#39; value=&#39;{$i[0]}&#39;></td>
              </tr>";
        }
    }    ?>
</table>
    <input type="submit" value="提交">
</form>
</body>
</html>

Copy after login

Voting processing

<!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[&#39;REMOTE_ADDR&#39;];//获取ip$sql="select count(*) from table2 where ip=&#39;{$ip}&#39;";$data = $db->StrQuery($sql);if($data!=&#39;0&#39;){    echo "每个人一天只能投一次";$r=$_POST[&#39;r&#39;];        if (is_array($r)){            $s=implode(&#39;,&#39;,$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,&#39;{$ip}&#39;,DEFAULT)";    $squel=$db->strQuery($sql,0);    if($squel){//    $upsql=update table_name set votes = votes + 1 where ...
//然后把数据insert into 到table2中$r=$_POST[&#39;r&#39;];if (is_array($r)){    $s=implode(&#39;,&#39;,$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(&#39;,&#39;,$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>

Copy after login

The above is the detailed content of Sample code analysis of php implementation of voting system. For more information, please follow other related articles on the PHP Chinese website!