Automatic Web Forms generation from pre-existent DataBase

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

Hi,

I heard that it's possible to automatically generate Web forms from a Data Base (based on it's structure).

More precisely, I need something that generates an Web form given an pre-existent MySQL database.
Can anyone help me? What modules/scripts do you suggest?

Thanks in advanced.

Comment on Automatic Web Forms generation from pre-existent DataBase

Replies are listed 'Best First'.
Re: Automatic Web Forms generation from pre-existent DataBase by moritz (Cardinal) on Jan 17, 2008 at 16:26 UTC
I guess that some module related to CGI::FormBuilder might help you, for example Class::DBI::FormBuilder, but I haven't actually tried that. If you want basic CRUD (create, read, update, delete) CGI scripts for your database maybe a MVC framework like Maypole or Catalyst are a good idea.	[reply]
Re: Automatic Web Forms generation from pre-existent DataBase by zby (Vicar) on Jan 17, 2008 at 18:23 UTC
You can have a look at Catalyst::Example::CRUD - but it is now a bit dated. I am now trying to change it to use HTML::FormFu instead of HTML::Widget.	[reply]
Re: Automatic Web Forms generation from pre-existent DataBase by leocharre (Priest) on Jan 17, 2008 at 19:59 UTC
I'm working on something like this .. Metadata::DB It allows you to put meta on whatever, and generate a search form from the data contained. Imagine you are generating metadata for files, and you have a field called 'color', if you have 10 colors, one of the search fields generated by Metadata::DB::Search::InterfaceHTML is a "color" dropdown search option with the possible values. If the values are more then x, the field is a search box. This allows me to set up file archives for clients, but the info they want to put on files may be .. who knows. And I want the search form to match up with their data, and I don't want to step in and edit html to match it, it would be ridiculous.	[reply]