Flexigrid CodeIgniter Implementation

[eluser]Armorfist[/eluser]
Hi again,

The active record actually simplifies a lot! Again, great idea daBayrus

Already implemented the active record, however in the COUNT query I did something different than you daBayrus.
In your approach, you get the last executed query, remove LIMIT and do a num_rows. This is fine for query's with small results, but for query's that return thousands of results executing the whole query just to count is not very good.
So here's my model:

Code:

public function get_countries()
    {
        //Select table name
        $table_name = "country";
        
        //Build contents query
        $this->db->select('id,iso,name,printable_name,iso3,numcode')->from($table_name);
        $this->CI->flexigrid->build_query();
        
        //Get contents
        $return['records'] = $this->db->get();
        
        //Build count query
        $this->db->select('count(id) as record_count')->from($table_name);
        $this->CI->flexigrid->build_query(FALSE);
        $record_count = $this->db->get();
        $row = $record_count->row();
        
        //Get Record Count
        $return['record_count'] = $row->record_count;
    
        //Return all
        return $return;
    }

And I had to add a little parameter to the build_query function so it can strip the LIMIT from the count query:

Code:

public function build_query($limit = TRUE)
    {
        if ($this->post_info['swhere'])
            $this->CI->db->where($this->post_info['swhere']);
    
        $this->CI->db->order_by($this->post_info['sortname'], $this->post_info['sortorder']);
        
        if ($limit)
            $this->CI->db->limit($this->post_info['rp'], $this->post_info['limitstart']);
    }

Tell me what you think

Going to update the documentation and then upload this modification.