Question regarding updating database records

[Guest]

I am working on my first dynamic website (php/mysql based).   I need the users of my website to be able to update database records (such as their user profiles or other type of db records).   I am trying to find some html/php/mysql example code that reads a selected database record, builds an html form filled with the obtained database data,  then allows the user to modify any of the data in the form, and finaly submits the form again to the database for an uodate of the record.  Is their some tutorial or some specific code someone can direct me to to implement this specific task.  Thanks for the help!

[bregent]

Have you looked into the update record behavior?

[David_Powers]

There's a tutorial on building your first PHP application in the Adobe Developer Connection. If you want more detailed guidance on using PHP in Dreamweaver, you might be interested in my books, details of which can be found on my website.

[Guest]

David is spot on. It's quite easy if you follow the tutorial. Break what you want to do into parts like:

1.Create and save your page.

2.Build a form with the required fields, naming and ID'ing each one logically so you know the names etc.

3.Create the recordset that brings the info to the page from the database.

4.'Bind' the specific data from the database to the correct form fields to display the existing data in the form.

5.Use the 'update record' server behaviour t'o tell the script/page which database to connect to and which table columns to insert the info into from the form.

Follow the tutorial and you get a much better understanding of the process. It's easy following the tutorial.

[Guest]

Thanks for the answers! I think I have enough guidance now to get to work

on this.

[David_Powers]

I assume this question has now been answered.