Automated Form Generation

JLHeidecker

Have:

1 MySQL db; 1 table; 10 fields

Want:

Software package that will look at my database, and generate a compilation of php scripts that allow the control of this table from the web.

In other words, scripts for viewing, editing, and deleting data from the database with simple HTML forms.

Essentially, the end product is a watered down version of phpMyAdmin.

Is there a product out there that will do this?

This is the foundation of all the web development that I do... create a database, import data from excel, then create forms on the web to control the database. these simple applications should write themselves!

ednark

i know of two pear libraries you can use

Pear:😃B_DataObjects will make your mysql tables into php objects
Pear::HTML_QuickForm will generate a working form from a conf file you define

read up on those two, I have used the to do just what you want

etully

I've used this and it works for normal MySQL tables..
http://www.endsdesign.com/scripts/#aed

I have been keeping my eyes open for a similar product that will ALSO work with relational tables. For example:

I have one DB, and three tables:
customers (a list of my customers)
cars (a list of popular automobiles)
customer_car_xref (a cross reference table that shows which cars my customers own)

I want to be able to create a config file that defines customers can be many to many cars and then the software makes the Admin forms where every Add/Edit Customer form shows the full list of cars with checkboxes.

If anyone knows of one, I will trade my first born child. (Oh yeah, and not for Windows.)

JLHeidecker

Thanks for the good info guys. Also, I came across this software by doing a google search:

http://www.yessoftware.com/products/product_detail.php?product_id=1

Click on the "View Flash Demo" icon. It can take a database (just about any format) and create a web application with access control in a number of scripting languages (php, asp, coldfusion...).

You can choose from a number of different templates for the look of the application. it's not too bad