SaNNyX.Info

 

Download complete source code: here

Controller:

class Flexgrid extends CI_Controller {

function __construct() {
parent::__construct();
$this->load->model('flexgrid_model');
}

function index() {
$this->template->load("template", "flexgrid");
}

function jsondata($toLoad = 'list', $page = null, $search = null) {
switch ($toLoad) {
case 'list':
echo $this->flexgrid_model->getList($page, $search);
break;
default:
echo 'No Record Found.';
}
}

}

 

Model:

class Flexgrid_model extends CI_Model {

function __construct() {
parent::__construct();
$this->load->library("flex_table");
}

function SelectbyId($id) {
$this->db->where('id', $id);
return $this->db->get('signups');
}

function getList($page = null, $search = null) {
$sql = "Select users_id,user_fname,user_mname,user_lname,designation from acl_users
Where user_fname like '%$search%' OR user_lname like '%$search%'
order by user_fname ASC";
return $this->flex_table->getJSONRecord($sql, $search, $page, 10);
}

}

 

View:

cellpadding="2" cellspacing="0" id="usersTbl" name="usersTbl">First NameMiddle NameLast NameDesignation

This entry was posted on Thursday, October 13th, 2011 at 1:55 pm and is filed under jQuery, JSON, CSS, PHP. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.