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.