arunhorne has asked for the wisdom of the Perl Monks concerning the following question:

Hi

I have a MySQL database table containing a set of parameters used by our build deployment system. From time to time it becomes necessary to add, delete or ammend rows in the parameter table

We would like to create a web page to administer this functionality. I could easily create such a webpage based around iteration over DBI query to display parameters etc etc. However I got thinking and figured this must be a fairly common requirement to want to provide this sort of 'front-end' to a table. All of the searches however that I tried against CPAN etc came back with too many results to be useful.

As you have probably guessed my question is, what is the best way to do this given the points below. I can't believe no one has encountered this problem before, I just can't find any evidence!

Thanks in anticipation

____________
Arun
  • Comment on Generic Editing of Database Tables in Webpages

Replies are listed 'Best First'.
Re: Generic Editing of Database Tables in Webpages
by marto (Cardinal) on Nov 08, 2005 at 16:18 UTC
    Hi arunhorne,

    You have not told us what Database system you are using?
    Have a look at the Maypole and catalyst frameworks which should get you started quickly.

    Hope this helps.

    Martin
    A reply falls below the community's threshold of quality. You may see it by logging in.
Re: Generic Editing of Database Tables in Webpages
by davidrw (Prior) on Nov 08, 2005 at 16:34 UTC
    It's not perl, but i do strongly recommend phpMyAdmin -- you should be able to basically just drop it in (assuming you can run php) and be good to go. This is, however, solely an admin solution -- gives the user full reign to the data and schema.

    For restricting access to specifc actions (e.g. updates only) and/or specific tables, I have successfully (and very quickly) used phpMyEdit
Re: Generic Editing of Database Tables in Webpages
by pboin (Deacon) on Nov 08, 2005 at 18:15 UTC

    You might want to wander over to CPAN and check out: HTML::DBForm.