poll script

[vikela]

PHP Online opinion poll script using MySQL

 

 

 

 

I am trying to run an opinion poll on my homepage and i have managed to get a script and include it into my homepage..problem is that the results are appearing on a different window?how can i make the results appear on the same spot where the poll is displayed?here is the code i have so far.

 

display poll

Code: [select]

<?   

//$dbservertype='mysql';

$servername='myserver';

// username and password to log onto db server

$dbusername='myusername';

$dbpassword='mypasswd';

// name of database

$dbname='mydb';

 

 

connecttodb($servername,$dbname,$dbusername,$dbpassword);

function connecttodb($servername,$dbname,$dbuser,$dbpassword)

{

global $link;

$link=mysql_connect ("$servername","$dbuser","$dbpassword");

if(!$link){die("Could not connect to MySQL");}

mysql_select_db("$dbname",$link) or die ("could not open db".mysql_error());

}

 

/* Read the session id to

display the poll result link

*/

 

if(mysql_fetch_object(mysql_query("select s_id from plus_poll_ans where s_id='$s_id'"))){

//echo "<a href=polling/view_poll_result.php>View the poll result</a>";}

echo"<a href=polling/view_poll_result.php onclick=MM_openBrWindow('polling/view_poll_result.php','poll','width=350,height=200')>View Result</a>";}

/* You can keep the parts below inside the else area if you don't want to

show the form for the visitors who have already participated in the poll

*/

$qst_id=2; // Change this ID for a different poll

$query=mysql_fetch_object(mysql_query("select * from plus_poll where qst_id=$qst_id"));

echo "

<form method=post action=poll_displayck1.php>

<input type=hidden name=qst_id value=$qst_id>

<table border='1' cellspacing='0'  width='120' id='AutoNumber1'>

  <tr>

    <td width='100%'> <font face='Verdana' size='2' >$query->qst</font></td>

  </tr>

  <tr>

    <td width='100%' >

    <table border='0' cellspacing='0' width='100%'  cellpadding='0'>

      <tr bgcolor='#f1f1f1'>

        <td width='10%'><input type='radio' value='$query->opt1'  name='opt'></td>

        <td width='90%'><font face='Verdana' size='2' >$query->opt1</font></td>

      </tr>

      <tr>

        <td width='10%'><input type='radio' value='$query->opt2'  name='opt'></td>

        <td width='90%'><font face='Verdana' size='2' >$query->opt2</font></td>

      </tr>

      <tr bgcolor='#f1f1f1'>

        <td width='10%'><input type='radio' value='$query->opt3'  name='opt'></td>

        <td width='90%'><font face='Verdana' size='2' >$query->opt3</font></td>

      </tr>

      <tr>

        <td width='10%'><input type='radio' value='$query->opt4'  name='opt'></td>

        <td width='90%'><font face='Verdana' size='2' >$query->opt4</font></td>

      </tr>

    </table>

    </td>

  </tr>

<tr>

    <td width='100%' bgcolor='#ffff00' align=center>

<font face='Verdana' size='2' ><input type=submit value=Submit></form></td>

  </tr>

 

</table>

";

/* End of the form displaying the poll question and its four options for selection */

?>

 

 

 

</script>

 

 

<center>

 

<a href="polling/view_poll_result.php">View Results</a><br>

<br>

 

 

/show results

 

 

connecttodb($servername,$dbname,$dbusername,$dbpassword);

function connecttodb($servername,$dbname,$dbuser,$dbpassword)

{

global $link;

$link=mysql_connect ("$servername","$dbuser","$dbpassword");

if(!$link){die("Could not connect to MySQL");}

mysql_select_db("$dbname",$link) or die ("could not open db".mysql_error());

}

//////////////////////////////

echo "<font size='2' face='Verdana' color='#000000'> ( Poll ID = 1)</font>";

 

$qst_id=2; // change this to change the poll

 

/* Find out the question first */

$fg=mysql_query("select qst from plus_poll where qst_id='$qst_id'");

$row=mysql_fetch_object($fg);

 

echo "<br><b><br>$row->qst</b><br>"; // display the question

/* for percentage calculation we will find out the total number

of answers ( options submitted ) given by the visitors */

$rt=mysql_num_rows(mysql_query("select ans_id from plus_poll_ans where qst_id=$qst_id"));

 

 

/* Find out the answers and display the graph */

$query="select count(*) as no,qst,plus_poll_ans.opt from plus_poll,plus_poll_ans where plus_poll.qst_id=plus_poll_ans.qst_id and plus_poll.qst_id='$qst_id' group by opt ";

$rs=mysql_query($query);

echo "<table cellpadding='0' cellspacing='0' border='0' >";

 

while($noticia = mysql_fetch_array($rs)){

echo "<tr>

    <td width='40%' bgcolor='#F1F1F1'> <font size='1' face='Verdana' color='#000000'>$noticia[opt]</font></td>";

$width2=$noticia['no'] *50 ;

$ct=($noticia[no]/$rt)*100;

$ct=sprintf ("%01.2f", $ct); // number formating

echo "<td width='10%' bgcolor='#F1F1F1'> <font size='1' face='Verdana' color='#000000'>($ct %)</font></td><td width='50%' bgcolor='#F1F1F1'><img src='graph.jpg' height=10 width=$width2></td>

  </tr>";

echo "<tr>

    <td  bgcolor='#ffffff' colspan=2></td></tr>";

 

 

}

echo "</table>";

echo "</font>";

 

 

?>

 

 

 

can somebody please help!

[jlavik]

<a href="polling/view_poll_result.php">View Results</a><br>

 

When they click to view the results, they are being directed to a different page, view_poll_result.php. You might want to check out the poll at http://www.w3schools.com/php/php_ajax_poll.asp. It's much less complicated than the one you're using, but it *does* display results in the same spot as you desire. Perhaps it will point you in the right direction.

[phpMyTony]

Use the

[code]

[/code] tags - it will look easier

[vikela]

<a href="polling/view_poll_result.php">View Results</a><br>

 

When they click to view the results, they are being directed to a different page, view_poll_result.php. You might want to check out the poll at http://www.w3schools.com/php/php_ajax_poll.asp. It's much less complicated than the one you're using, but it *does* display results in the same spot as you desire. Perhaps it will point you in the right direction.

 

thanks but i want 1 that uses a db