Featured FLA
» Author: Nitin Tikhe
» Title: Cart
» Description: This Animation Tut is a fun and useful for kids below 15 years. Watch the Flag, Doors, Stick and Horse movements.
» More by Nitin Tikhe
Featured Site
» Posted in the Flash Kit Links section
» Title: Banana Swimwear
» Description: This is a banana swim wear interactive catalog we designed and animated in Flash
Now download the zipped files and extract them to the site root folder. It contains the swf file “ready for start” and the fla file if you want to edit the layout. The swf file MUST reside in the same folder where “poll_index.php” resides.
Administration: Adding questions and answers
This is the most fun part and we’re almost there.
Browse to the “admin” folder. Again open your text editor and paste the following script:
Warning: You have the change the parameters for the database connection to match you database! Look at the first lines of the code.
Poll Admin
<?php
//////// IMPORTANT!!! ///////////////////////////////////////
//change the parameters to match your database
$conn = mysql_connect("your_host","your_username","your_password") or die(mysql_error());
mysql_select_db("your_database", $conn) or die(mysql_error());
////////////////////////////////////////////////////////////////////////////////////////////////////
//ako je formular poslan
if($REQUEST_METHOD == "POST"){
//prvo unesi pitanje
mysql_query("insert into anketa_pit(pitanje) values('".$_POST['pitanje']."')");
//koji id mu je dodjeljen, taj id koristimo zbog referencionalnog integriteta
$new_poll_id = mysql_insert_id();
//sada unesi odgovore u bazu podataka pomocu for petlje
for($i = 1; $i <= 5; $i++){
//dinamicno sastavi varijablu trenutnog odgovora pomocu $i
$trenut_odg = "odgovor".$i;
//ako nije prazan, onda ga ubaci u tabelu zajedno sa nasim ID-om
if(!empty($$trenut_odg)) mysql_query("insert into anketa_odg(poll_id, odgovor, hits) values('".$new_poll_id."', '".$$trenut_odg."', 0)");
}
}
?>
Poll Administration
Save the file as “add_question.php” in the “admin” folder.
Now run “add_question.php” in your browser: www.myserver.com/admin/add_question.php. Complete the form and press OK. You will always use this for if you want to add new polls.
If you have only 2 or 3 answers, simply leave the other fields blank.
That’s all, now run the poll : www.myserver.com/poll_index.php