<form action="<? echo $PHP_SELF; ?>" method="post">
<?php
if ($submit) {
if(!$overskrift)
$errorArray[0] = "Ingen overskrift er indtastet!";
if (!$lokalenr)
$errorArray[1] = "Intet lokalenummer er indtastet!";
if (!$starttime)
$errorArray[2] = "Ingen starttime er indtastet!";
if (!$startminut)
$errorArray[3] = "Intet startminut er indtastet!";
if (!$sluttime)
$errorArray[4] = "Ingen sluttime er indtastet!";
if (!$slutminut)
$errorArray[5] = "Intet slutminut er indtastet!";
if (!$ansvarlig)
$errorArray[6] = "Ingen ansvarlig er indtastet!";
if(!$dag)
$errorArray[7] = "Ingen dag er valgt!";
if (!$dato)
$errorArray[8] = "Ingen dato er valgt!";
if (!$maaned)
$errorArray[9] = "Ingen måned er valgt!";
if (!$campus)
$errorArray[10] = "Ingen campus er valgt!";
if(count($errorArray) < 1)
die("<script>document.location.href='add_arrangement_write.php?overskrift=$overskrift&dag=$dag&dato=$dato&maaned=$maaned&aar=$aar&campus=$campus&lokalenavn=$lokalenavn&lokalenr=$lokalenr&starttime=$starttime&startminut=$startminut&sluttime=$sluttime&slutminut=$slutminut&beskrivelse=$beskrivelse&ansvarlig=$ansvarlig'</script>");
}
php?>
<br>Arrangementsoverskrift:
<BR>
<input type=text size=60 name=overskrift value="<? echo $overskrift; ?>"> (Max. 50 tegn)<font color="#FF0000"> <? echo $errorArray[0]; ?></font>
<BR>
<br>
<?php
$link = mysql_connect("***", "***", "***");
// or die("Could not connect");
// print "Connected successfully";
mysql_select_db("***",$link) or die("Could not select database");
echo "Dato for arrangement: <select name=dag >";
echo "Fra: <select name=dag>";
echo "<option selected>$dag</option>";
$query4 = "SELECT DISTINCT dag_id, dag FROM dag ORDER BY dag_id ASC";
$result4 = mysql_query($query4) or die("Query failed");
while($ares4=mysql_fetch_array($result4))
{
echo "<option value=$ares4[1] name=dag>$ares4[1]</option>";
if($dag==$ares4[1]) echo " selected ";
echo " name=dag>$ares4[1]</option>";
}
echo "</select>";
//Laver dato rullemenu
echo "<select name=dato>";
echo "<option selected>$dato</option>";
echo;
$query3 = "SELECT DISTINCT dato_id, dato FROM dato ORDER BY dato ASC";
$result3 = mysql_query($query3) or die("Query failed");
while($ares3=mysql_fetch_array($result3))
{
echo "<option value=$ares3[1] name=dato>$ares3[1]</option>";
if($dato==$ares3[1]) echo " selected ";
echo " name=dato>$ares3[1]</option>";
}
echo "</select>";
//Laver maaned rullemenu
echo "<select name=maaned>";
echo "<option selected>$maaned</option>";
$query1 = "SELECT DISTINCT maaned_id, maaned FROM maaned ORDER BY maaned_id";
$result1 = mysql_query($query1) or die("Query failed");
echo "<select name=maaned >";
while($ares1=mysql_fetch_array($result1))
{
echo "<option value=$ares1[0]>$ares1[1]</option>";
if($maaned==$ares1[1]) echo " selected ";
echo " name=maaned>$ares1[1]</option>";
}
echo "</select>";
//Laver aar rullemenu
echo "<select name=aar >";
$min_aar = date("Y");
$max_aar = date("Y")+5;
for($a = $min_aar; $a < $max_aar; $a++) {
echo"<option name=aar value=$a>". $a ."</option>\n";
}
?></select>
<font color="#FF0000"> <? echo $errorArray[7]; ?></font>
<font color="#FF0000"> <? echo $errorArray[8]; ?></font>
<font color="#FF0000"> <? echo $errorArray[9]; ?></font>
<BR>
<BR>
Sted for arrangementet:
<BR>
<?php
//Laver lokation rullemenu
echo "<select name=campus>";
echo "<option selected>$campus</option>";
$query = "SELECT DISTINCT campus_id, campusnavn FROM campus GROUP BY campusnavn ORDER BY campusnavn ASC";
$result = mysql_query($query) or die("Query failed");
echo "Campus: <select name=campus >";
while($ares=mysql_fetch_array($result))
{
echo "<option value=$ares[1] name=campus>$ares[1]</option>";
if($campus==$ares[1]) echo " selected ";
echo " name=campus>$ares[1]</option>";
}
echo "</select>";
php?>
Lokalenavn:<input type=text size=25 name=lokalenavn>(f.eks Auditorium)
Lokalenummer:<input type=text size=10 name=lokalenr value="<? echo $lokalenr; ?>">(f.eks 1.63)<font color="#FF0000"> <? echo $errorArray[10]; ?> <? echo $errorArray[1]; ?></font>
<BR>
<BR>
Tidspunkt for arrangement:
<?php
//Laver starttime rullemenu
$query = "SELECT DISTINCT time FROM time";
$result = mysql_query($query) or die("Query failed");
echo "<br>";
echo "<br>";
echo "Fra: <select name=starttime >";
echo "<option selected>$starttime</option>";
while($ares=mysql_fetch_array($result))
{
echo "<option name=starttime value=$ares[0]>$ares[0]</option>";
if($starttime==$ares1[0]) echo " selected ";
echo " name=starttime>$ares[0]</option>";
}
echo " </select>";
echo " :";
//Laver startminut rullemenu
$query = "SELECT DISTINCT minut FROM minutter";
$result = mysql_query($query) or die("Query failed");
echo " <select name=startminut >";
echo "<option selected>$startminut</option>";
while($ares=mysql_fetch_array($result))
{
echo "<option name=startminut value=$ares[0]>$ares[0]</option>";
if($starttime==$ares1[0]) echo " selected ";
echo " name=startminut>$ares1[0]</option>";
}
echo "</select>";
//Laver sluttime rullemenu
$query = "SELECT DISTINCT time FROM time";
$result = mysql_query($query) or die("Query failed");
echo " til: <select name=sluttime >";
echo "<option selected>$sluttime</option>";
while($ares=mysql_fetch_array($result))
{
echo "<option name=sluttime value=$ares[0]>$ares[0]</option>";
if($sluttime==$ares1[0]) echo " selected ";
echo " name=sluttime>$ares1[0]</option>";
}
echo " </select>";
echo " :";
//Laver slutminut rullemenu
$query = "SELECT DISTINCT minut FROM minutter";
$result = mysql_query($query) or die("Query failed");
echo " <select name=slutminut >";
echo "<option selected>$slutminut</option>";
while($ares=mysql_fetch_array($result))
{
echo "<option name=slutminut value=$ares[0]>$ares[0]</option>";
if($slutminut==$ares1[0]) echo " selected ";
echo " name=slutminut>$ares1[0]</option>";
}
echo "</select>";
php?>
<font color="#FF0000"> <? echo $errorArray[2]; ?></font>
<font color="#FF0000"> <? echo $errorArray[3]; ?></font>
<font color="#FF0000"> <? echo $errorArray[4]; ?></font>
<font color="#FF0000"> <? echo $errorArray[5]; ?></font>
<BR>
<BR>
Beskrivelse:
<BR>
<textarea COLS=100 ROWS=5 name=beskrivelse></textarea>
<BR>
(Max. 200 tegn)
<BR>
<BR>
Ansvarlig/kontaktperson:<input type=text size=50 name=ansvarlig value="<? echo $ansvarlig; ?>">(f.eks Underviser/foredragsholder)<font color="#FF0000"> <? echo $errorArray[6]; ?></font>
<BR>
<BR>
Skal arrangementet vises i SDUs arrangementskalender
<select name=kalender>
<option selected value="nej" name=kalender>Nej</option>
<option value="Nej">Ja</option>
</select>
<BR><BR>
<input type=submit name="submit" value="Send">
</form>
<BR>
<BR>
<BR>
<a href="
http://www.sdu.dk/infotavler/index.html">Tilbage til forsiden</a>
-----
værsgo her er hele scriptet
/Pitufo