Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Are there PHP tools to generate CRUD screens from DB schema? [closed]

Tags:

database

php

crud

I've been using phpMyEdit to quickly generate CRUD screens for databases; it's a quick way to start interacting with data in my projects (and lets me toss together internal admin pages fast)... but it doesn't read the DB schema, so I have to manually set it up.

I'm looking for a tool/way to quickly generate CRUD from beginning to end: I give it a DB table, and it reads the schema, generates the HTML markup for the form, and does the CRUD work on the db itself.

Does this exist? My goal is to have zero setup for basic functionality, and then I'd love the option of being able to extend that basic setup to further refine the experience. (For example: if it can see my database table has four varchar() fields, that would be ready to go with four editing fields "out of the box," but then I'd like to be able to add a little bit of code/set some flags to specify the one varchar() column that is meant to hold an email address, so the tool would then do data validation to only allow emails in that field.)

UPDATE: I'm seeking a solution that I can drop into my existing PHP project(s) -- not an entire framework.

like image 362
Eric Avatar asked Apr 12 '11 00:04

Eric


2 Answers

The Yii Framework Does this out of the box. You use a web gui to plug in the database table name and it generates crud screens and active record classes along with all the models, views, and controllers.

like image 69
k to the z Avatar answered Nov 15 '22 11:11

k to the z


Try Grocery CRUD: http://www.grocerycrud.com/

It's based on codeigniter and is quick to setup basic CRUD.

like image 32
singhspk Avatar answered Nov 15 '22 11:11

singhspk