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!

Role of Integrated Requirements Management in Software Delivery As organizations integrate software into every aspect of business, they are constantly pressured to deliver faster, better, and cheaper results. Unfortunately, a “dis-integrated” software delivery approach reduces returns while increasing costs. This IBM Rational White Paper shows how Integrated Requirements Management aligns organizations around maximizing value and keeping pace with change. FREE! Go There Now!

NEW! Maintaining QoS and Process Integrity in an SOA Environment This webcast outlines the best practices that must be instituted to gain the maximum benefit from SOA while maintaining high quality of service. Whether you are deploying new applications or managing and monitoring your existing infrastructure, learn how you can ensure high quality of services with SOA based solutions from IBM. All registrants who attend this live Web Seminar will receive complimentary access to a white paper titled “Maintaining QoS in an SOA Environment”. 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! 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! Trial download: IBM Rational Functional Tester V7.0.1 Get a free trial download of the latest version of IBM Rational Functional Tester V7.0.1. Rational Functional Tester is an automated functional and regression testing solution for QA teams concerned with the quality of their Java, Microsoft Visual Studio .NET, and Web-based applications. FREE! Go There Now!

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! Project and Portfolio Management Executive Resource Kit Portfolio Management is about effectively managing portfolio value by aligning portfolio investments with business goals. This complimentary e-kit provides a collection of materials that can help you understand how IBM Rational enables and automates best practices for improved governance and clear visibility into portfolio and project performance across the entire IT project lifecycle. FREE! Go There Now!

NEW! Webcast: Introducing the new Information Server and Solutions community: LeverageInformation User communities play an important role in communication and collaboration around products, solutions and other areas of special interest to members. Successful communities are able to provide the right mix of content and services to deliver a value proposition that resonates with each audience. Join Tom Inman, VP of Marketing for Information and Platform Solutions as he introduces the new LeverageINFORMATION community. During this webcast, learn about the value provided by the community and how customers and partners derive value from the community in addressing their own technical and business challenges. 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!

Build Forge Express demo: Enabling software delivery excellence for small and midsized businesses This demonstration gives you an overview of IBM® Rational® Build Forge Express Edition, a global offering that provides a framework to automate and execute software processes. Rational Build Forge provides a software assembly line that can support all of your tools, technologies, and platforms so you can achieve a repeatable, reliable, and traceable build and release process. FREE! Go There Now!

All FREE IBM® developerWorks Tools!