updatering av mysql i php
Hej!
jag sitter och försöker få ihop ett script som ska uppdatera min mysql server när man fyller i ett formulär i php. Jag kan inte fatta varför det inte fungerar. Den är till en medlems sida. Skulle någon kunna hjälpa mig?
Jag har en conection till en databass include "config.php"
<?php
session_start();
if(!session_is_registered(username)){
header("location:login.php");
}
?>
<?php
include ("config.php");
$sql = "SELECT * FROM users WHERE username='$username' ";
$result=mysql_query($sql);
while($row=mysql_fetch_array($result)){
$username = $row["surname"];
$firstname = $row["firstname"];
$surname = $row["surname"];
$weight = $row["weight"];
$height = $row["height"];
}
function filter($date)
{
return trim(htmlspecialchars($date));
}
$username = filter($_POST['username']);
$firstname = filter($_POST['firstname']);
$surname = filter($_POST['surname']);
$weight = filter($_POST['weight']);
$height = filter($_POST['height']);
if (username)
{
$sql = mysql_query ("UPDATE users SET username='$username', firstname='$firstname', surname='$surname', weight='$weight', height='$height' WHERE username='$username'")
or die (mysql_error());
}
?>
<form action="konto.php" method="post">
Username: <input type="text" name="username" id="username" value="<?php echo $username; ?>"><br />
Firstname: <input type="text" name="firstname" id="firstname" value="<? echo $firstname; ?>"><br />
Surname: <input type="text" name="surname" id="surname" value="<?php echo $surname; ?>"><br />
weight: <input type="text" name="weight" id="weight" value="<?php echo $weight; ?>"><br />
height: <input type="text" name="height" id="height" value="<?php echo $height; ?>"><br />
<input type="submit" value="Submit">
</form>