Skip to main content
Anonymous
May 23, 2009
Question

Question regarding updating database records

  • May 23, 2009
  • 5 replies
  • 681 views

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!

This topic is closed to new replies. Start a new post to keep the conversation going.

5 replies

David_Powers
David_Powers
Inspiring
May 23, 2009

I assume this question has now been answered.

Anonymous
May 23, 2009

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.

Anonymous
May 23, 2009

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

on this.

David_Powers
David_Powers
Inspiring
May 23, 2009

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.

bregent
Participating Frequently
May 23, 2009

Have you looked into the update record behavior?

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices