View Single Post

  #3 (permalink)  
Old 05-10-2008
sheldonlg
 
Posts: n/a
Default Re: Building Dynamic Pages For Editing Database Records

Ronald Raygun wrote:
> I need to dynamically create a page that allows me to edit records in a
> a database table. Basically, something very similar to how PHP MyAdmin
> works only slighly less complicated. There does not need to be the
> ability to edit the structure of the database or tables or anything like
> that, simply a listing of the records and the ability to either
> edit/delete or create a new record in the table.
>
> I have searched google for a long time but found nothing. Help will be
> appreciated.


What is so difficult? Just build an array with the database fields,
generated a table with <tr>s between each field and have there be two
columns -- one with the name printed and the other with text input and
have the name of the text field be the name of the db field. Then add a
submit button and process the form. In the php target, simply extract
the values of all the fields and do an update of the db. Have the id
field always be first so that you know how to do the where clause.

You can get the field names with mysql_list_fields, although it is
deprecated. You could use mysql_query with "SHOW COLUMNS FROM table foo".

This seems like less than an hour's work.
Reply With Quote