Edit a database

[eternalprophet]

Got a question.

I have a form setup that will submit some data to a MySQL database. That's all cool n stuff. I know how to submit it, and I know how to get it to display. How would I be able to edit it, like have the data from a particular field display in the textbox?

I basically want to have a simple form like so

<form method="post" action="display.php">
<input type="text" name="uid">
</form>

and on the display.php I want to have all of the fields, which is uid, ufname, ulname...for id, first name, last name, but I want it to display the firstname and lastname of the id in question.

Can anyone point me to an example that will do that?

I guess my question is really, how can I display information from a database in a php page so that I can edit and update the record?

[kevinsequeira]

1. first get the data from the database
   $q = "select * from $table where id=".$id;
   $r = mysql_query($q);
   $row = mysql_fetch_array($r);
   $uid_value = $row[$id];

2. in the form

<form method="post" action="display.php">
<input type="text" name="uid" value="<?php print($uid);>">
</form>

reg
kevin

[eternalprophet]

<form method="post" action="display.php>
<input type="text" name="uid" value="<?php print($uid);?>">
</form>

The Form:

<form method="post" action="display.php">
<input type="text" name="uid">
</form>

The .php page

<?php
$uid=$HTTP_POST_VARS['uid'];
$q = "select * from $table where uid=".$uid;
$r = mysql_query($q);
$row = mysql_fetch_array($r);
$uid= $row[$id];
$ufname= $row[$ufname];
$ulname= $row[$ulname];
?>

<form>
<input type="text" value="<?php print($uid);?>">
<input type="text" value="<?php print($ufname);?>">
<input type="text" value="<?php print($ulname);?>">
</form>

Is that close? I am not at home to be able to test this.

Thanks for the help in advance.

If I use the script with your help and put it online would you like
//Script contributions from your name here
in the .php file, or is this pretty much standard script for being able to edit data?

[ahundiak]

You will need a submit button as well:
<input type="submit" name="summit" value="Push Me" />

To give the user something to press.
Usually placed right before the </form> element.

And by the way
<?=$uid?> is the same as <?php print $uid; ?>

Just saves a bit of typing in your templates.

[eternalprophet]

value"<?=$uid?> ?

[ahundiak]

Yep. value="<?=$id?>"

It may look a bit strange but it's basically a short hand way to echo a single variable. Certainly not required. What you had will work just as well. Just a bit more typing.