Checke at tidspunkt ikke er optaget
Jeg har brug for at checke et starttidspunkt og et sluttidspunkt i mit bookingscript for at forhindre dobbelbooking.Jeg har forsøgt på forskellige måder og det seneste jeg er nået frem til er dette, men jeg kan bare ikke se mig ud af det.
from_ = starttime
from2_ = startminut
till = slutminut
till = slutminut
Og scriptet:
<?php
require_once "maincore.php";
require_once "subheader.php";
require_once "side_left.php";
include_once("modules/events2/main.php");
?>
<script language='javascript'>
function velgDato( ) {
var hojde = 385; // indsæt højde og bredde her
var bredde= 490;
if (navigator.appName!="Netscape") {
var pos = ",left="+250+",top="+200
} else {
var pos = ",screenX="+50+",screenY="+50
};
window.open("exp68692pop.html","b"
,"location=0,menubar=0,toolbar=0"+pos
+",resizable=1,scrollbars=0,height="+hojde+",width="+bredde);
}; //end velgDato( )
function brugDato ( dd ) {
var dag = "_0"+dd.getDate()+"-";
var mnd = "_0"+(1+dd.getMonth())+"-";
var dato = dag.substring(dag.length-3)
+ mnd.substring(mnd.length-3)
+ dd.getFullYear();
document.din_form.date.value = dato;
}; //end brugDato ( Date objekt )
</script>
<?php
$userid="userid";
$year = date("Y");
$month = date("m");
$dato=date(d)."-".$month."-".$year;
$active = "Y";
$dag = substr($_GET[date],0,2);
$måned = substr($_GET[date],3,2);
$år = substr($_GET[date],6,10);
$date = $år."-".$måned."-".$dag;
$tjek = mysql_query("SELECT * FROM fusion_events2
WHERE
title = '$title'
AND date = '$date'
AND from_ BETWEEN '$from_' AND '$till'
AND
till BETWEEN '$from_' AND '$till'
AND
from2_ BETWEEN '$from2_' AND '$still'
AND
still BETWEEN '$from2_' AND '$still'
") or die(mysql_error());
if(mysql_num_rows($tjek) !== 0) {
opentable("Busreservation");
echo "<b><font color=red>Du kan ikke reservere denne bus på i dette tidsrum. Find andet tidspunkt.<a href='".BASEDIR."events2.php'>Tilbage til oversigt.</a></b></font>";
closetable();
} else {
// funktion
if(isset($_GET[title]))
@mysql_query("INSERT INTO fusion_events2 (title,date,from_,from2_,till,still,who,description,add_desc,active,user_id)
VALUES ('$_GET[title]','$date','$_GET[from_]','$_GET[from2_]','$_GET[till]','$_GET[still]','$_GET[who]','$_GET[description]','$_GET[add_desc]','$active','".$userdata['user_id']."')") or die("Der er sket en fejl. Fejl: ".mysql_error());
opentable("Busreservation");
echo "<b><font color=red>Du har reserveret en bus. <a href='".BASEDIR."events2.php'>Se din reservation i oversigten.</a></b></font>";
closetable();
}
opentable("Reserver en bus");
?>
<form name="din_form" method="get" action="<?php echo $_SERVER["PHP_SELF"]; ?>">
<table cellpadding=2 cellspacing=10 align=center border=0>
<TR><TD><b>Bus:</b></TD><TD>
<select size="1" name="title">
<option value="Røde Lyn">Røde Lyn</option>
<option value="Sølvpilen">Sølvpilen</option>
</select></TD>
<TD><b>Dato:</b></TD><TD>
<input name="date" style= width:"120" type='text' value= "<?=$dato?>">
<input type='button' value='Vælg dato' onclick="velgDato()">
</TR></TD>
<TR><TD><b>Fra:<br></b></TD><TD>
<select size="1" name="from_">
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09" selected>09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
</select>
<select size="1" name="from2_">
<option value="00" selected>00</option>
<option value="15">15</option>
<option value="30">30</option>
<option value="45">45</option>
</select>
<TD><b>Navn:</b></TD><TD>
<input type="text" name="who" style= width:"120"><br>
</TR></TD>
<TR><TD><b>Til:</b></TD><TD>
<select size="1" name="till">
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12" selected>12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
</select>
<select size="1" name="still">
<option value="00" selected>00</option>
<option value="15">15</option>
<option value="30">30</option>
<option value="45">45</option>
</select>
</TR></TD>
<TD><b>Afdeling:</b></TD><TD>
<select size="1" name="description">
<option value="Hus A">Hus A</option>
<option value="Hus B">Hus B</option>
<option value="Hus C">Hus C</option>
<option value="Hus D">Hus D</option>
<option value="Anneks">Anneks</option>
<option value="Kælder">Kælder</option>
<option value="Sportsgruppe">Sportsgruppe</option>
<option value="Aktivitetshjørnet">Aktivitetshjørnet</option>
</select><br>
</TR></TD>
<TR><TD valign="top"><b>Formål:</b></TD><TD>
<textarea name="add_desc" rows="4" style= width:"120"></textarea><br>
<br></TD>
<TD></TD>
<TD align="right"><input type="submit" name="send" value="Reservere"></TR> </TD>
</form></table>
<?php
echo " <a href='".BASEDIR."events2.php'>Tilbage til oversigt</a>";
closetable();
opentable("Denne måneds reservationer");
events2_draw_list();
closetable();
require_once "side_right.php";
require_once "footer.php";
?>
