Quite some time ago I gobbled together a module for editing records in custom database tables. Since there seems to be recurring interest in doing just that I’m sharing it with you all.
What it doesn’t do:
It does not create, delete or otherwise manage table structures.
What it does.
- Easily add & edit ’table configurations’. Simply select the table form a dropdown list and fill in some custom properties.
- Allows adding, editing, deleting and importing of records (The implementation of importing is rather simple and a bit limited still)
- Date entry uses javascript date selector
- Image & file entry uses mcpuck file manager with image preview.
- If your table is capable it will simulate a trash bin for deleted records, allowing the restore of unintentional deletes
- Uses module permissions to (dis)allow some functions (eg importing, editing configuration etcetera)
Edit: A rather important oversight... When installing the module you need to add this line into the module configuration (and adjust values as needed)
&mod_path=Module path;string;assets/modules/dbedit/ &dbedit_date_format=Date Format (use d,D,m,M,F,n,y,Y as in php date() with simple separator);string;d F Y
I’ve not had time to bring it to an official release so the code is a bit messy in places but I’m using it on virtually every site I’m building with hardly any hiccups. Documentation is rather sparse still as well but I’m sure you’ll figure it out pretty quickly.
Use it, abuse it and let me know what you think.
Edit 6 Feb 09: Changed php short open tags with full equivalent.
