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')
=~y~b-v~a-z~s; print
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: HTML interfaces for editing SQL
by perl_lover (Chaplain) on Jul 07, 2006 at 03:49 UTC | |
by reneeb (Chaplain) on Jul 07, 2006 at 07:13 UTC | |
Re: HTML interfaces for editing SQL
by jbisbee (Pilgrim) on Jul 07, 2006 at 03:56 UTC |