Home > Article > Backend Development > Sample code analysis of php implementation of voting system

Sample code analysis of php implementation of voting system

黄舟Original: 2017-10-26 09:09:292580browse

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>

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>

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>

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!

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：Implementation method of adding content to database in thinkphp5Next article：Implementation method of adding content to database in thinkphp5

See more

Sample code analysis of php implementation of voting system

Related articles