Featured Flash FLA 11401 Flash Movies | 5 New Flash Movies Added What's New | Top 100 Featured FLA »  Author: Nick Kouvaris »  Title: Znax »  Description: Znax is a board game. Click 4 tiles of the same color and form squares as big as you can. You will erase all the tiles inside the square and collect points. Get maximum score if you make a square with game edges. »  More by: Nick Kouvaris Random FLAs | Add Flash Movie Featured Flash Site 4941 Flash Sites | 1 New Flash Links What's New | Top 100 Flash Site Featured Site »  Author Agence WOP Digital Agency »  Title: Electricdrum »  Description: French WOP Agency, 3D websites, Flash (Papervision, Away 3D), event or institutional projects. The agency operates on all digital projects: consulting, design, graphic design, development, online communication. The WOP agency follows you on the implementation of original, creative and optimized digital projects. Random Links | Add your own Flash Related Links

1481 Tutorials 7 New Tutorials Added! What's New | Top100 » How To Make A Simple Animation Using Christmas Clips » Simple Step by step flash game tutorial Spot the diffrence » How To Make A Moving Text Slide » Create Flash Banner With Text Float Effect » How To Make Zoo Photos Slideshow » How To Make A Dolphin Photos Slideshow » How To Make A Fathers Day Slideshow » How To Make A Transparent Background of Your Flash File » Create Flash Banner With Text Disco Light Effect Today we will introduce you a Text Disco Light eff » Unknown Tag: Title10 Random Tutorial | Add Site

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