Selectboxe i form
Jeg har en form, hvor jeg tilføjer noget timer og minutter til en bookingkalender.Lige nu bliver data (timer, minutter) tilføjet til hver sit felt i db.
Hvordan kan jeg tilføje timer og minutter til samme felt i db således, at starttidspunkt kan blive eks. 07.00
At tilføje til samme felt i db vil gøre det noget lettere for mig senere, at lave et check på om tidspunktet allerede er optaget
Mit script:
<?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;
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());
$tjek = mysql_query("SELECT * FROM fusion_events2 WHERE title= '$_GET[title]'");
if (mysql_num_rows($tjek))
{
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";
?>
