Problem med update af db via form.
Jeg har en side som burde opdatere informationer i min db. Problemet er at istedet for at opdatere siden får jeg bare en blank side frem når jeg submitter. Håber at nogle kan hjælpe mig.Her er min side.
<?php
include("../incl/db/db_password.inc");
$ID = $_GET['ID'];
mysql_connect("$hostname","$user","$password");
mysql_select_db("$db");
if (isset($_POST['Submit']) && $_POST['Submit'] == 'Submit') {
// Format the data
$Navn = $_POST['Navn'];
$Adresse = $_POST['Adresse'];
$Sted = $_POST['Sted'];
$genre = $_POST['genre'];
$kapacitet = $_POST['kapacitet'];
$Postnummer = $_POST['Postnummer'];
$Leder = $_POST['Leder'];
$Telefon = $_POST['Telefon'];
$LederTelefon = $_POST['LederTelefon'];
$Telefax = $_POST['Telefax'];
$Email = $_POST['Email'];
$LederEmail = $_POST['LederEmail'];
$WWW = $_POST['WWW'];
// Update values
$query = "UPDATE $db
SET Navn = '$Navn',
Adresse = '$Adresse',
Sted = '$Sted'
genre = '$genre'
kapacitet = '$kapacitet'
Postnummer = '$Postnummer'
Leder = '$Leder'
Telefon = '$Telefon'
LederTelefon = '$LederTelefon'
Telefax = '$Telefax'
Email = '$Email'
LederEmail = '$LederEmail'
WWW = '$WWW'
WHERE ID = $ID";
$result = mysql_query($query);
if (mysql_affected_rows() == 1) {
header("Location: medlemmer.php");
} else {
error_log(mysql_error());
$success_msg = '<P>Something went wrong.</P>';
}
}
else{
//Henter oplysningerne frem.
$query = "SELECT * FROM spillestederdk where ID=$ID";
$result = mysql_query($query);
while ($data = mysql_fetch_row($result)) {
// Show the form
$php_self = $_SERVER['PHP_SELF'];
$form_str = <<< EOFORMSTR
<HTML>
<HEAD>
<TITLE>Spillesteder.dk - Administration</TITLE>
</HEAD>
<BODY>
<form action="$php_self?ID=$ID" method="post">
<table width="200" border="1">
<tr>
<td>Navn:</td>
<td><input type="text" value="$data[0]" name="Navn" size="30">
</td>
</tr>
<tr>
<td>Adresse:</td>
<td><input type="text" value="$data[1]" name="Adresse" size="30"></td>
</tr>
<tr>
<td>Postnummer:</td>
<td><input type="text" value="$data[2]" name="Postnummer" size="30"></td>
</tr>
<tr>
<td>By:</td>
<td><input type="text" value="$data[3]" name="Sted" size="30"></td>
</tr>
<tr>
<td>Genre:</td>
<td><input type="text" value="$data[4]" name="Genre" size="30"></td>
</tr>
<tr>
<td>Kapacitet:</td>
<td><input type="text" value="$data[5]" name="kapacitet" size="30"></td>
</tr>
<tr>
<td>Leder:</td>
<td><input type="text" value="$data[6]" name="Leder" size="30"></td>
</tr>
<tr>
<td>Telefon:</td>
<td><input type="text" value="$data[7]" name="Telefon" size="30"></td>
</tr>
<tr>
<td>LederTelefon:</td>
<td><input type="text" value="$data[8]" name="LederTelefon" size="30"></td>
</tr>
<tr>
<td>Telefax:</td>
<td><input type="text" value="$data[9]" name="Telefax" size="30"></td>
</tr>
<tr>
<td>Email:</td>
<td><input type="text" value="$data[10]" name="Email" size="30"></td>
</tr>
<tr>
<td>LederEmail:</td>
<td><input type="text" value="$data[11]" name="LederEmail" size="30"></td>
</tr>
<tr>
<td>WWW:</td>
<td><input type="text" value="$data[12]" name="WWW" size="30"></td>
</tr>
</table>
<input type="Submit" value="Submit" name="Submit">
</form>
</FORM>
</BODY>
</HTML>
EOFORMSTR;
echo $form_str;
}}
?>
