Jeg har oprettet tabellen i databasen osv hvad er fejlen her:
<?php
ob_start();
//headers sættes for ikke at siden skal indlæses fra browserens cache
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Afstemning</title>
<style type="text/css">
body {
background-color:#E08783;
text-align:center;
font-size:20px;
color:#CC0099;
font-weight:bold;
font-family: verdana:
}
table {
text-align:center;
border-collapse:collapse;
border:1px solid #336666;
background-color:#CCCCFF;
width:300px;
height:150;
}
td {
text-align:center;
border-collapse:collapse;
border:1px solid #336666;
color:#990033;
font-size:14px;
font-weight:bold;
font-family:verdana:
}
#ting {
position:absolute;
top:100;
left:400;
width:200px;
height:200px;
}
a {
text-decoration:underline;
color:#990033;
font-size:14px;
font-family:Verdana:
}
a:hover {
text-decoration:overline underline;
color:#FF0000;
}
.bag {
width:100px;
height:10px;
background-color:white;
text-align:left;
}
</style>
</head>
<?php
require('db.php');
?>
<?
if(!$_COOKIE["stem"]) {
if(isset($_GET[stem])) {
mysql_query("update afstemning set antal=antal+1 where id='$_GET[stem]'");
setcookie("stem", time()+360);// sæt selv udløb på cookien, her er det en time
}
} else {
setcookie("stem", time()+360);
echo "Du har stemt, og kan derfor ikke stemme mere";
}
?>
<body>
<center>
<table>
<tr>
<td>Er denne afstemning egentlig noget værd ?
</td>
</tr>
<tr>
<td>
<?php
$res = mysql_query("select * from afstemning where id=1") or die(mysql_error());
while($data = mysql_fetch_array($res)) {
?>
<a href="<? echo "$_SERVER[PHP_SELF]?stem=$data[id]";?>"><b><? echo $data[tekst];?></b></a><br>
<?
echo $data[antal] . " stemmer.<br>";
$ialt = mysql_query("select sum(antal) from afstemning") or die(mysql_error());
$ialt = mysql_result($ialt,0,0);
$pro = $data[antal]*100/$ialt;
echo "<center><div class='bag'><img src='pin.gif' height='10' width='$pro%'></div></center>" . round($pro,2) . "%";
}
?>
</td>
</tr>
<tr>
<td><?php
$res = mysql_query("select * from afstemning where id=2") or die(mysql_error());
while($data = mysql_fetch_array($res)) {
?>
<a href="<? echo "$_SERVER[PHP_SELF]?stem=$data[id]";?>"><b><? echo $data[tekst];?></b></a><br>
<?
echo $data[antal] . " stemmer.<br>";
$ialt = mysql_query("select sum(antal) from afstemning") or die(mysql_error());
$ialt = mysql_result($ialt,0,0);
$pro = $data[antal]*100/$ialt;
echo "<center><div class='bag'><img src='pin.gif' height='10' width='$pro%'></div></center>" . round($pro,2) . "%";
}
?>
</td>
</tr>
<tr>
<td><?php
$res = mysql_query("select * from afstemning where id=3") or die(mysql_error());
while($data = mysql_fetch_array($res)) {
?>
<a href="<? echo "$_SERVER[PHP_SELF]?stem=$data[id]";?>"><b><? echo $data[tekst];?></b></a><br>
<?
echo $data[antal] . " stemmer.<br>";
$ialt = mysql_query("select sum(antal) from afstemning") or die(mysql_error());
$ialt = mysql_result($ialt,0,0);
$pro = $data[antal]*100/$ialt;
echo "<center><div class='bag'><img src='pin.gif' height='10' width='$pro%'></div></center>" . round($pro,2) . "%<br>";
echo $ialt . " har stemt ialt";
}
?>
</td>
</tr>
</table>
</center>
<?
mysql_close();
ob_end_flush();
?>
</body>
</html>
Ny bruger
Nybegynder
Opret
Preview
