CodeIgniter Forums

Full Version: How to Call CI DB library in custom made helper function
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

[eluser]Blue Sapphire[/eluser]
I have following code of custom made helper function:

function mCountry(){
    $query = $this->db->query('select * from fa_country');
    if($query->num_rows() >0)
        $nbrows = $query->num_rows();
        foreach($query->result() as $res){
            $rec['id']      = $res->id;
            $rec['iso']     = $res->iso;
            $rec['name']    = $res->name;
            $rec['iso3']    = $res->iso3;
            $rec['numcode'] = $res->numcode;
            $arr[] = $rec;            
        $jsonresult = JEncode($arr);
        echo '({"total":"'.$nbrows.'","results":'.$jsonresult.'})';    
        //echo '({"total":"'.$nbrows.'","results":'.$jsonresult.'})';

In above mentioned code, how can I call, DB laibrary of CI. Because with current syntax, it is giving me error of "Call to a member function on a non-object............." .

Can anyone guide me in this regards.

Thanks in advance

El Forum

[eluser]Blue Sapphire[/eluser]
Still waiting for some solution

El Forum

Please use Model for database not helpers ..I already ask you.

Please read user guide carefully.