Building Dynamic Pages For Editing Database Records

Building Dynamic Pages For Editing Database Records

Post by Ronald Ray » Mon, 12 May 2008 01:27:24


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.
 
 
 

Building Dynamic Pages For Editing Database Records

Post by Paul Lautm » Mon, 12 May 2008 02:58:42


Well I put
php database admin form
into google and clicked "I'm feeling lucky" and found one??

 
 
 

Building Dynamic Pages For Editing Database Records

Post by sheldonl » Mon, 12 May 2008 04:57:26


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.
 
 
 

Building Dynamic Pages For Editing Database Records

Post by sheldonl » Mon, 12 May 2008 06:58:56


I missed that you want it like phpMyAdmin. In that case, have multiple
columns, each being the name of a different field and have the rows be
the data selected. In that case, add buttons for update.
 
 
 

Building Dynamic Pages For Editing Database Records

Post by Jeff Nort » Mon, 12 May 2008 13:47:51

On Sat, 10 May 2008 17:27:24 +0100, in comp.lang.php Ronald Raygun
< XXXX@XXXXX.COM >



This is by no means a simple task.
I've written something like this but at the present time it is not
worthy of distribution. There are too many manual steps still required
to get it to work.

I'll do a bit more work on it and put the code somewhere to make it
available. This could take a while though :-(