<?php
$tbl = "tabelle";
if(!isset($_REQUEST['action']) && !$action = $_REQUEST['action'])
$action = "list";
switch($action)
{
case 'list':
$query = mysql_query("SELECT * FROM `".$tbl."` ORDER BY `name` ASC")
or die(mysql_error()."<br />".mysql_errno());
while($row = mysql_fetch_assoc($query))
{
echo $row['vorname'].' '.$row['name']." \n";
echo '<a href="'.$_SERVER["PHP_SELF"].'?action=edit&id='.$row["id"].'">'."\n";
echo '<br>'."\n";
}
break;
case 'edit':
$id = mysql_real_escape_string($_GET['id']);
$query = mysql_query("SELECT `name`,`vorname` FROM `".$tbl."` WHERE `id` = '$id'")
or die(mysql_error()."<br />".mysql_errno());
list($name,$vorname) = mysql_fetch_array($query);
?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="POST">
<input type="hidden" name="id" value="<?php echo $_GET['id']; ?>" />
<input type="hidden" name="action" value="save" />
Name: <input type="text" name="name" value="<?php echo $name; ?>" /><br>
Vorname: <input type="text" name="vorname" value="<?php echo $vorname; ?>" /><br>
<input type="submit" name="submit" value="ändern" />
</form>
<?php
break;
case "save":
$id = mysql_real_escape_string($_POST['id']);
$name = mysql_real_escape_string($_POST['name']);
$vorname = mysql_real_escape_string($_POST['vorname']);
$query = mysql_query("UPDATE `".$tbl."` SET `name` = '".$name."', `vorname` = '".$vorname."' WHERE `id` = '$id'")
or die(mysql_error()."<br />".mysql_errno());
echo "Daten geändert";
break;
}
?>