Keep It Simple, Stupid | |
PerlMonks |
HTML interfaces for editing SQLby Cody Pendant (Prior) |
on Jul 07, 2006 at 03:06 UTC ( [id://559708]=perlquestion: print w/replies, xml ) | 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')
Back to
Seekers of Perl Wisdom
|
|