Tror den skulle være der nu:
<?php
/**********************************************
* This file displays the change non-sensitive *
* user data form. It submits to itself, and *
* displays a message each time you submit. *
***********************************************/
// A file with the database host, user, password, and selected database
include("top.php");
require_once('db_vars.inc');
include_once('header_footer.php');
include_once('login_funcs.inc');
if (!user_isloggedin()) {
echo '<P>You are not logged in, or this is not your user profile.</P>';
} else {
$user_name = $_COOKIE['user_name'];
$query = "SELECT spillesteder_ID
FROM Spillestederdk_user_id
WHERE user_name = '$user_name'";
$result = mysql_query($query) or die(mysql_error());
while ($data = mysql_fetch_row($result)) {
$spillesteder_ID = "$data[0]"; }
if (isset($_POST['Submit']) && $_POST['Submit'] == 'Submit') {
// Send data to db
// I'm not bothering to check the stringlength of these
// because I'm URL-encoding them
// Format the data
$Navn = $_POST['Navn'];
$Navn = addslashes($Navn);
$Adresse = $_POST['Adresse'];
$Adresse = addslashes($Adresse);
$Sted = $_POST['Sted'];
$Sted = addslashes($Sted);
$Postnummer = $_POST['Postnummer'];
$Kategori = $_POST['Kategori'];
$kapacitet = $_POST['kapacitet'];
$kapacitet = addslashes($kapacitet);
$Leder = $_POST['Leder'];
$Leder = addslashes($Leder);
$Telefon = $_POST['Telefon'];
$LederTelefon = $_POST['LederTelefon'];
$Telefax = $_POST['Telefax'];
$Email = $_POST['Email'];
$Email = addslashes($Email);
$LederEmail = $_POST['LederEmail'];
$LederEmail = addslashes($LederEmail);
$WWW = $_POST['WWW'];
$WWW = addslashes($WWW);
$WWW = urlencode($WWW);
// Update values
$query = "UPDATE spillestederdk
SET Navn = '$Navn',
Adresse = '$Adresse',
Postnummer = '$Postnummer',
Sted = '$Sted',
Kategori = '$Kategori',
kapacitet = '$kapacitet',
Leder = '$Leder',
Telefon = '$Telefon',
LederTelefon = '$LederTelefon',
Telefax = '$Telefax',
Email = '$Email',
LederEmail = '$LederEmail',
WWW = '$WWW'
WHERE ID = '$spillesteder_ID'";
$result = mysql_query($query);
}
//else {
//Henter oplysningerne frem.
$query = "SELECT * FROM spillestederdk where ID=$spillesteder_ID";
$result = mysql_query($query) or die(mysql_error());
while ($data = mysql_fetch_row($result)) {
// Show the form
$php_self = $_SERVER['PHP_SELF'];
$form_str = <<< EOFORMSTR
<body bgcolor="#ACACAC">
<form action="$php_self" 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>Kategori</td>
<td><select name="Kategori">
<option>$data[5]</option>
<option>Scener</option>
<option>Regionale Spillesteder</option>
<option >Klubber</option>
<option>Foreninger</option>
<option>Koncertsteder</option>
<option>Prøvemedlemmer</option>
</select></td>
</tr>
<tr>
<td>Kapacitet:</td>
<td><input type="text" value="$data[6]" name="kapacitet" size="30"></td>
</tr>
<tr>
<td>Leder:</td>
<td><input type="text" value="$data[7]" name="Leder" size="30"></td>
</tr>
<tr>
<td>Telefon:</td>
<td><input type="text" value="$data[8]" name="Telefon" size="30"></td>
</tr>
<tr>
<td>LederTelefon:</td>
<td><input type="text" value="$data[9]" name="LederTelefon" size="30"></td>
</tr>
<tr>
<td>Telefax:</td>
<td><input type="text" value="$data[10]" name="Telefax" size="30"></td>
</tr>
<tr>
<td>Email:</td>
<td><input type="text" value="$data[11]" name="Email" size="30"></td>
</tr>
<tr>
<td>LederEmail:</td>
<td><input type="text" value="$data[12]" 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>
EOFORMSTR;
echo $form_str;
}
}
?>
Du havde nogle mellemrum omkring <<<EOF
Ny bruger
Nybegynder
Opret
Preview
