This easy-to-use class library enables you to set up your own survey system in just few minutes.
Package includes dynamically generated form (with number of total votes), detailed result page, view of old polls, administration page, check for repeated votes and virtually unlimited number of questions.

By : tebrino

***********************************************************************************
Simple Mini Poll class library (SimPoll)

Author: Ilir Fekaj
Contact: tebrino@hotmail.com
Date: January 9, 2004
Version: 1.0
Latest version: http://www.free-midi.org/scripts/
Demo: http://www.free-midi.org

This easy-to-use class library enables you to set up your own survey system in just few minutes.
Package includes dynamically generated form (with number of total votes), detailed result
page, view of old polls, administration page, check for repeated votes.
It's free for all purposes, just please don't claim you wrote it and if you like it
and find it useful please leave link on results page.
If you have any problems, please feel free to contact me.
Also if you use it, please send me the page URL.

INSTRUCTIONS:

1. Execute these queries on your database:

# Table structure for table `poll_check`

CREATE TABLE `poll_check` (
`pollid` int(11) NOT NULL default '0',
`ip` varchar(20) NOT NULL default '',
`time` varchar(14) NOT NULL default ''
) TYPE=MyISAM COMMENT='';

# --------------------------------------------------------

# Table structure for table `poll_data`

CREATE TABLE `poll_data` (
`pollid` int(11) NOT NULL default '0',
`polltext` varchar(50) NOT NULL default '',
`votecount` int(11) NOT NULL default '0',
`voteid` int(11) NOT NULL default '0',
`status` varchar(6) default NULL
) TYPE=MyISAM COMMENT='';

# --------------------------------------------------------

# Table structure for table `poll_desc`

