Database Create/Edit/Update module

As I recently discovered, with eForm and eForm2db you can make a nice form to have users submit data and then it’s captured in a (mysql) database table.

From a help page ( http://wiki.modxcms.com/index.php/DB_query_and_Placeholders ) I managed to have a page ’get’ the data from the table and display it on a webpage.

I would like a standard ’set’ of database manipulation modules, so that you can easily create pages for displaying&updating database fields. A bit like the pre-made templates that Dreamweaver has.

For example:
- create the DB table through phpmyadmin (directly in modx?)
- fill the table with content from a eform2db-enabled form
- have an admin page that lists each of the DB items in a table (a bit like it’s done in PhpMyadmin)
- webinterface: have ’edit’, ’update’, ’delete’ buttons next to each record

So either some pre-made templates, or some kind of module/chunk/snippet/whatever that makes it easy to modify the items from within a web interface.

For example it could be something like:

- eForm2db-insert
- eForm2db-update
- eForm2db-delete

where the user can create a form using e-form, then according to the values entered in the input field(s), items in the database can be inserted/updated/deleted. Or using links instead of form fields.

that already exist its called eform2db

http://modxcms.com/forums/index.php/topic,8111.0.html

Quote from: Dimmy at Feb 27, 2009, 03:52 AM

that already exist its called eform2db

http://modxcms.com/forums/index.php/topic,8111.0.html

Oh I see it does, I thought it could only do ’Inserts’...

there is dbEdit if you need this in the manager side (not the front end):
http://modxcms.com/forums/index.php/topic,32720.0/topicseen.html

Quote from: dev_cw at Feb 27, 2009, 06:48 AM

there is dbEdit if you need this in the manager side (not the front end):
http://modxcms.com/forums/index.php/topic,32720.0/topicseen.html

That’s great!

In this case, it did not have to be front-side indeed.