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! Discovering the value of WebSphere Process Server WebSphere Process Server delivers a unique integration framework that simplifies existing IT resources. Often, as IT assets grow to support business demand, so too does their complexity and manageability. In this webcast, we’ll discuss how WebSphere Process Server helps deliver an SOA infrastructure that provides a common model to orchestrate, mediate, connect, map, and execute the underlying IT functions. Discover how WebSphere Process Server simplifies integration of business processes by leveraging existing IT assets as reusable services without the complexities of traditional integration methodologies. 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: Architecture Analysts, architects, and developers who have existing COBOL or PL/I skills and want to extend those skills to deploy new workloads on the mainframe can use the IBM Enterprise Modernization Sandbox for System z to find hands-on walkthroughs of common real world scenarios. The scenarios provide examples of how to rapidly design, create, assemble, test, and deploy high-quality Web, Web services, portal, and SOA applications for IBM CICS, IBM IMS, and IBM WebSphere Application Server. FREE! Go There Now!

NEW! IBM Rational AppScan Standard Edition V7.7 Secure your Web applications with IBM Rational AppScan Standard Edition V7.7, previously known as Watchfire AppScan. This Web application security testing tool automates vulnerability assessments and scans and tests for common Web application vulnerabilities. Visit IBM developerWorks to download a free trial of IBM Rational AppScan Standard Edition V7.7. FREE! Go There Now!

NEW! Improve your build process with IBM Rational Build Forge, Part 2: Automate builds for a real-world Tomcat project Learn how Rational Build Forge can extend a simple compile and package build process by adding customization and deployment capability. Go from a manual method to automating: checking for code changes; getting the latest source; compiling and packaging; customizing; copying to and restarting a deployment server; and sending e-mail notification that a new version is available. FREE! Go There Now!

NEW! Software Change and Configuration Management Solution Guidelines This whitepaper provides areas to consider when evaluating any software configuration management solution. It addresses how the IBM solutions (Rational ClearCase and Rational ClearQuest) meet the needs and requirements of both project leaders and developers to provide successful Software Change and Configuration Management. FREE! Go There Now!

NEW! The dirty dozen: preventing common application-level hack attacks As organizations have grown increasingly dependent on online software, the risk of malicious attacks has also become far more serious. Fortunately, well-governed organizations can protect their Web applications by injecting vulnerability assessments and ethical hacks into their software development and delivery processes. This paper describes 12 of the most common hacker attacks and provides basic rules that you can follow to help create more hack-resistant Web applications. FREE! Go There Now!

NEW! Trial download: IBM Rational Manual Tester V7.0.1 Try the latest version of IBM Rational Manual Tester V7.0.1 by downloading a free trial from IBM developerWorks. This manual test authoring and execution tool promotes test step reuse to reduce the impact of software change on testers and business analysts and addresses the needs of teams performing at least a portion of their testing manually. 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! Webcast: Application security testing and Web compliance Join the IBM Watchfire team for an informative discussion on techniques and best practices to proactively manage Web application security and how to effectively build application security testing into the software development lifecycle (SDLC). In this Software Delivery Platform webcast you will learn: How to better understand potential web application security vulnerabilities, best practices and how to effectively integrate application security testing into the software development lifecycle, the importance of detecting and removing software vulnerabilities during application development. FREE! Go There Now!

All FREE IBM® developerWorks Tools!