A tool for form generation based on a mysql table.

[ahardon@gmail.com]

I'm looking for a tool that auto generates forms based on a mysql
table.
I need an interface that will allow:
1. picking a list of columns from the table (so a form that inputs
only part of the table's columns is possible to generate).
2. picking a set of validation rules out of a predefined set of
possible validators.

An example usage of the tool will allow a webmaster to alter the
details required for users sign up in two steps:
1. altering the mysql table adding some new columns.
2. picking which of the new columns should be requested in the signup
form and how to validate each.

After the second step the signup form will be automatically updated.

Before starting to write such a tool I want to make sure that it
doesn't already exist.
Searching the web I found two similar projects: phpMyEdit(http://
www.phpmyedit.org/), and PHP Form Generator(http://
www.phpformgen.com).
But both don't allow what I described above.

Does anyone knows such a project?

[C.]

Re: A tool for form generation based on a mysql table.

On 14 Jul, 11:05, ahar...@gmail.c om wrote:

I'm looking for a tool that auto generates forms based on a mysql
table.
I need an interface that will allow:
1. picking a list of columns from the table (so a form that inputs
only part of the table's columns is possible to generate).
2. picking a set of validation rules out of a predefined set of
possible validators.
>
An example usage of the tool will allow a webmaster to alter the
details required for users sign up in two steps:
1. altering the mysql table adding some new columns.
2. picking which of the new columns should be requested in the signup
form and how to validate each.
>
After the second step the signup form will be automatically updated.
>
Before starting to write such a tool I want to make sure that it
doesn't already exist.
Searching the web I found two similar projects: phpMyEdit(http://www.phpmyedit.org/), and PHP Form Generator(http://www.phpformgen.com).
But both don't allow what I described above.
>
Does anyone knows such a project?

I don't quite follow why phpformgen doesn't do what you ask.

You might want to take a look at PHPeanuts - AIR this requires an
abstract DB definition.

PHPLens might suit your needs too.

My own humble offering - PfP Studio (http://pfp-
studio.sourcefo rge.net) does not yet have any database integration -
of course if you'd like to volunteer to write it please drop me an
email (no agencies/tenders pls - there would no payment of any sort).

C.