Poll for usersystem
Basic poll system, requested by nathan
First off run these in PHPMYADMIN
Code
CREATE TABLE `polls` (
`id` int(11) NOT NULL auto_increment,
`question` varchar(30) NOT NULL default '',
`button1` varchar(30) NOT NULL default '',
`button2` varchar(255) NOT NULL default '',
`button3` varchar(55) NOT NULL default '',
`button4` varchar(55) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
CREATE TABLE `pollvotes` (
`id` int(11) NOT NULL auto_increment,
`vote` varchar(30) NOT NULL default '',
`username` varchar(30) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
Now, read this and name it poll.php
Code
<?
/////////////////////////////////
// poll.php by new2old //
// from rmb-scripting.com //
/////////////////////////////////
// DO NOT REMOVE THE ABOVE
session_start(); //starts sessions
include ( "config.php" ); //includes config
if ($logged['username']) {
if (!$_POST['pollsubmit']) { //checks if poll was subbmitted
$select = mysql_query(mysql_fetch_array( "SELECT * FROM `poll`" )); //gets poll detales
echo ( "<form method='POST'>" );
echo ( "$select[quesion]" );
echo ( "<input type='radio' name='button1' value='$select[button1]'> $select[button1]" ); // shows option 1
echo ( "<input type='radio' name='button2' value='$select[button2]'> $select[button2]" ); // shows option 2
echo ( "<input type='radio' name='button3' value='$select[button3]'> $select[button3]" ); // shows option 3
echo ( "<input type='radio' name='button4' value='$select[button4]'> $select[button4]" ); // shows option 4
echo ( "<input type='submit' name='pollsubmit' value='Vote'>" ); // shows the vote button
} elseif ($_POST['pollsubmit']) { // else it has been posted
$op1 = $_POST['button1']; // get posted info
$op2 = $_POST['button2']; // get posted info
$op3 = $_POST['button3']; // get posted info
$op4 = $_POST['button4']; // get posted info
if ($_POST['$op1'] == "1") { //if you voted option1
$do = mysql_query( "INSERT INTO `pollvotes` (`vote` , `username`) VALUES ('$op1' , '" . $logged['username'] . "'));
echo ( "You voted for $op1" );
} elseif ($_POST['$op2'] == "1") { //or if you voted option2
$do = mysql_query( "INSERT INTO `pollvotes` (`vote` , `username`) VALUES ('$op2' , '" . $logged['username'] . "'));
echo ( "You voted for $op2" );
} elseif ($_POST['$op3'] == "1") { //or if you voted option3
$do = mysql_query( "INSERT INTO `pollvotes` (`vote` , `username`) VALUES ('$op3' , '" . $logged['username'] . "'));
echo ( "You voted for $op3" );
} elseif ($_POST['$op4'] == "1") { //or if you voted option4
$do = mysql_query( "INSERT INTO `pollvotes` (`vote` , `username`) VALUES ('$op4' , '" . $logged['username'] . "'));
echo ( "You voted for $op1" );
}
}
} else {
echo ( "Sign in to vote on the poll" );
}
?>
Where you want that in your template simply add
Code
<? include ( "poll.php" ); ?>
Now call this adminpoll.php
Code
<?
//////////////////////////////
// adminpoll.php by new2old //
// for rmb-scripting.com //
//////////////////////////////
// DO NOT REMOVE THE ABOVE
session_start(); // starts session
include ( "config.php" ); // gets config
if ($logged['username'] && $logged['userlevel'] == "6") { // checks if user is logged in and an admin
switch($_GET['delete']) { //makes multiple pages
default:
if (!$_POST['addpoll']) {
$check = mysql_query(mysql_fetch_array( "SELECT * FROM `polls`" ));
$checks = mysql_num_rows($check); // counts for polls
if ($checks == "1") { //haha sorry one poll at a time
echo ( "You can only have one poll at a time, please delete the current one by clicking <a href='adminpoll.php?delete=do&id=check[id]'>" ); // delete old poll first :)
} elseif ($checks == "0") { //checking there are no current polls
echo ( "Enter the poll values below" );
echo ( "<form method='POST'>" ); // starts form
echo ( "<input tpye='text' name='question'>" ); //question
echo ( "<input type='text' name='button1'>" ); //option 1 :)
echo ( "<input type='text' name='button2'>" ); //option 2 :)
echo ( "<input type='text' name='button3'>" ); //option 3 :)
echo ( "<input type='text' name='button4'>" ); //option 4 :)
echo ( "<input type='submit' name='addpoll' value='Add'>" ); //add the poll :)
}
} elseif ($_POST['addpoll']) { // or if form has been submitted
$op1 = $_POST['button1']; // get posted info
$op2 = $_POST['button2']; // get posted info
$op3 = $_POST['button3']; // get posted info
$op4 = $_POST['button4']; // get posted info
$do = mysql_query( "INSERT INTO `polls` ( `question` , `button1` , `button2` , `button3` , `button4`) VALUES ('$ques' , '$op1' , '$op2' , '$op3' , '$op4');
echo ( "Poll Added" ); // poll is added
}
break; // end of default page
case 'do': //new page 'do'
$do = mysql_query( "DELETE * FROM `polls` WHERE `id` = '" . $_GET['id'] . "');
echo ( "Poll Deleted" ); //deleted poll
break; // end page 'do'
} // end switch
} else {
echo ( "You are either not logged in or are not an Admin" ); // not logged in or are not an admin
}
?>
Thats it :)
any errors please let me no
Thanks