sheldonlg wrote:
> 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.

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.