PHP Basic Tutorials ,PHP Sources Code,PHP Online Example

Algorithms Arrays Passwords Uncategorized
Commerce Uncategorized
Databases Abstraction Layers Informix LDAP MS SQL MySQL ODBC PostgreSQL Uncategorized
Date & Time Calculators Conversion Translation Uncategorized
Discussion Chat Forums Guestbooks Polls Uncategorized
Email Validation Uncategorized
External Uncategorized
Files and Directories Uncategorized
Games Uncategorized
Graphics 3-D Graphs Resizing Thumbnails Uncategorized
HTML Forms Menus & Navigation Source Viewers Tables Templates Uncategorized
HTTP Authentication Cookies File Uploading Uncategorized
I18N Uncategorized
Math Uncategorized
Miscellaneous Uncategorized
Searching and Trees Uncategorized
Security Uncategorized
Text Uncategorized
Utilities Calendars Counters Link Checkers Weather Uncategorized
XML Uncategorized

php sample source codes
<b>SORRY FOR THE LAST BUG</b>(it is ok now)<br> A class for web polls much like a slashdotian one.<br> You may create multiple sections for your polls(4 example: you may use the class in a multilanguage site).<br> Still missing administration fronted! Will do it ASAP <? /* Poll Class - Filipe Almeida - 11:05 quarta - 8 novembro ***************************************************************************** Install procedure *************************************************************************** Create tables in your mysql database. Change function dbconnect() for your database. Create a new file in the directory where you have the copy of poll_class.1.0.php Paste in the file you created the execution example bellow This is a stable version and it works quite well. It's not finished though. You can change a few important things, or derive from the class your display options. Important note: This IS smokeware. If you liked it and are using it, please send to the address: Largo do Corpo Santo n 6 1 1200-129 Lisboa Portugal A PACK OF CIGARETTES. Feel free to email nowan@variograma.com or visit http://mega.ist.utl.pt/~fra for details Thank you *************************************************************************** execution example *************************************************************************** include "poll_class.1.0.php"; if (!$webpollcontrol){ $poll = new POLL($id_poll); $poll->show_poll(); } if ($webpollcontrol == 1){ $poll = new POLL($id_poll); $poll->list_polls(); } if ($webpollcontrol == 3){ $poll = new POLL($id_poll); $poll->show_results(); } if ($webpollcontrol == 5){ $poll = new POLL($id_poll); $poll->save_data($id_poll,$webpollvote); $poll->show_results(); } *************************************************************************** Table Definitions for Poll Class *************************************************************************** table:webpollsQ id_webpoll int(11) pollquestion varchar(250) lang char(3) comment text time_stamp timestamp(14) isvisible int(11) table: webpollsO id_webpoll int(11) id_option int(11) polloption varchar(250) comment text table:webpollsR id_webpoll int(11) id_polloption int(11) id_user int(11) time_stamp timestamp(14) *************************************************************************** CREATE TABLE FOR MYSQL DATABASE *************************************************************************** # -------------------------------------------------------- # # Table structure for table 'webpollsO' # CREATE TABLE webpollsO ( id_option int(11) NOT NULL auto_increment, polloption varchar(250) NOT NULL, comment text, id_webpoll int(11) NOT NULL, PRIMARY KEY (id_option), KEY id_webpoll (id_webpoll) ); # -------------------------------------------------------- # # Table structure for table 'webpollsQ' # CREATE TABLE webpollsQ ( id_webpoll int(11) NOT NULL auto_increment, pollquestion varchar(250) NOT NULL, lang char(3) DEFAULT 'PO' NOT NULL, comment text, time_stamp timestamp(14), isvisible int(11) DEFAULT '1' NOT NULL, PRIMARY KEY (id_webpoll), KEY lang (lang), KEY time_stamp (time_stamp) ); # -------------------------------------------------------- # # Table structure for table 'webpollsR' # CREATE TABLE webpollsR ( id_webpoll int(11) NOT NULL, id_polloption int(11) NOT NULL, id_user int(11), time_stamp timestamp(14), KEY id_webpoll (id_webpoll, id_polloption, time_stamp) ); *************************************************************************** important notes: ***************************************************************************** webpollcontrol == 1 -> see other polls webpollcontrol == 3 -> see current poll results webpollcontrol == 5 -> submit voting / class POLL{ var $ID_POLL;//poll ID - integer var $PollTXT; //poll question - varchar var $PollTime; //poll time - timestamp var $PollComment; //poll comment - text var $PollO; //poll options - array var $PollR; //poll results - array function dbconnect(){ //database connection variables $this->DBHost = "127.0.0.1:3306";//host:port $this->DBName = "dbase"; $this->DBUser = "user"; $this->DBPass = "password"; $this->DBTableQ = "webpollsQ"; $this->DBTableO = "webpollsO"; $this->DBTableR = "webpollsR"; //connect to database $this->myconnection = mysql_pconnect($this->DBHost,$this->DBUser,$this->DBPass); $this->mydatabase = mysql_select_db($this->DBName); } function POLL($id_webpoll = 0, $lang = "PO"){//default poll (most recent), language $this->dbconnect(); $this->lang=$lang; if ($id_webpoll == 0){ //select most recent poll //get id $sqlstring = "select id_webpoll from $this->DBTableQ where isvisible > 0 and lang = '$this->lang' order by time_stamp desc limit 0,1"; $myresult = mysql_query($sqlstring,$this->myconnection); echo mysql_error(); while ($row = mysql_fetch_array($myresult)) $id_webpoll = $row["id_webpoll"]; } if ($id_webpoll > 0){ $this->ID_POLL = $id_webpoll; //prepare question $sqlstring = "select pollquestion,time_stamp,comment from $this->DBTableQ where id_webpoll = '$id_webpoll'"; $myresult = mysql_query($sqlstring); while ($row = mysql_fetch_array($myresult)){ $this->PollTXT = $row["pollquestion"]; $this->PollTime = $row["time_stamp"]; $this->PollComment= $row["comment"]; }; //prepare options array $sqlstring = "select id_option,polloption from $this->DBTableO where id_webpoll = '$id_webpoll'"; $myresult = mysql_query($sqlstring); $this->PollO = array(); while ($row = mysql_fetch_array($myresult)) $this->PollO[$row["id_option"]] = $row["polloption"]; } //kill connection mysql_close($this->myconnection); } function save_data($id_webpoll,$id_polloption,$id_user = 0){//saves user data (after form submission) $this->dbconnect(); mysql_query("insert into $this->DBTableR(id_webpoll,id_polloption,id_user) values('$id_webpoll','$id_polloption','$id_user')"); } function show_poll(){ GLOBAL $PHP_SELF; $echo = $echo."\n".'<form action="'.$PHP_SELF.'" method="POST" name="webpollform">'; $echo = $echo.$this->PollTXT; reset ($this->PollO); while (list ($key, $val) = each ($this->PollO)) { $echo = $echo."\n\t\t".'<br><INPUT TYPE="radio" NAME="webpollvote" VALUE="'.$key.'">'.$this->PollO[$key]; } $echo = $echo."\n\t\t".'<center>'; $echo = $echo."\n\t\t".'<br><input type="submit" name="submitbastard" value="Votar">'; $echo = $echo."\n\t\t".'<br>[<a href="'.$PHP_SELF.'?webpollcontrol=3&id_poll='.$this->ID_POLL.'">See Results</a>]  [<a href="'.$PHP_SELF.'?webpollcontrol=1&id_poll='.$this->ID_POLL.'">Other Polls</a>]'; $echo = $echo."\n\t\t".'<input type="hidden" name="webpollcontrol" value="5">'; $echo = $echo."\n\t\t".'<input type="hidden" name="id_poll" value="'.$this->ID_POLL.'">'; $echo = $echo."\n\t\t".'</center>'; $echo = $echo."\n\t".'</form>'; echo $echo; } function show_results(){ $this->dbconnect(); GLOBAL $PHP_SELF; //prepare results $sqlstring = " select distinct(webpollsR.id_polloption),webpollsO.polloption,sum(1) as totals from webpollsR ,webpollsO where webpollsR.id_webpoll='$this->ID_POLL' and webpollsR.id_polloption=webpollsO.id_option group by webpollsR.id_polloption;"; $myresult = mysql_query($sqlstring); $this->PollR = array(); while ($row = mysql_fetch_array($myresult)) { $this->PollR[$row["polloption"]]=$row["totals"]; $MSUM+=$row["totals"]; }; $echo = $echo.'<b>'.$this->PollTXT.'</b>'; reset ($this->PollR); while (list ($key, $val) = each ($this->PollR)) { $graphic = "\n\t\t".'<br>'.'<table cellpadding="0" cellspacing="0" border="0" width="'.($this->PollR[$key]120/$MSUM).'"><tr><td bgcolor="#FFFF00"><font size="-2"> </font></td></tr></table>'; $this->PollR[$key]=': <b>'.$this->PollR[$key].'</b>'.' <font size="-2">- ('.number_format(($this->PollR[$key]/$MSUM)*100,2).'%)</font>'; $echo = $echo."\n\t\t".'<br>'.$key.$this->PollR[$key].''; $echo = $echo.$graphic; } $echo = $echo."\n\t\t".'<br>[<a href="'.$PHP_SELF.'?webpollcontrol=1&id_poll='.$this->ID_POLL.'">Other Polls</a>]'; echo $echo; } function list_polls(){ GLOBAL $PHP_SELF; $this->dbconnect(); $sqlstring = "select id_webpoll,pollquestion from $this->DBTableQ where isvisible>0 and lang = '$this->lang' order by time_stamp desc"; $myresult = mysql_query($sqlstring); while ($row = mysql_fetch_array($myresult)) { $echo=$echo.'<br><a href="'.$PHP_SELF.'?id_poll='.$row["id_webpoll"].'">'.$row["pollquestion"].'</A>'; }; echo $echo; } function whoamI(){ //usefull for cookie and session control systems. you'll see :) return $this->ID_POLL; } } ?>
E-Poll is a free poll script written in PHP. It is fully customizable, and uses a text file - a csv database where the semi commas separate entries. There is an admin screen where you can edit the poll but it is also possible to edit it manually with a text editor. # The file is to big to paste it here. But you can download it at http://www.e220.f2s.com/download/epoll.tar.gz
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. ********************************************************************************* 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 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> </td> <td> </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&pollid=$row->pollid\">activate</a></td> <td><a href=\"$this->results_page?opt=delete&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: 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; } **********************************************************************************

php.ComLanka.com PHP Tutorial ,PHP source code, PHP online example