is there a way to edit data submitted to db?

[kappaluppa]

I am using mySQL & php. someone fills out a form, data goes to db.

Does anyone know if there is a way to edit that data online once it has been submitted to the db? I currently use phpMyAdmin, but this is not the most user friendly app, and my clients don't know anything dbs/tables/etc. to feel comfortable with it.

Thanks!
K

[mmilano]

yes, use "Update"

for example:
i have a table named "users"
2 fields: "user_id" and "pass"

<?
$user_id=1;
$pass="mypass";

$result=mysql_query("update users set pass='$pass' where user_id='$user_id'");
?>

[sarahk]

I think the real question is what strategy to use.

Create a summary form. To build it query the database table for the updateable records and display a summary. Each row will have a hyperlink with the id of the record which you build up row by row. The link might be <a href="doThis.php?id=23">Tuesday's report</a>

then when the user clicks on tuesday's report they call doThis.php which looks for $id and uses that to query the table again and get all the data for record 23. It then returns a form with the data displayed. Some might be just plain html (ie readonly) and other bits might be <inputs>. When the user clicks submit php will build an update statement to update the table. It would probably then redisplay the summary table.

Remember to use addslashes() and stripslashes().

[KoshNaranek]

there is no need for addslashes when in your php.ini
magic quotes is "ON" makes it a bit easier 😉

By the way... a password in plain-text??? Shouldn't it be
$pass=md5($pass) 🙂