jquery

Integrate jqgrid with codeigniter

Today we learn how to integrate jqgrid with codeigniter.

At first, write a model in your application/model directory. The code is ….

class JqgridSample extends CI_Model {
function getAllData($start,$limit,$sidx,$sord,$where){
    $this->db->select('id,name,email,passport,phone,fax,address');
    $this->db->limit($limit);
    if($where != NULL)
        $this->db->where($where,NULL,FALSE);
    $this->db->order_by($sidx,$sord);
    $query = $this->db->get('info',$limit,$start);

    return $query->result();
}

} (more…)