Skift farve efter 7 dage
Hvordan får jeg denne til at skifte farve efter 7 dage, Vis man har lånt en film i mere en 7 dage skal den skifte til rød...Håber i forstå mig *S*
KODE:
<?
if ($_POST[submit]) {
$conn = mysql_connect("mydb1.surftown.dk", "dvddata_admin", "8KNO9H29");
$db = mysql_select_db("dvddata_dvddatabasen");
$sql = "INSERT INTO dvdudlaan (navn, film, filmnr, wdato) VALUES ('$_POST[navn]', '$_POST[film]', $_POST[filmnr], '$_POST[wdato]')";
mysql_query($sql) or die(mysql_error());
}
if ($_POST[slet]) {
$conn = mysql_connect("mydb1.surftown.dk","dvddata_admin","8KNO9H29");
$db = mysql_select_db("dvddata_dvddatabasen");
$sql = "DELETE FROM dvdudlaan WHERE filmnr = $_POST[filmnr]";
mysql_query($sql) or die(mysql_error());
}
?>
<html>
<head>
<title>Udlån af dvdfilm!</title>
</head>
<body>
<center>
<p>Udlån af DVD'er</p>
<p>Indsæt nyt udlån:</p>
<form action="viewpage.php?page_id=6
" method="post">
<table>
<tr> <td> Brugernavn: </td> <td> <select name="navn">
<?
$sql = "SELECT user_name FROM fusion_users ORDER BY user_name ASC";
$query = mysql_query($sql);
while($data = mysql_fetch_array($query)) {
print "<option value=\"$data[user_name]\">$data[user_name]</option>\n";
}
?>
</select> </td> </tr>
<tr> <td> Filmnavn: </td> <td> <select name="film">
<?
$sql = "SELECT dvdinfos_name FROM fusion_dvdinfos ORDER BY dvdinfos_name ASC";
$query = mysql_query($sql);
while($data = mysql_fetch_array($query)) {
print "<option value=\"$data[dvdinfos_name]\">$data[dvdinfos_name]</option>\n";
}
?> </select>
</td> </tr>
<tr> <td> Filmnr: </td> <td>
<select name="filmnr">
<?
$sql = "SELECT dvdinfos_nr FROM fusion_dvdinfos ORDER BY dvdinfos_nr
ASC";
$query = mysql_query($sql);
while($data = mysql_fetch_array($query)) {
print "<option value=\"$data[dvdinfos_nr]\">$data[dvdinfos_nr]</option>\n";
}
?> </select>
</td> </tr>
<tr> <td> Dato for udlån: </td> <td> <input type="text" size="24" name="wdato" value="<?
function tildansk($d) {
if (ereg( "([0-9]{4})-?([0-9]{1,2})-?([0-9]{1,2})", $d, $r)) {
$yy=$r[1]; $mm=$r[2]; $dd=$r[3]+0;
$a=getdate(mktime(0,0,0,$mm,$dd,$yy));
switch ($a["wday"]) {
case 0: $ugedag='Søndag'; break;
case 1: $ugedag='Mandag'; break;
case 2: $ugedag='Tirsdag'; break;
case 3: $ugedag='Onsdag'; break;
case 4: $ugedag='Torsdag'; break;
case 5: $ugedag='Fredag'; break;
case 6: $ugedag='Lørdag'; break;
}
switch ($mm) {
case 1: $maaned='januar'; break;
case 2: $maaned='februar'; break;
case 3: $maaned='marts'; break;
case 4: $maaned='april'; break;
case 5: $maaned='maj'; break;
case 6: $maaned='juni'; break;
case 7: $maaned='juli'; break;
case 8: $maaned='august'; break;
case 9: $maaned='september'; break;
case 10: $maaned='oktober'; break;
case 11: $maaned='november'; break;
case 12: $maaned='december'; break;
}
return "$ugedag, d. $dd. $maaned $yy";
} else {
showerror("Ulovligt datoformat: $d");
}
}
$today = date("Ymd");
$idag = tildansk($today);
echo $idag;
?>">
</td> </tr>
<tr> <td colspan="2"> <input type="submit" name="submit" class="button" value="Indsæt filmen!"> </td> </tr>
</table>
</form>
<br> </center>
<hr>
<b>Udlånte film:<b>
<?
$conn = mysql_connect("mydb1.surftown.dk", "dvddata_admin", "8KNO9H29");
$db = mysql_select_db("dvddata_dvddatabasen");
$sql = "SELECT * FROM dvdudlaan order by navn ASC";
$query = mysql_query($sql);
while($data = mysql_fetch_array($query)) {
print "<p><form action=\"viewpage.php?page_id=6\" method=\"post\">";
print "<b><input type=\"hidden\" name=\"filmnr\" value=\"$data[filmnr]\"<b>";
print "<center><table cellpadding=0 cellspacing=0 border=0 width=100%>";
print "<td width=3%><font color=#0066CC><b>$data[filmnr]</b></font></td>";
print "<b><td width=28%><font color=#0066CC>$data[film]</font></td>";
print "<td width=8%><font color=#0066CC>$data[navn]</font></td>";
print "<td width=15% ><font color=#0066CC>$data[wdato]</font></td>";
print "<td width=2% align=right><input type=\"submit\" name=\"slet\" value=\"Slet\" class=\"button\"></td></form></table></p></center>";
}
?>
