Database to fill in a FORM?

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

Hi all- I want to write a program that will read my DB, and populate an HTML form - specifically a form so that the user then can update the fields and resave the information. I can do this by hand - writting a perl script to rewrite the form page in HTML - but I am wondering if there is something already out there to do this? Michael -0 OEMIKE

Comment on Database to fill in a FORM?

Replies are listed 'Best First'.
Re: Database to fill in a FORM? by vladb (Vicar) on Aug 13, 2002 at 03:45 UTC
For a quick solution, you might look at the Class::DBI module. Provided your table setup is simple enough and form isn't overly complex either, this solution should be just the right one for you. Unfortunately, I couldn't verify this on cpan.org (as it simply didn't respond for me ;/), but there should be another module named something like Class-DBI-Form. Which allows seamless integration of database tables and html forms. Update: oh, here, I actually found a link to the module (which I had saved some time ago). The module name is in fact Class::DBI::FromCGI I've found the accompanying documentation to be fairly thorough, so hopefully you won't have a lot of trouble piecing things together. If indeed you have, just ask here and someone will be there to help :) update: corrected s/FormCGI/FromCGI/. Thanks jeffa! _____________________ `# Under Construction` [download]	[reply] [d/l]
(jeffa) Re: Database to fill in a FORM? by jeffa (Bishop) on Aug 13, 2002 at 05:40 UTC
If you want a 'spreadsheet' style interface to a single database table (that has a primary key with unique values), then you can use DBIx::XHTML_Table. Check out Spreadsheet CGI for more info. jeffa L-LL-L--L-LL-L--L-LL-L-- -R--R-RR-R--R-RR-R--R-RR B--B--B--B--B--B--B--B-- H---H---H---H---H---H--- (the triplet paradiddle with high-hat)	[reply]