Poll ?

cmccomas

Hey,

Trying to find a nice tutorial/script for a poll to put on my index page. I've searched here and the net and haven't found anything I really like. If anyone could help point me in the right direction I'd appreciate it. Thanks.

kevinsequeira

http://www.hotscripts.com/PHP/Tips_and_Tutorials/Polls_and_Voting/index.html

cmccomas

Thanks.

I tried this one, but not sure how to get it to work in an index.php type file.

cmccomas

Also, what's wrong with this line of code (getting a syntax error):

// generate and execute query
$pid=$_REQUEST['pid'];
$query = "SELECT number, lastname, firstname FROM roster WHERE pid=".$pid;
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

trooper

try this

$query = "SELECT number, lastname, firstname FROM roster WHERE pid='$pid'";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

I've simply put the var $pid inside the sql and enclosed it in single quotes

HTH

Originally posted by cmccomas
Also, what's wrong with this line of code (getting a syntax error):
// generate and execute query
$pid=$_REQUEST['pid'];
$query = "SELECT number, lastname, firstname FROM roster WHERE pid=".$pid;
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
[/B]

cmccomas

Thanks trooper.

Can anyone help me with the link above? I have it setup and running, but not sure how to manipulate poll.php into my index.php page.

kevinsequeira

in your index.php page where u want the poll to appear include the file

include("/path_to_poll.php/poll.php");

thats should display the poll

reg
kevin

cmccomas

Got the poll on there, but now how do I get the page just to refresh with the poll results once someone votes?

URL

kevinsequeira

on poll.php after the code inserts the value in the database redirect to the home page

header("location:http://www.pistonscentral.com/pc/index1.php");

reg
kevin

cmccomas

$strQuery  = "INSERT INTO pollAnswers VALUES(";
$strQuery .= "0, $pollId, '$answer', '$visitorIP')";

if(mysql_query($strQuery))
{
    setcookie("has_voted_" . $pollId, 1, time() + 3600 * 24 * 30);
	ShowVotes();
}
else
{
?>header("location:[url]http://www.pistonscentral.com/pc/index1.php[/url]");

Is that right?

cmccomas

Am I right on this one? I don't think I am.

ereptur

put the header statement in the if clause that sets the cookie.
Also, you want to call ShowVotes() back on the index page after you have tested to see if the cookie exists.
so:

$strQuery  = "INSERT INTO pollAnswers VALUES("; 
$strQuery .= "0, $pollId, '$answer', '$visitorIP')"; 

if(mysql_query($strQuery)) 
{ 
    setcookie("has_voted_" . $pollId, 1, time() + 3600 * 24 * 30); 
//    ShowVotes();   // this should be called on the next page after testing for the cookie set above
    header("location: index1.php");
} 
?>

cmccomas

thanks mate, not sure what is meant by:

// ShowVotes(); // this should be called on the next page after testing for the cookie set above

cmccomas

I can't get it to work at all.

I can vote, it takes the vote, and sends me to page:

newindex.php?pollId=2

But does not show the votes?!?!?

Zack

someone may have said it already (I havent actually read the posts), but before I started coding, I used Sympoll... it can be found here: http://www.ralusp.net/suchislife/sympoll.php

it's a great script. always worked well for me.

cmccomas

Thanks Zack. That's what I am trying to use, trying to get it to work on my index.php page.

Any suggestions?