Detailed explanation of the online voting system developed by PHP

The voting system is a very common function on the Internet. It is widely used in various online activities, surveys, Scenarios such as elections. This article will introduce in detail how to use PHP to develop a simple online voting system.

1. Create database

First, we need to create a database to store voting-related data. Suppose our database is named "vote" and contains the following two tables:

• "polls": a table used to store information such as voting topics and deadlines.
• "options": A table used to store each voting option, related to the polls table through foreign keys.

The following is the SQL sample code to create the database and table:

CREATE DATABASE vote; USE vote; CREATE TABLE polls ( id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(255) NOT NULL, deadline DATE NOT NULL ); CREATE TABLE options ( id INT AUTO_INCREMENT PRIMARY KEY, poll_id INT, title VARCHAR(255) NOT NULL, votes INT DEFAULT 0, FOREIGN KEY (poll_id) REFERENCES polls(id) );

2. Writing the voting page

The next step is to write the front-end page, using To display voting topics and options and receive votes from users. The following is a simple HTML and PHP code example:

     
  
投票主题
  0) { // 显示投票主题 $poll = mysqli_fetch_assoc($poll_result); echo "
{$poll['title']}
"; // 查询投票选项 $options_query = "SELECT * FROM options WHERE poll_id = $poll_id"; $options_result = mysqli_query($conn, $options_query); if (mysqli_num_rows($options_result) > 0) { // 显示投票选项 echo "
"; while ($option = mysqli_fetch_assoc($options_result)) { echo "{$option['title']}
"; } echo ""; echo ""; echo "
"; } else { echo "没有投票选项。"; } } else { echo "投票主题不存在。"; } // 关闭数据库连接 mysqli_close($conn); ?>  

3. Handling voting requests

In the voting page, we use a file called "vote.php" Handler to receive and process the user's vote request. The following is a sample code:

When the user submits a vote, vote.php will update the number of votes for the option and redirect to a page named "results.php" to display the voting results.

4. Display voting results

Finally, we need to write a results page to display the voting results. The following is a simple PHP code example:

     
  
投票结果
  0) { // 显示投票主题 $poll = mysqli_fetch_assoc($poll_result); echo "
{$poll['title']}（截止日期：{$poll['deadline']}）
"; // 查询投票选项 $options_query = "SELECT * FROM options WHERE poll_id = $poll_id"; $options_result = mysqli_query($conn, $options_query); if (mysqli_num_rows($options_result) > 0) { // 显示投票选项和票数 while ($option = mysqli_fetch_assoc($options_result)) { echo "{$option['title']}: {$option['votes']} 票
"; } } else { echo "没有投票选项。"; } } else { echo "投票主题不存在。"; } // 关闭数据库连接 mysqli_close($conn); ?>  

The above is a detailed introduction to a simple online voting system developed using PHP. By combining the database and the front-end page, we can simply implement the user voting function and count and display the voting results. Of course, actual voting systems may require more features and security measures to meet specific needs, but the examples provided in this article can be used as a reference to get started in developing a basic voting system.

The above is the detailed content of Detailed explanation of online voting system developed by PHP. For more information, please follow other related articles on the PHP Chinese website!