<form id="show" name="show" action="<?php echo $_SERVER['SCRIPT_NAME']?>" method="post" target="_self">
ID: <input type="text" size="1" name="eid" />
<input type="submit" value="Show" />
<input type="hidden" name="show" value="1" />
</form>
<?php
if(isset($_POST['show']) and $_POST['show']==1)
{
$eid = trim($_POST['eid']);
if($eid !='')
{
$connection=mysql_connect('localhost','admin','xxx') or die(mysql_error());
$sql=mysql_select_db('xxx') or die(mysql_error());
$query = 'SELECT * FROM guestbook WHERE id="'.$eid.'"';
$result = mysql_query($query);
if($result)
{
$row = mysql_fetch_array($result);
}
else
{
echo("Fehler beim laden");
}
}
else
{
echo("Keine id gewählt");
}
}
?>
<form id="edit" name="edit" action="<?php echo $_SERVER['SCRIPT_NAME']?>" method="post" target="_self">
Den zu verändernden Text in untenstehende Felder eintragen!<br>
ID: <input type="text" size="1" name="eid2" value="<?php echo "$eid"?>" />
Name: <input type="text" size="7" name="name2" value="<?php echo "$row[name]"?>" />
Kommentar: <textarea name="comments2" rows="5" cols="45" ><?php echo "$row[comments]"?></textarea>
<input type="submit" value="Editieren" />
<input type="hidden" name="edit" value="1" />
</form>
<?php
if(isset($_POST['edit']) and $_POST['edit']==1)
{
$eid = trim($_POST['eid2']);
$name = trim($_POST['name2']);
$comments = trim($_POST['comments2']);
$connection=mysql_connect('localhost','admin','xxx') or die(mysql_error());
$sql=mysql_select_db('xxx') or die(mysql_error());
$query = 'UPDATE guestbook set name = "'.$name.'", comments = "'.$comments.'" WHERE id = "'.$eid.'"';
echo("Datenbank query:");
echo $query;
$result = mysql_query($query);
}
phpinfo(INFO_VARIABLES);
?>