Shulou(Shulou.com)06/03 Report--

This article mainly shows you "php voting system increase and delete voting example analysis", the content is simple and easy to understand, organized clearly, I hope to help you solve doubts, let Xiaobian lead you to study and learn "php voting system increase and delete voting example analysis" this article bar.

About how the voting system how the introduction is not much to say, this is not graduation design, mainly say about the use of php to achieve voting system, and other ordinary systems, divided into two parts, one is the administrator part, one is the ordinary user part.

About the voting system management part, very simple, provides two parts of the function, add votes and delete votes

The key lies in designing the database table, which is designed to store a vote in this way. The voteparent table stores whether the title and description of the vote have been deleted. The votechildren table stores the sub-options and the number of votes of the vote.

I. Basic objectives

First of all, the voting system is like this:

Three links, click in to directly carry out the operation of related functions, this article mainly writes the administrator part, the ordinary user part uses to jpgraph to open another chapter to explain

Logically, there should be a login system in the middle. This is not the key point. You can refer to my previous "[php] login system and output viewer information"(click to open the link).

Click on the Add Voting option, and the following interface will be displayed. You can add and delete voting options. Up to 10 voting options, at least 2 avatar options, and more or less will prompt:

Preview is using IE6, so add and delete options react slowly, administrators fill in the voting information, you can successfully add votes.

Before submitting, the administrator will be asked whether to add it to prevent misoperation. The system here should actually use xajax to investigate whether there is any voting data, and any option should not be added if it is empty. For details, please refer to the "php" registration system and the use of Xajax to verify whether the user name is occupied "article (click on the open link). Here, I didn't do it, because this article mainly talks about the core implementation of the voting system. Here, I won't deduct these small details.

Click on the Delete Voting section of the voting system again:

There is a delete button at the end of each vote. Click on the title of each vote to view this vote:

Click the delete button and there will also be questions, then click cancel and nothing will happen. Click confirm to successfully delete the vote:

In the image above, you can clearly see that there are 4 votes before deletion, and then only one vote after deletion.

II. Basic ideas

There is nothing new in the administrator part of the voting system or in the operation of the database. First of all, the structure of the voteparent table is as follows:

id is the self-adding column, title is the big title of this vote, such as the above "I am handsome" and so on, after the text is used to store the description of this vote, not to disconnect the self-adding column, and delete the vote can be checked, using the delete method, set the delete bit isdel, presented, this is the delete bit 0 vote.

The votechildren table is as follows, id is a self-increasing column, text is used to store the description of each sub-option, count is used to store the votes of this sub-option, and parentid is used to store which vote this sub-option belongs to. Although it is obvious that there are referential constraints with voteparent table, there is no need to set foreign keys to avoid trouble during operation.

It is worth noting that after the two tables are created, remember to turn to the table options tab card and set the codes of these two tables to utf-8 to avoid garbled codes.

The directory structure of the site is as follows:

This article describes only five pages of createvote.html, createvote.php, delvote.php, delvotehandle.php, index.html

III. Production process

1、index.html

The first is the most basic, only three links index.html, here is not to say, only three a tags, just learn html people will, the code is as follows:

Voting System Add Votes (Administrator Section) Delete Votes (Administrator Section) Votes (Regular User Section)

2、createvote.html

Add voting page, the entire add voting page handles two buttons with its own js function, is a large form, which also has a hidden field to record how many options there are now,

Provides the basis for adding the vote action page createvote.php next.

The following is a basic explanation. JavaScript's operation on web nodes can be referred to my previous article "JavaScript's addition, deletion and modification of web nodes"(click to open the link)

Notice that the added sub-option nodes are regularly arranged as opt1, opt2, opt3, etc. This is to facilitate the following operations

Create Votes Add Votes Delete Options

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.