A Flash Developer Resource Site














Internet Commerce

Partners & Affiliates














Developer Channel

internet.com


Featured Flash FLA
Gallery Downloads 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
Gallery Downloads 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
Flash Tutorials 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

Justtechjobs.com Post A Job | Post A Resume


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

Search Tutorials


Tutorials Tutorials » Dynamic_Content

Categories mx php poll system
Author: Mirza Hatipovic

 
Page 5
«prev 1 2 3 4 5 6 7 next»

<?
////////               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:

«prev 1 2 3 4 5 6 7 next»

» Level Advanced

Added: : 2003-07-21
Rating: 7.03 Votes: 73
Hits: 537
» Author
Mirza Hatipovic is freelance developer based in Bosnia and Hercegovina. He uses Flash MX, PHP, XML amd Coldfusion to create dynamic web content.
» Download
Download the files used in this tutorial.
Download (5 kb)
Get conversion and unzipping tools for PC and Mac here!

» 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
Read or Post Comments
 
   
 

internet.commediabistro.comJusttechjobs.comGraphics.com

Search:

WebMediaBrands Corporate Info

Legal Notices, Licensing, Reprints, Permissions, Privacy Policy.
Advertise | Newsletters | Shopping | E-mail Offers | Freelance Jobs