CREATE TABLE `poll_desc` (
`pollid` int(11) NOT NULL default '0',
`polltitle` varchar(100) NOT NULL default '',
`timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`votecount` mediumint(9) NOT NULL default '0',
`STATUS` varchar(6) default NULL,
PRIMARY KEY (`pollid`)
) TYPE=MyISAM COMMENT='';

# --------------------------------------------------------

2. Copy and paste code bellow in separate files and name them as noted
3. Set up database connection parameters in file config.php
4. Optionally you can change layout of form and results page
5. Create new poll by starting admin page (in this case test_poll_admin.php)
6. Activate your poll by clicking ACTIVATE
7. Enjoy and send me your comments


***********************************************************************************
CLASS FILES:

file miniPoll.class.php
***********************************************************************************
<?php
class miniPoll {

var $show_vote_count;
var $active_poll_id;
var $active_poll_title;
var $timestamp;
var $timeout;
var $ip;
var $repeated_vote;
var $results_page;
var $old_polls;

function miniPoll() {
$this->show_vote_count = true; // display total votes? true/false
$this->pollLayout();
$this->getActivePoll();
$this->timestamp = time();
$this->timeout = $this->timestamp - 1800;
$this->ip = $_SERVER['REMOTE_ADDR'];
$this->repeated_vote = "You already voted today<br />";
$this->results_page = "test_poll_results.php"; // page where you display results
$this->old_polls = true; // if true enables view of old polls. this only display old polls it doesn't allow users to vote. true/false

}

function pollLayout() {
// it allows you to set visual settings using CSS definitions included in file where you're calling this class
// replace these with your own CSS styles
$this->form_table_width = "120px";
$this->form_title = "menuhd";
$this->form_table = "tabele";
$this->form_table_cell = "poll";
$this->form_button = "formlook";
$this->poll_question = "fat"; // this is for <span> tag
$this->results_title = "menuhd";
$this->results_table = "";
$this->results_poll_question = "fat";
$this->result_table_width = "450px";
$this->result_table_cell = "pollbg";
$this->bar_image = "images/bar.jpg"; // please select 1px width x 15px height image
}

function getActivePoll() {
$sql = @mysql_query ("SELECT pollid, polltitle FROM poll_desc WHERE status = 'active'");
$row = @mysql_fetch_object($sql);
$this->active_poll_id = $row->pollid;
$this->active_poll_title = $row->polltitle;
return;
}

function voteCount() {
$sql = @mysql_query ("SELECT SUM(votecount) AS votecount FROM poll_data WHERE pollid = '$this->active_poll_id'");
$row = @mysql_fetch_object($sql);
$this->votecount = $row->votecount;
return $this->votecount;
}

function pollForm() {
$sql = @mysql_query ("SELECT polltext, voteid FROM poll_data WHERE pollid = '$this->active_poll_id' ORDER BY voteid");
if (@mysql_num_rows($sql) > 0) {
echo "<table width=\"$this->form_table_width\" border=\"0\" cellpadding=\"0\" cellspacing=\"1\" class=\"$this->form_table\">
<tr><td class=\"$this->form_title\">Mini Poll</td></tr>
<tr><td class=\"$this->form_table_cell\">\r\n";
echo "<form action=\"$this->results_page\" name=\"pollf\" id=\"pollf\" method=\"get\">
<span class=\"$this->poll_question\">" . $this->active_poll_title . "</span><br />\r\n";

while ($row = @mysql_fetch_object($sql)) {
if (!empty($row->polltext)) {
echo "\t<input type=\"radio\" name=\"voteid\" value=\"$row->voteid\" /> $row->polltext <br />\r\n";
}
}

echo "<input type=\"hidden\" name=\"pollid\" id=\"pollid\" value=\"$this->active_poll_id\" /><br />\r\n";
echo "<input type=\"submit\" name=\"poll\" id=\"poll\" value=\"Vote\" class=\"$this->form_button\" />
<hr size=\"1\" noshade=\"noshade\" />";
if ($this->show_vote_count) {
echo "Total votes: " . $this->voteCount() . "\r\n";
}
echo "<a href=\"$this->results_page?pollid=$this->active_poll_id\">View results</a>
</form>\r\n</td></tr></table>\r\n";
}
}

function deleteCheck() {
$sql = @mysql_query ("DELETE FROM poll_check WHERE time < '$this->timeout'");
return;
}

function insertCheck() {
$sql = @mysql_query ("INSERT INTO poll_check (ip, time) VALUES ('$this->ip', '$this->timestamp')");
return;
}

function voteCheck() {
$this->deleteCheck();
$sql = @mysql_query ("SELECT ip FROM poll_check WHERE ip = '$this->ip'");
if (@mysql_num_rows($sql) == 0) {
$this->insertCheck();
return true;
}
else {
return false;
}
}

function processPoll($pollid, $voteid) {
if ($this->voteCheck()) {
$sql = @mysql_query ("UPDATE poll_data SET votecount = votecount + 1 WHERE voteid = '$voteid' AND pollid = '$pollid'");
}
else {
echo $this->repeated_vote;
}

}

function selectedPoll($pollid) {
$sql = @mysql_query ("SELECT polltitle FROM poll_desc WHERE pollid = '$pollid'");
$row = @mysql_fetch_object($sql);
$this->polltitle = $row->polltitle;
return $this->polltitle;
}

function selectedPollVotecount($pollid) {
$sql = @mysql_query ("SELECT SUM(votecount) AS votecount FROM poll_data WHERE pollid = '$pollid'");
$row = @mysql_fetch_object($sql);
$this->votecount = $row->votecount;
return $this->votecount;
}

function formatDate($val) {
$arr = explode("-", $val);
return date("d. F Y.", mktime (0,0,0, $arr[1], $arr[2], $arr[0]));
}

function oldPolls($pollid) {
$sql = mysql_query ("SELECT pollid, polltitle, timestamp FROM poll_desc WHERE pollid <> '$pollid'");
if (mysql_num_rows($sql) > 0) {
echo "<tr><td class=\"$this->result_table_cell\" colspan=\"2\">\r\n";
while ($row = mysql_fetch_object($sql)) {
$datum = $this->formatDate($row->timestamp);
echo "<a href=\"$this->results_page?pollid=$row->pollid\">$row->polltitle</a> $datum<br />\r\n";
}
echo "</td></tr>\r\n";
}
}

function pollResults($pollid) {
$this->selectedPoll($pollid);
$this->selectedPollVotecount($pollid);
$sql = @mysql_query ("SELECT polltext, votecount FROM poll_data WHERE pollid = '$pollid' AND polltext <> ''");
echo "<table border=\"0\" width=\"$this->result_table_width\" class=\"$this->results_table\">
<tr><td class=\"$this->results_title\" colspan=\"2\">Mini Poll Results</td></tr>";
if (@mysql_num_rows($sql) > 0) {
echo "<tr><td class=\"$this->results_poll_question\" colspan=\"2\">$this->polltitle</td></tr>\r\n";
while ($row = mysql_fetch_object($sql)) {
if ($this->votecount == 0) {
$tmp_votecount = 1;
}
else {
$tmp_votecount = $this->votecount;
}
$vote_percents = number_format(($row->votecount / $tmp_votecount * 100), 2);
$image_width = intval($vote_percents * 3);
echo "<tr><td class=\"$this->result_table_cell\">$row->polltext $row->votecount votes. ($vote_percents %)</td><td class=\"$this->result_table_cell\"> <img src=\"$this->bar_image\" width=\"$image_width\" alt=\"$vote_percents %\" height=\"15\" /> </td></tr>\r\n";
}
echo "<tr><td class=\"$this->result_table_cell\" colspan=\"2\">Total votes: $this->votecount</td></tr>\r\n";
}
if ($this->old_polls) {
$this->oldPolls($pollid);
}
echo "</table>\r\n";
// if you like this software and you find it useful, please don't remove this link
echo "Powered by: <a href=\"http://www.free-midi.org/scripts/\">SimPoll</a> v.1.0\r\n";

}

}
?>
***********************************************************************************

file miniPollAdmin.class.php
***********************************************************************************
<?php
class miniPollAdmin {

var $results_page;
var $max_questions;
var $maxpoll;

function miniPollAdmin() {
$this->results_page = "test_poll_admin.php"; // name of file where this class is called
$this->max_questions = 10;

}

function getLastPollId() {
$sql = @mysql_query ("SELECT MAX(pollid) AS maxpoll FROM poll_desc");
$row = @mysql_fetch_object($sql);
$this->maxpoll = $row->maxpoll + 1;
return $this->maxpoll;
}

function listPolls() {
$sql = @mysql_query ("SELECT pollid, polltitle, status, timestamp FROM poll_desc ORDER BY timestamp DESC");
echo "<table border=\"1\">
<tr><td>id</td>
<td>Poll title</td>
<td>Date</td>
<td>Status</td>
<td>&nbsp;</td>
<td>&nbsp;</td></tr>";
while ($row = @mysql_fetch_object($sql)) {
echo "\t<tr><td>$row->pollid</td>
<td>$row->polltitle</td>
<td>$row->timestamp</td>
<td>" . strtoupper($row->status) . "</td>
<td><a href=\"$this->results_page?opt=activate&amp;pollid=$row->pollid\">activate</a></td>
<td><a href=\"$this->results_page?opt=delete&amp;pollid=$row->pollid\">delete</a></td></tr>\r\n";
}
echo "</table>\r\n";
}

function newPollForm() {
echo "<fieldset>
<legend>Create new poll</legend>
<form method=\"get\" name=\"form1\" method=\"post\" action=\"$this->results_page\"><br />\r\n";
echo "Poll name: <input name=\"pollname\" type=\"text\" id=\"pollname\" class=\"formlook\" /><br />\r\n";
for ($i = 1; $i <= $this->max_questions; $i ++) {
echo "Question $i: <input name=\"q[$i]\" type=\"text\" id=\"q[$i]\" class=\"formlook\" /><br />\r\n";
}
echo "<input type=\"submit\" name=\"Submit\" value=\"Create\" class=\"formlook\" /><br />\r\n</form><br />\r\n</fieldset>\r\n";
}

function createPoll($pollname, $q) {
$this->getLastPollId();
$insert_title = @mysql_query ("INSERT INTO poll_desc(pollid, polltitle, timestamp) VALUES ('$this->maxpoll', '$pollname', now())");
for ($i = 1; $i <= count($q); $i ++) {
$insert_questions = @mysql_query ("INSERT INTO poll_data(pollid, polltext, voteid) VALUES ('$this->maxpoll', '$q[$i]', '$i')");
}

}

function activatePoll($pollid) {
$deactivate_poll = @mysql_query ("UPDATE poll_desc SET status = '' WHERE status = 'active'");
$activate_poll = @mysql_query ("UPDATE poll_desc SET status = 'active' WHERE pollid = '$pollid'");
if (mysql_affected_rows() > 0) {
echo "Poll successfully activated<br />\r\n";
}
}

function deletePoll($pollid) {
$delete_poll = @mysql_query ("DELETE FROM poll_desc WHERE pollid = '$pollid'");
if (mysql_affected_rows() > 0) {
$delete_poll_questions = @mysql_query ("DELETE FROM poll_data WHERE pollid = '$pollid'");
echo "Poll successfully deleted.<br />\r\n";
}
}

}
?>
***********************************************************************************

EXAMPLE FILES:

file config.php
***********************************************************************************
<?php
// config.php

$host = "localhost"; // db host
$user = "root"; // db username
$pass = ""; // db password
$db = "yourdb"; // db name

?>
***********************************************************************************

file test_poll.php
***********************************************************************************
<?php
error_reporting(E_ALL); // when you finish testing you should change this to E_NONE

include_once ("miniPoll.class.php");
include_once ("config.php");

$connection = mysql_connect ($host, $user, $pass) or die ("Unable to connect");
mysql_select_db ($db) or die ("Unable to select database");

?>

<?php echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?".">"; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Mini Poll Example</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link href="style/poll.css" rel="stylesheet" type="text/css" />
</head>
<body>

<?php
// this is all you need :)

$test = new miniPoll;

$test->pollForm();

@mysql_close($connection);

?>
</body>
</html>
***********************************************************************************

file test_poll_results.php - results page
***********************************************************************************
<?php
error_reporting(E_ALL); // when you finish testing you should change this to E_NONE

include_once ("miniPoll.class.php");
include_once ("config.php");

$connection = mysql_connect ($host, $user, $pass) or die ("Unable to connect");
mysql_select_db ($db) or die ("Unable to select database");

?>

<?php echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?".">"; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Mini Poll Example</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link href="style/poll.css" rel="stylesheet" type="text/css" />
</head>
<body>
<?php

$test = new miniPoll;

if (isset($_GET['poll']) && is_numeric($_GET['pollid'])) {
$pollid = $_GET['pollid'];

if (isset($_GET['voteid']) && is_numeric($_GET['voteid'])) {
$voteid = $_GET['voteid'];
$test->processPoll($pollid, $voteid);
}

}
if (isset($_GET['pollid'])) {
$pollid = $_GET['pollid'];
$test->pollResults($pollid);
}

@mysql_close($connection);

?>

</body>
</html>
***********************************************************************************

file test_poll_admin.php - poll administration page
***********************************************************************************
<?php
error_reporting(E_ALL);

include_once ("miniPollAdmin.class.php");
include_once ("config.php");

$connection = mysql_connect ($host, $user, $pass) or die ("Unable to connect");
mysql_select_db ($db) or die ("Unable to select database");
?>
<?php echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?".">"; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Mini Poll Admin Example</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link href="style/poll.css" rel="stylesheet" type="text/css" />
</head>
<body>
<?php
$test = new miniPollAdmin;

$test->newPollForm();

if (isset($_GET['opt'])) {
$opt = $_GET['opt'];
$pollid = $_GET['pollid'];
if ($opt == 'activate') {
$test->activatePoll($pollid);
}
if ($opt == 'delete') {
$test->deletePoll($pollid);
}

}

echo "<br />";
if (isset($_GET['q'])) {
$pollname = $_GET['pollname'];
$q = $_GET['q'];
$test->createPoll($pollname, $q);
}
$test->listPolls();

@mysql_close($connection);

?>

</body>
</html>
***********************************************************************************

file poll.css - example style sheet
***********************************************************************************
/* Example class for Mini Poll */

body {
font-family: Verdana, Arial, Helvetica;
font-size: 10px;
}
.menuhd {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color: #006699;
background-color: #A5C9DA;
padding-top: 2px;
padding-bottom: 2px;
padding-left: 3px;
border-top-width: 1px;
border-left-width: 1px;
border-top-style: solid;
border-left-style: solid;
border-top-color: #FFFFFF;
border-left-color: #FFFFFF;
font-weight: bold;
}
.poll {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 10px;
padding-top: 2px;
padding-bottom: 2px;
padding-left: 5px;
background-color: #DFE3E2;
border-top-width: 1px;
border-left-width: 1px;
border-top-style: solid;
border-left-style: solid;
border-top-color: #FFFFFF;
border-left-color: #FFFFFF;
padding-right: 2px;
}
a:link {
font-family: Verdana, Arial, Helvetica, sans-serif;
color: #0099CC;
text-decoration: none;
}
a:visited {
font-family: Verdana, Arial, Helvetica, sans-serif;
color: #0099CC;
text-decoration: none;
}
a:hover {
font-family: Verdana, Arial, Helvetica, sans-serif;
color: #0099CC;
text-decoration: underline;
}
.fat {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 10px;
font-weight: bold;
}
.tabele {
background-color: #000000;
}
.formlook {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 10px;
color: #000000;
border: 1px solid #000000;
}
.pollbg {
background-color: #DFE3E2;
padding-left: 5px;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 10px;
color: #000000;
padding-top: 2px;
padding-bottom: 2px;
}
***********************************************************************************

Click to Download File

DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

More Content Management Code Articles
More By Codewalkers

 

developerWorks - FREE Tools!

NEW! Did you say mainframe? e-kit Learn how you can extend modern application lifecycle management to IBM System z through the IBM Rational Software Delivery Platform (SDP). The Did you say mainframe? e-kit includes podcasts, webcasts, tutorials, white and red papers, demos, and articles designed to help ease the challenges of modernizing your enterprise. This complimentary kit for mainframe developers is a practical, how-to guide for making the most of an existing development environment, including the skills and infrastructure already in place at an established enterprise. FREE! Go There Now!

NEW! Download DB2 Express-C 9.5 Visit IBM developerWorks to download IBM DB2 Express-C 9.5, a no-charge version of DB2 Express 9 database server. DB2 Express-C offers the same core data server base features as other DB2 Express editions and provides a solid base to build and deploy applications developed using C/C++, Java, .NET, PHP, and other programming languages. FREE! Go There Now!

NEW! Download IBM WebSphere Portal V6.1 beta code Download the IBM WebSphere Portal V6.1 beta code and learn more about the rich features and enhancements in IBM WebSphere Portal V6.1. WebSphere Portal provides a composite application or business mashup framework and the advanced tooling needed to build flexible, SOA-based solutions, and scalability to meet the needs of any size organization. FREE! Go There Now!

NEW! Download the free Web Application Security eKit Discover how IBM Rational AppScan Standard Edition can help you detext vulnerabilities in your web applications in the Web Application Security eKit. IBM Rational AppScan is a leading suite of automated web application security solutions that scan and test for common Web application vulnerabilities. The new Web Application Security eKit provides you with valuable resources, including white papers, demos, and additional information on the benefits of testing your Web applications. FREE! Go There Now!

NEW! Evaluate IBM Lotus Sametime Standard V8.0 Visit IBM developerWorks to download a free trial of the latest release of IBM Lotus Sametime Standard V8.0. Lotus Sametime Standard V8.0 is a platform for unified communications and collaboration that combines security features with an extensible, open solution including integrated Voice over IP, geographic location awareness, mobile clients, and a robust Business Partner community offering telephony and video integration. FREE! Go There Now!

NEW! Rational Asset Manager eKit Learn how to do more with your reusable assets with the free Rational Asset Manager eKit. The eKit includes demos on how Rational Asset Manager tracks and audits your assets in order to utilize them for reuse. Plus you’ll find white papers and a Webcast that discuss the challenges of a Service Oriented Architecture and how Rational Asset Manager can provide quick and effective solutions. FREE! Go There Now!

NEW! Run your first CICS application on a PC using TXSeries for Windows Learn the basics of the IBM Customer Information Control System (CICS). With a hands-on exercise, learn how to get your first CICS application up and running on your desktop using TXSeries V6.1 for Windows. The tutorial shows you how to download and install a free trial version of TXSeries V6.1. FREE! Go There Now!

NEW! Try IBM Rational Asset Manager V7.0 online! You can now evaluate IBM Rational Asset Manager V7.0 online without installing or configuring it on your own system! Rational Asset Manager helps create, modify, govern, find, and reuse any type of development assets, including SOA and systems development assets. Rational Asset Manager helps you reduce software development costs and improve quality by facilitating the reuse of all types of software development-related assets. Visit developerWorks to learn more about this product and register to explore its capabilities online. FREE! Go There Now!

NEW! Webcast: Quickly provide customized, integrated user interfaces with Lotus Notes 8 IBM Lotus Notes 8 provides a wide range of developers the ability to provide customized, integrated user interfaces via composite applications and via custom sidebar and toolbar plug-ins. This webcast provides you with tips and techniques to use with out-of-the-box capabilities of Lotus Notes 8, and survey how you can share useful components within your own company and within a larger community. FREE! Go There Now!

NEW! Webcast: Striking the right balance between manual and automated testing Join this webcast to learn how IBM Rational's Functional Testing solution enables you to implement automation your way, at your pace, with your existing staff. In this webcast, you’ll learn how you can eliminate redundancy of manual test scripts, reduce errors, and increase test coverage through test automation. After this presentation you will understand how IBM Rational Functional Testing solution can streamline your manual testing and make test automation easily attainable. FREE! Go There Now!

All FREE IBM® developerWorks Tools!