Analysis: what makes a web poll?

The goal of a web poll is to give your users the chance to register their views on your site. Although they do not need to be powered by a database, it is the fastest and easiest way of handling it. At the simplest level, we would need to store in our database a list of all questions, their possible answers, as well as the number of times each answer has been voted for.

In database terms that equates to a table that looks like this:

Question	CHAR(255)
Answer1	CHAR(255)
Answer2	CHAR(255)
Answer3	CHAR(255)
Answer1_Votes	INT
Answer2_Votes	INT
Answer3_Votes	INT

From a PHP programming perspective we need two scripts - one to display the poll and give the user the chance to vote, and the other to capture the vote choice and display the results. We're not doing anything fancy right now, so when voting we will simply pass a number (1, 2, or 3) and the vote ID. The results page will then take that number and add one to the vote count for that answer.

Want to learn PHP 7?

Hacking with PHP has been fully updated for PHP 7, and is now available as a downloadable PDF. Get over 1200 pages of hands-on PHP learning today!

If this was helpful, please take a moment to tell others about Hacking with PHP by tweeting about it!

Next chapter: Development: creating the simplest poll >>

Previous chapter: Creating a poll

Jump to:

Home: Table of Contents