We need to create two tables, one to store the results of our voting, and one to store the user's voting IP records.
We first create a database, the code is as follows
<?php header("Content-type:text/html;charset=utf-8"); //设置编码 $servername = "localhost"; $username = "root"; $password = "root"; // 创建连接 $conn = mysqli_connect($servername, $username, $password); mysqli_set_charset($conn,'utf8'); //设定字符集 // 检测连接 if (!$conn) { die("连接失败: " . mysqli_connect_error()); } // 创建数据库 $sql = "CREATE DATABASE vote"; if (mysqli_query($conn, $sql)) { echo "数据库创建成功"; } else { echo "数据库创建失败: " . mysqli_error($conn); } mysqli_close($conn); ?>
We created a database named "vote"
Now create the first table 'votes' table to record the total number of votes from both red and blue parties
Field name | id | likes | unlikes |
int | |||
10 | 10 | 10 | |
id | Number of red square votes | Number of blue square votes |
Field name | id | vid | ip |
Field type | int | int | varchar |
Field length | 10 | 10 | 40 |
Field description | id address | Record the id of the votes table | The ip address of the voting party |
The code is as follows
<?php header("Content-type:text/html;charset=utf-8"); //设置编码 $servername = "localhost"; $username = "root"; $password = "root"; $dbname = "vote"; // 创建连接 $conn = mysqli_connect($servername, $username, $password, $dbname); mysqli_set_charset($conn,'utf8'); //设定字符集 // 检测连接 if (!$conn) { die("连接失败: " . mysqli_connect_error()); } // 使用 sql 创建数据表 $sql = "CREATE TABLE IF NOT EXISTS `votes_ip` ( `id` int(10) NOT NULL, `vid` int(10) NOT NULL, `ip` varchar(40) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8;"; if (mysqli_query($conn, $sql)) { echo "数据表 votes_ip 创建成功"; } else { echo "创建数据表错误: " . mysqli_error($conn); } mysqli_close($conn); ?>
Now that our database has been created, let’s start making the HTML page