Tutorials Home
What's New
Top Rated
Submit
myTutes
Random!
mx php poll system
Author: Mirza Hatipovic
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
Cao
Mirza
| » Level Advanced |
|
|
Added: : 2003-07-21
Rating: 6.80 Votes: 80
Hits: 541
|
| » 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.
|
|
|