Sikre at data ikke er i db allerede
Nu har jeg prøvet på adskellige måder at lave et check på en form, men uden resultat.Nu vil jeg prøve at lave et check bare med en værdi og jeg skal nok have det skåret ud i pap.
Hvordan sikrer jeg mig at værdien af "title" ikke allerede findes i db i nedenstående script og der samtidig gives en meddelelse til brugeren om at "du kan desværre ikke --- o.s.v."
<?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";
?>
