program/site to generate html form code based on mysql database

Question

I have a mysql databased with many tables and fields. I would like to quickly generate a set of prototype forms based on the mysql database (or create table statements). Anyone have any suggestions? html form code would be great. Full PHP validation and insert updates would be even better. Also Zend framework code would be ideal.

I was looking at mySQL workbench which has an excelent reverse engineering and visual presentaion of databases, but no form generator.

A long time ago my java instructor had a java BeanWizard. He would point the BeanWizard to the Mysql table and generate all of the CRUD from it. The result was jsp files and some class files. I'm sure you could do the same. maybe try using Velocity. My coworker just created his own thing using PHP. Personally I dont like it becasue I still would have to create 3 different files. Basically, my coworker's version doesnt reduce the level of work, and it mostly revolves around maintaining angular/bootstrap functionality. I'd rather create a new one from scratch working off of the Mysql tables. — user1098063
– user1098063, Commented Sep 8, 2015 at 20:23

Crozin · Accepted Answer · 2010-08-30 04:42:13Z

2

You're looking for a thing called scaffolding.

Scaffolding is a meta-programming method of building database-backed software applications. It is a technique supported by some model-view-controller frameworks, in which the programmer may write a specification that describes how the application database may be used. The compiler uses this specification to generate code that the application can use to create, read, update and delete database entries, effectively treating the template as a "scaffold" on which to build a more powerful application.

Please note that ZF and other PHP frameworks are not MVC frameworks - at least those popular like ZF, Symfony, Kohana, CakePHP etc.

It seems that ZF has built-in support for scaffolding: Zend_Controller_Front_Scaffold.

edited Aug 30, 2010 at 4:42

answered Aug 30, 2010 at 3:09

Crozin

44.5k13 gold badges92 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hugo Mota · Accepted Answer · 2010-08-30 03:10:34Z

0

well, what you want is a little too much specific (not saying that it doesn't exist). maybe this could help you with the boring task of writing the html tags:

http://code.google.com/p/zen-coding/

answered Aug 30, 2010 at 3:10

Hugo Mota

11.7k9 gold badges45 silver badges61 bronze badges

Collectives™ on Stack Overflow

program/site to generate html form code based on mysql database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related