|There's more than one way to do things|
HTML interfaces for editing SQLby Cody Pendant (Prior)
|on Jul 07, 2006 at 03:06 UTC||Need Help??|
Cody Pendant has asked for the
wisdom of the Perl Monks concerning the following question:
I need to produce HTML forms for a client to use to manage their MySQL database.
Is there any interface-to-database Perl module that will automate things like the creation of HTML forms from MySQL records, for simple C.R.U.D. operations?
I'm considering just doing a quick "describe table" before opening a form for the record and creating form fields based on the results, that is, if it's a VARCHAR, make an INPUT field for it, if it's a TEXT, make a TEXTAREA field for it, if it's an auto-incrementing primary key field make it into a hidden field and so on. The UPDATE or INSERT that happens when you save would just be a list of fields and values from CGI params, etc.
It wouldn't be terribly hard to write myself, but surely someone's created this kind of thing already?
I've had a look at CPAN and can't find anything that seems right.
($_='kkvvttuu bbooppuuiiffss qqffssmm iibbddllffss')