Featured Flash FLA 11336 Flash Movies | 2 New Flash Movies Added What's New | Top 100 Featured FLA » Author: Surjit Dhami » Title: Book » Description: Book » More by Surjit Dhami Random FLAs | Add Flash Movie Featured Flash Site 5848 Flash Sites | 0 New Flash Links What's New | Top 100 Flash Site Featured Site » Posted in the Flash Kit Links section » Title: All-American Rejects » Description: Get to know this great band by exploring their "practice room". Random Links | Add your own Flash Related Links

1277 Tutorials 7 New Tutorials Added! What's New | Top100 » Create xml slideshow with free template » How to Insert a Multilingual Subtitle Into Your Flash Video Studio » How to Create Cool Halloween Slideshow » Debugging flash using the Firebug console » Create Flash Slideshow on Blogger » FLASH TRICKS IN WEB ADVERTISING: FLASH BANNERS » HTML Photo Gallery Tutorial » Create your first flash site – PART 1 » How to Make a Flash Photo Gallery » Unknown Tag: Title10 Random Tutorial | Add Site

Webmaster (IL) Next Step Systems US-IL-Chicago Post A Job | Post A Resume

Tutorials Home What's New Top Rated Submit myTutes Random!

Tutorials » Dynamic_Content

mx php poll system
Author: Mirza Hatipovic

<?
////////               IMPORTANT!!!              ///////////////////////////////////////
//change the parameters to match your database
$conn = mysql_connect("localhost","","") or die(mysql_error());
mysql_select_db("test", $conn) or die(mysql_error());
////////////////////////////////////////////////////////////////////////////////////////////////////
//the rest doesn't have to be changed…
session_start();
//ako nije jos dat glas, pokazi formular
if(!session_is_registered("vote_request")){
 //show poll form
 //concate form strings
 $poll_form = "
\n
";
 //select question + all possible answers
 //first we must find the id of the last inserted question
 $db_data = mysql_fetch_array(mysql_query("SELECT MAX(poll_id) AS max_id FROM anketa_pit"));
 //id of the last question
 $last_que_id = $db_data[max_id];
 //questions
 $rez = mysql_query("SELECT pitanje FROM anketa_pit WHERE poll_id = ".$last_que_id);
 //fetch question
 $question_data = mysql_fetch_array($rez);
 //add question to form
 $poll_form .= "".$question_data[pitanje]."
";
 //oslobodi memoriju
 mysql_free_result($rez);
 //get all possible answers
 $rez = mysql_query("SELECT odg_id, odgovor FROM anketa_odg WHERE poll_id = ".$last_que_id);
 //counter variable
 $i = 0;
 //fetch answer from db and add them to form
 while($anwer_data = mysql_fetch_array($rez)){
 //current status of the radio button, checked or unchecked???
 ++$i == 1 ? $status = "checked" : $status = "";
 //concate radio buttons
 $poll_form .= " ".$anwer_data[odgovor]."
\n";
 }
 //add submit button
 $poll_form .= "\n";
 //complete form tag
 $poll_form .= "
\n";
 //if the poll form is submitted
 if($REQUEST_METHOD == "POST"){
 //register voter to deny more votes
 session_register("vote_request");
 //update table
 mysql_query("UPDATE anketa_odg SET hits = hits + 1 WHERE odg_id = ".$_POST[answer]);
 //get values from db and show it in swf
 //first we must find the id of the last inserted question
 $db_data = mysql_fetch_array(mysql_query("SELECT MAX(poll_id) AS max_id FROM anketa_pit"));
 //id of the last question
 $last_que_id = $db_data[max_id];
 //get question
 $rez = mysql_query("SELECT pitanje FROM anketa_pit WHERE poll_id = ".$last_que_id);
 //fetch question
 $question_data = mysql_fetch_array($rez);
 $question = $question_data[pitanje];
 //get num of all answers to that question
 $rez = mysql_query("SELECT SUM(hits) as all_hits FROM anketa_odg WHERE poll_id = ".$last_que_id);
 //fetch result
 $data = mysql_fetch_array($rez);
 //num of all hits
 $num_ans = $data[all_hits];
 //free some memory
 mysql_free_result($rez);
 //get all possible answers
 $rez = mysql_query("SELECT odgovor, hits FROM anketa_odg WHERE poll_id = ".$last_que_id);
 //counter variable
 $i = 1;
 //init. flash vars
 $flash_vars = "question=".$question."&";
 //fetch answer from db and add them to form
 while($ans_dta = mysql_fetch_array($rez)){
 $flash_vars .= "odgovor".$i."=".$ans_dta[odgovor]."&proc".$i."=".round((intval($ans_dta[hits])/intval($num_ans))*100)."&br_gl".$i."=".$ans_dta[hits]."&";
 $i++;
 }
 //free some memory
 mysql_free_result($rez);
 //pokreni pop up zajedno sa varijablama
 echo "";
 //zapamti varijable
 session_register("flash_vars");
 echo "view results";
 } else {
 //add form or link to template
 echo $poll_form;
 }
} else {
 //show link to view only the results
 echo "view results";
}
?>

That’s the code required for the poll, if you want to use it as a module on a page, simply put the code above into your own php script and separate it with blocks, like this:

» Forums
	More help? Search our boards for quick answers!

Please rate this tutorial, 10 is the top rating, you can also click the comments link to read/write a review.

10 9 8 7 6 5 4 3 2 1