Tjek gyldigt tidspunkt
På en lille reservationskalender, skal jeg ved redigering af data tjekke om dato, titel og tidspunkt allerede er optaget.§tjek fungerer egentlig udmærket når jeg opretter en reservation, men jeg kan ikke finde ud af at sætte koden ind i denne redigeringskode.
<?
$eventdag = $aar."-".$maaned."-".$dag;
$userid="userid";
$year = date("Y");
$month = date("m");
$dato=date(d)."-".$month."-".$year;
$active = "Y";
$dage = substr($_GET[date],0,2);
$måned = substr($_GET[date],3,2);
$år = substr($_GET[date],6,10);
$date = $år."-".$måned."-".$dage;
$start = $from_.$from2_;
$slut = $till.$still;
$data = date("d/m/Y",time()+($settings['timeoffset']*3600));
$datatmp = explode("/",$data);
$dd = $datatmp[0];
$mm = $datatmp[1];
$yy = $datatmp[2];
$ora = date("H:i" ,time());
$oratmp = explode(":",$ora);
$hh = $oratmp[0];
$xx = $oratmp[1];
$tjek = mysql_query("SELECT * FROM fusion_events5
WHERE
title = '$title'
AND date = '$eventdag'
AND
(starttidspunkt >= '".$start."' AND sluttidspunkt <= '".$slut."')
OR
(starttidspunkt >= '".$start."' AND starttidspunkt < '".$slut."' AND sluttidspunkt >= '".$slut."' AND title = '$title'
AND date = '$eventdag')
OR
(starttidspunkt <= '".$start."' AND sluttidspunkt > '".$start."' AND starttidspunkt < '".$slut."' AND sluttidspunkt >= '".$slut."' AND title = '$title'
AND date = '$eventdag')
OR
(starttidspunkt <= '".$start."' AND sluttidspunkt > '".$start."' AND sluttidspunkt <= '".$slut."' AND title = '$title'
AND date = '$eventdag')
") or die(mysql_error());
if(mysql_num_rows($tjek) !== 0) {
echo "<script type=\"text/javascript\">";
echo "alert(\"Du kan ikke reservere $title fra $from_.$from2_ til $till.$still denne dag. Se ledigt tidspunkt i oversigten.\");";
echo "</script>";
} else {
if($update) {
mysql_query("update fusion_events5 set title='$title',date='$eventdag',description='$description',add_desc='$add_desc',who='$who',from_='$from_',from2_='$from2_',till='$till',still='$still',starttidspunkt='$starttidspunkt',sluttidspunkt='$sluttidspunkt' WHERE cod = '$update'")or die (mysql_error());
echo "Din reservation er rettet";
} else {
$result = mysql_query("SELECT * FROM fusion_events5 WHERE cod = '$cod'");
$row=mysql_fetch_array($result);
echo "
<form action='$PHP_SELF?update=$cod' method='post'>
<table cellpadding=2 cellspacing=10 align=center border=0>
<input type=\"hidden\" name=\"starttidspunkt\" value=\"$row[from_]$row[from2_]\">
<input type=\"hidden\" name=\"sluttidspunkt\" value=\"$row[till]$row[still]\">
<TR><TD><b>AV-udstyr:</b></TD><TD><input name=\"title\" class=\"textbox\" value=\"$row[title]\"></TD>
<TD><b>Dato:</b></TD><TD>
<select class='textbox' name=\"dag\">\n";
for ($i=1; $i<=31; $i++) {
if ($i == $dd) {echo "<option value=\"".$i."\" selected>".$i."</option>\n";}
else {echo "<option value=\"".$i."\">".$i."</option>\n"; }
}
echo "</select> <select class='textbox' name=\"maaned\">\n";
for ($i=1; $i<=12; $i++) {
if ($i == $mm) {echo "<option value=\"".$i."\" selected>".$i."</option>\n";}
else {echo "<option value=\"".$i."\">".$i."</option>\n"; }
}
echo "</select> <select class='textbox' name=\"aar\">\n";
for ($i=2007; $i<=2008; $i++) {
if ($i == $yy) {echo "<option value=\"".$i."\" selected>".$i."</option>\n";}
else {echo "<option value=\"".$i."\">".$i."</option>\n"; }
}
echo "</select>
</TR></TD><TR><TD><b>Afd:</b></TD><TD><input name=\"description\" class=\"textbox\" value=\"$row[description]\"></TD>
<TD><b>Navn:</b></TD><TD><input name=\"who\" class=\"textbox\" value=\"$row[who]\"></TR></TD>
<TR><TD><b>Start:</b></TD><TD><input name=\"from_\" class=\"textbox\" style=width:\"20\" maxlength=\"10\" value=\"$row[from_]\">
<input name=\"from2_\" class=\"textbox\" style=width:\"20\" maxlength=\"10\" value=\"$row[from2_]\"></TR></TD>
<TR><TD><b>Slut:</b></TD><TD><input name=\"till\" class=\"textbox\" style=width:\"20\" maxlength=\"10\" value=\"$row[till]\">
<input name=\"still\" class=\"textbox\" style=width:\"20\" maxlength=\"10\" value=\"$row[still]\"></TR></TD>
<TR><TD><b>Formål:</b></TD><TD><input name=\"add_desc\" class=\"textbox\" value=\"$row[add_desc]\"></TR></TD>
<TR><TD></TD>
<TD align=right><input type='Submit' class=\"button\" value='Opdater'></TR></TD>
</form></table>
";
}
}
opentable("Månedens reservationer");
events5_draw_list();
closetable();
?>
