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!

Be the first to hear about i5/OS V6R1! Hold your calendar on January 30, 2008 for this free webcast on the new i5/OS. Rational's Enterprise Modernization products will be discussed at this webcast as they help to drive the application development environment for this new System i OS. <br />And learn how i5/OS will take you to the next step of efficient, resilient business processing. You will hear about the new i5/OS capabilities as it will be the most significant i5/OS release in years. If you cannot join the webcast on 1/30/08 you can still use this link to listen to the replay.<br /> FREE! Go There Now!

NEW! "ebook: Exploring IBM SOA Technology & Practice Learn field-tested SOA principles, methodology, technology and implementation from the global SOA market leader - in a new e-book by an IBM SOA expert. Written by IBM Certified SOA Solution Designer Bobby Woolf, "Exploring IBM SOA Technology & Practice" is the ultimate insider's guide to SOA - a PDF e-book packed cover to cover with IBM's specific advice on how to make your SOA implementation a success. FREE! Go There Now!

NEW! Addressing software-as-a-service challenges using Tivoli security and WebSphere solutions Building a software-as-a-service solution requires addressing a few key technical challenges. In this webcast, we'll focus on the role of IBM Tivoli Directory Server and WebSphere Portlet Factory in creating a Software as a Service solution. We will demonstrate how to use Tivoli Directory Server to prevent the user population of one tenant from accessing the virtual portal and portlet components of another tenant. We will also use the dynamic profile capability of WebSphere Portlet Factory to create multiple highly customized applications from one code base. FREE! Go There Now!

NEW! Hacking 101 Join us for this web seminar to learn how you can defend your web applications from attack. Learn about the 3 most common web application attacks, including how they occur and what can be done to prevent them. We’ll also discuss manual versus automated approaches for scanning and identifying web application vulnerabilities and how IBM Rational AppScan, an automated vulnerability scanner, can help you automate more of what you are doing manually today. FREE! Go There Now!

NEW! IBM Enterprise Modernization Sandbox for System z IBM Enterprise Modernization solutions help organizations evolve core IT systems towards modern architectures and technologies—reducing the burden of maintenance and freeing up resources to develop new business requirements and capabilities. With the IBM Enterprise Modernization Sandbox for System z you can evaluate IBM Enterprise Modernization solutions focused on five key areas: Assets, Architectures, Skills, Processes and Infrastructures, and Investment. Each solution is based upon real customer experiences and offers a proven path to get you started with your modernization projects. FREE! Go There Now!

NEW! Section 508 of the U.S. Rehabilitation Act: Web accessibility compliance Because access to government information continues to be an area of concern for many U.S. citizens with disabilities, the U.S. government enacted Section 508 of the Rehabilitation Act in 2001 to ensure that government agencies create accessible Web content, enabling all citizens to access the information they need. A fully accessible Web site makes Web content accessible to all individuals, including those with disabilities, who may be accessing Web content via a variety of user agents. Common user agents include standard Web browsers, text-only browsers, assistive devices and mobile devices such as cell phones or personal digital assistants (PDAs). FREE! Go There Now!

NEW! Trial download: IBM Rational Method Composer V7.2 Get a free trial download of the latest version of IBM Rational Method Composer V7.2 which helps you deliver customized yet consistent process guidance to your project teams and IT organization, and includes the latest version of IBM Rational Unified Process (RUP), which has provided process guidance to teams since 1996. FREE! Go There Now!

NEW! Trial download: IBM Rational Performance Tester V7.0.1 Get a free trial download of the latest version of IBM Rational Performance Tester V7.0.1, a load and performance testing solution for teams concerned about the scalability of their Web-based applications. Combining multiple ease-of-use features with granular detail, Rational Performance Tester simplifies the test-creation, load-generation and data-collection processes that help teams ensure the ability of their applications to accommodate required user loads. FREE! Go There Now!

NEW! Using Rational Business Developer to enhance your developer productivity Join this Rational Talks to You teleconference, to hear how Enterprise Generation Language (EGL) eliminates the need for tedious and error-prone low level coding, so developers can focus on business requirements. EGL extends the Rational software development platform with a simplified programming language that enables developers who have little or no experience with Java, Web technologies or Service Oriented Architecture, to create enterprise-class applications and services quickly and easily. It also allows developers who may have little or no mainframe programming experience to quickly create traditional mainframe components. FREE! Go There Now!

NEW! Whitepaper: Achieving consistency between business process models and operational guides Explore how Rational and WebSphere software enable enterprise documentation in SOA environments. Specifically, a new integration between IBM WebSphere® Business Modeler and IBM Rational® Method Composer software can help technical writers more easily keep enterprise operations manuals in sync with changes that are made to business processes, resulting in more accurate and timely documentation that benefits the entire enterprise. FREE! Go There Now!

All FREE IBM® developerWorks Tools!