CRUD with Ci 1.7

[eluser]umefarooq[/eluser]
hi omrion here is simple CRUD for you and whole CI Community.

Simple CRUD

here how to use it

1. first call crud library controller's constructor or any specific function of controller.

Code:

$this->load->library('crud');

2. here is insert,update and delete using library

in insert you have to pass table name and array of data to insert.

Code:

$data = array('name'=>$name,'description'=>$desc);
$this->crud->setRecord('test',$data);

in update record you have to pass table name, array of data and selector of specific data

Code:

$this->crud->updateRecord('test',$data,array('id'=>$id));

in delete record you have pass table name and selector of specific data

Code:

$this->crud->deleteRecord('test',array('id'=>$id));

to get specific record, it will return you only one row by passing table name and selector.

Code:

$row = $this->crud->getRecord('test',array('id'=>$id));

to get all rows just pass table name,

Code:

$data['rows'] = $this->crud->getRecords('test');

and when using pagination pass record per page and page number to the getRecords function as

Code:

$data['rows'] = $this->crud->getRecords('test',20,1);

to get the count of all rows pass only table name

Code:

$this->crud->getCount('test');

to get last inserted id

Code:

$this->crud->getLastID('test');

this CRUD library is generic library no need to code models again and again you can modify library according to your need. please report me bugs and updates about this library.