Simple Mini Poll class library (SimPoll)

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

Author: Ilir Fekaj
Contact: [email protected]
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
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">rn";
			echo "<form action="$this->results_page" name="pollf" id="pollf" method="get">
			<span class="$this->poll_question">" . $this->active_poll_title . "</span><br />rn";
			
			while ($row = @mysql_fetch_object($sql)) {
				if (!empty($row->polltext)) {
					echo "t<input type="radio" name="voteid" value="$row->voteid" /> $row->polltext <br />rn";
				}
			}
			
			echo "<input type="hidden" name="pollid" id="pollid" value="$this->active_poll_id" /><br />rn";
			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() . "rn";
			}
			echo "<a href="$this->results_page?pollid=$this->active_poll_id">View results</a>
			</form>rn</td></tr></table>rn";
		}
	}
	
	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">rn";
			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 />rn";
			}
			echo "</td></tr>rn";
		}
	}
	
	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>rn";
			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>rn";
			}
			echo "<tr><td class="$this->result_table_cell" colspan="2">Total votes: $this->votecount</td></tr>rn";
		}
		if ($this->old_polls) {
			$this->oldPolls($pollid);
		}
		echo "</table>rn";
		// 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.0rn";
	
	}

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

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

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

EXAMPLE FILES:

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 = htmlspecialchars($_GET['pollname']);
	$q = htmlspecialchars($_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;
}
***********************************************************************************