Fejl i poll script
Hej eksperterJeg er ved at lave et voting script i php jeg køre "locahost"
og for denne fejl:
Notice: Undefined index: poll in C:\wamp\www\ajax-poll\poll.php on line 6 Call Stack: 0.0006 707024 1. {main}() C:\wamp\www\ajax-poll\poll.php:0
Which URL Shortening service you use most?
Notice: Undefined index: result in C:\wamp\www\ajax-poll\poll.php on line 13 Call Stack: 0.0006 707024 1. {main}() C:\wamp\www\ajax-poll\poll.php:0 Notice: Undefined index: voted1 in C:\wamp\www\ajax-poll\poll.php on line 13 Call Stack: 0.0006 707024 1. {main}() C:\wamp\www\ajax-poll\poll.php:0
Notice: Undefined index: voted1 in C:\wamp\www\ajax-poll\poll.php on line 34 Call Stack: 0.0017 709744 1. {main}() C:\wamp\www\ajax-poll\poll.php:0
Her har i koden:
<?php
//Update database information according to your server settings
$conn=mysql_connect('localhost', 'root') or die("Can't connect to mysql host");
//Select the database to use
mysql_select_db('polls') or die("Can't connect to DB");
if(!$_POST['poll'] || !$_POST['pollid']){
$query=mysql_query("SELECT id, ques FROM questions ORDER BY id DESC LIMIT 1");
while($row=mysql_fetch_assoc($query)){
//display question
echo "<p class=\"pollques\" >".$row['ques']."</p>";
$poll_id=$row['id'];
}
if($_GET["result"]==1 || $_COOKIE["voted".$poll_id]=='yes'){
//if already voted or asked for result
showresults($poll_id);
exit;
}
else{
//display options with radio buttons
$query=mysql_query("SELECT id, value FROM options WHERE ques_id=$poll_id");
if(mysql_num_rows($query)){
echo '<div id="formcontainer" ><form method="post" id="pollform" action="'.$_SERVER['PHP_SELF'].'" >';
echo '<input type="hidden" name="pollid" value="'.$poll_id.'" />';
while($row=mysql_fetch_assoc($query)){
echo '<p><input type="radio" name="poll" value="'.$row['id'].'" id="option-'.$row['id'].'" />
<label for="option-'.$row['id'].'" >'.$row['value'].'</label></p>';
}
echo '<p><input type="submit" value="Submit" /></p></form>';
echo '<p><a href="'.$_SERVER['PHP_SELF'].'?result=1" id="viewresult">View result</a></p></div>';
}
}
}
else{
if($_COOKIE["voted".$_POST['pollid']]!='yes'){
//Check if selected option value is there in database?
$query=mysql_query("SELECT * FROM options WHERE id='".intval($_POST["poll"])."'");
if(mysql_num_rows($query)){
$query="INSERT INTO votes(option_id, voted_on, ip) VALUES('".$_POST["poll"]."', '".date('Y-m-d H:i:s')."', '".$_SERVER['REMOTE_ADDR']."')";
if(mysql_query($query))
{
//Vote added to database
setcookie("voted".$_POST['pollid'], 'yes', time()+86400*300);
}
else
echo "There was some error processing the query: ".mysql_error();
}
}
showresults(intval($_POST['pollid']));
}
