Voting
Hej Jeg får denne fejl:Notice: Undefined index: is_posted in C:\wamp\www\picture voting\test.php on line 30 Call Stack: 0.0016 693744 1. {main}() C:\wamp\www\picture voting\test.php:0
Når jeg køre dette script:
jeg har markeret line 30 med ()
<?php
$db = mysql_connect("localhost", "root");
mysql_select_db("voting", $db);
$votes_array = array("Jeg elsker den!", "Den er ok...", "Ved ikke", "Kan ikke lide den...");
?>
Hvad synes du om den nye F599 Fiorano?
<?php
$ip = $_SERVER['REMOTE_ADDR'];
$result = mysql_query("SELECT COUNT(*) FROM afstem WHERE ip = '".$ip."'") or die (mysql_error());
?>
<?php
(line 30) if (mysql_result($result, 0) == 0):
?>
<?php
if ($_POST['is_posted']):
mysql_query("INSERT INTO afstem (vote, ip) VALUES ('".$_POST['vote']."', '".$ip."')") or die(mysql_error());
endif;
?>
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<input type="hidden" name="is_posted" value="1">
<?php
for ($i=0; $i<count($votes_array); $i++):
echo "<input name=vote type=radio value=".$i."> ".$votes_array[$i]."<br />";
endfor;
?>
<input type="submit" value="Stem">
</form>
<?php
else:
?>
<?php
$result = mysql_query("SELECT COUNT(*) FROM afstem") or die(mysql_error());
$total_votes = mysql_result($result, 0);
?>
<?php
$result = mysql_query("SELECT vote, COUNT(*) AS num_of_votes FROM afstem GROUP BY vote") or die(mysql_error());
while ($data = mysql_fetch_array($result, MYSQL_ASSOC)):
$vote = $data['vote'];
$votes[$vote] = $data['num_of_votes'];
endwhile;
for ($i=0; $i<count($votes_array); $i++):
echo $votes_array[$i].": ";
if (isset($votes[$i])):
echo "(".round($votes[$i] / $total_votes * 100)."%)";
else:
echo "(0%)";
endif;
echo "<br />";
endfor;
?>
<?php
endif;
?>