jQuery Grid Plugin - jqGrid

tony said:

Hello,

The true test is to test your server side code. - Also see what parameters are passed to the detail and try to simulate these in the SQL console - you will see the result.

Best Regards

Tony

here's my code where it save the details about the company...

function getDetailList() //Show the list of registered user with company details
    {
        $item = $this->input->post("item"); #<-- this line don't post the value of the $item that's why there's no details showing in the detail grid even when you select a row from the master grid

        $page = $this->input->post('page');
        $limit = $this->input->post('rows');
        $sidx = $this->input->post('sidx');
        $sord = $this->input->post('sord');
        
        $query = $this->input->post('query');
        $qtype = $this->input->post('qtype');
        
        if (!$sidx) $sidx = 'sec_companyaccess.user_id';
        if (!$sord) $sord = 'desc';
                
        if (!$page) $page = 1;
        if (!$limit) $limit = 25;
        
        $start = (($page-1) * $limit);
    
        $this->db->start_cache();

        $this->db->join('maint_company','sec_companyaccess.company_id=maint_company.company_id','left');
        $this->db->join('sec_users ','sec_companyaccess.user_id=sec_users.user_id','left');
        $this->db->from('sec_companyaccess');
        $this->db->where("sec_companyaccess.user_id", $item);
         $count = $this->db->count_all_results();

        if( $count > 0 && $limit > 0) {
              $total_pages = ceil($count/$limit);
        } else {
              $total_pages = 0;
        }

        if ($page > $total_pages) $page=$total_pages;
        
        $start = $limit * $page - $limit; // do not put $limit*($page - 1)
        
        if($start <0) $start = 0;
        
        $this->db->select("sec_companyaccess.company_access_id as pkey,sec_companyaccess.company_access_id, maint_company.company_code, maint_company.company_name,sec_companyaccess.company_id ");
        $this->db->order_by($sidx,$sord);
        $this->db->limit($limit, $start);
        $query = $this->db->get("sec_companyaccess");

        $this->db->flush_cache();
        
        $data['db'] = $query;
        $data['page'] = $page;
        $data['totalpages'] = $total_pages;
        $data['totalrecords']=$count;
        return $data;    
    
    }

note:

$this->db->where("sec_companyaccess.user_id", $item); // but when i change the value of $item here to values 1 or 2 the detail grid is showing the company detail

hope you can help me...

hi tony,

i have already solved this problem.. thanks for th replies..

regards,

kahtrina