Parsing fra FORM
Hello!Jeg har et problem, den nedenstående kode virker ikke som den skal :( Det virker som om at værdierne fra html-formen ikke bliver parset videre. Noget der også undrer mig er hvorfor resultatet af $PHP_SELF er \"\".
Håber i kan hjælpe.
function add_hotel()
{
//If form is filled the data will be saved in database
if ($Submit == \"Add Hotel\")
{
$link = mysql_connect(\"localhost\", \"root\", \"\") or exit(\"Could not connect\");
mysql_select_db(\"creambets\");
mysql_query(\"INSERT INTO tab_hotel (hotelnavn, casinonavn, beskrivelse, adresse1, postnr, telefon, fax, email, hotelpic, id_region, expedia_url, affiliate_url) VALUES (\'$hotelnavn\', \'$casinonavn\', \'$beskrivelse\', \'$adresse1\', \'$postnr\', \'$telefon\', \'$fax\', \'$email\', \'$hotelpic\', \'$id_region\', \'$expedia_url\', \'$affiliate_url\')\") or die (\"Failed adding hotel\");
mysql_close($link);
echo \"hotelnavn\";
}
else
{
//Otherwise the formular will be displayed
echo \"$PHP_SELF
<form name=\\\"form1\\\" method=\\\"post\\\" action=\\\"$PHP_SELF\\\">
<table width=\\\"75\\\" border=\\\"1\\\">
<tr>
<td colspan=\\\"4\\\">Formular for adding Hotel:</td>
</tr>
<tr>
<td>Hotelname:</td>
<td>
<input type=\\\"text\\\" name=\\\"hotelnavn\\\">
</td>
<td>Casinoname:</td>
<td>
<input type=\\\"text\\\" name=\\\"casinonavn\\\">
</td>
</tr>
<tr>
<td>Hotel description:</td>
<td colspan=\\\"3\\\">
<textarea name=\\\"beskrivelse\\\"></textarea>
</td>
</tr>
<tr>
<td>Address:</td>
<td>
<input type=\\\"text\\\" name=\\\"adresse1\\\">
</td>
<td>Zipcode:</td>
<td>
<input type=\\\"text\\\" name=\\\"postnr\\\">
</td>
</tr>
<tr>
<td>Phonenumber</td>
<td>
<input type=\\\"text\\\" name=\\\"telefon\\\">
</td>
<td>Fax Number:</td>
<td>
<input type=\\\"text\\\" name=\\\"fax\\\">
</td>
</tr>
<tr>
<td>:Email:</td>
<td>
<input type=\\\"text\\\" name=\\\"email\\\">
</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Hotel picture:</td>
<td colspan=\\\"3\\\">
<select name=\\\"hotelpic\\\">
</select>
</td>
</tr>
<tr>
<td>Region:</td>
<td colspan=\\\"3\\\">
<select name=\\\"id_region\\\">\";
// Extracting regions to selectbox
$link = mysql_connect(\"localhost\", \"root\", \"\") or exit(\"Could not connect\");
mysql_select_db(\"creambets\");
$regions = mysql_query(\"SELECT id, region FROM tab_region\");
while ($regions_out = mysql_fetch_array($regions))
{
$region = $regions_out[\"region\"];
echo \"<option>$region</option\";
}
mysql_close($link);
echo \"
</select>
</td>
</tr>
<tr>
<td>Expedia Url:</td>
<td colspan=\\\"3\\\">
<input type=\\\"text\\\" name=\\\"expedia_url\\\">
</td>
</tr>
<tr>
<td>Affiliate Url:</td>
<td colspan=\\\"3\\\">
<input type=\\\"text\\\" name=\\\"affiliate_url\\\">
</td>
</tr>
<tr>
<td colspan=\\\"4\\\">
<hr>
<input type=\\\"submit\\\" name=\\\"Submit\\\" value=\\\"Add Hotel\\\">
</td>
</tr>
</table>
</form>
\";
}
