CodeIgniter Forums
How to Call CI DB library in custom made helper function - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forum-23.html)
+--- Thread: How to Call CI DB library in custom made helper function (/thread-10418.html)



How to Call CI DB library in custom made helper function - El Forum - 07-30-2008

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

Code:
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


How to Call CI DB library in custom made helper function - El Forum - 07-31-2008

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


How to Call CI DB library in custom made helper function - El Forum - 07-31-2008

[eluser]Yash[/eluser]
Please use Model for database not helpers ..I already ask you.

Please read user guide carefully.