Featured FLA
» Author: Bugra Ozden
» Title: Skatalog v9 - product catalog
» Description: Create your product catalog easly and publish on your website or Create your image gallery, documents list, portfolio. Fully XML Driven
» More by Bugra Ozden
Featured Site
» Posted in the Flash Kit Links section
» Title: Creative DW Image Show PRO
» Description: Creative DW Image Show PRO is a Dreamweaver extension which enables the user to create multimedia presentations. It combines the features of the popular Creative DW Image Show with the ability to add professional text effects to slides (similar to After Effects). The product is very customizable: the user can choose the duration of the transition effects, the slide motion start and end position, zoom and panning type for both images and texts.
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