PDA

View Full Version : Database Admin Controller for Code Igniter and Ext JS 4



gjsmith66
6 Feb 2012, 11:41 AM
I have been using Code Igniter and Ext JS 4 for several months. In that time, I have created a couple basic templates to display MySQL tables and perform CRUD on those tables. In addition, I have wanted to create some basic admin screens for the Core Igniter configured databases. In my configuration, I have multiple databases defined, using Code Igniter’s built-in support for multiple database access. So, given all of that, I have created a controller that will display all Code Igniter configured databases, list the contained tables, and allow you to display and edit those tables.

Right now the basic template supports simple pagination, as well as Adding, Deleting, and Updating records. While fairly full-featured, it does not yet handle remote sorting. In addition, I am sure you will find some minor display issues with data fields that are not your standard integer or varchar. I will look to address these later. As an added bonus, the template references Ext JS remotely, so you do not need to install Ext JS 4 for these admin screens to work. If you are interested in giving Ext JS 4 a try, this is a great way to explore with it.

One feature of this controller is that the panel for the table admin is dynamically generated. This will allow you to save the created JS file, and modify it to suit your needs. You can easily create very custom screens from this generated template.

You can download the zip file here (http://www.z-car.com/blog/2012/02/03/database-admin-controller-for-code-igniter-and-ext-js-4).

mitchellsimoens
6 Feb 2012, 11:45 AM
No online demo? B)

gjsmith66
6 Feb 2012, 1:23 PM
Try :

http://www.z-car.com/demo/index.php/tableadmin

First couple tables are populated.