Welcome Guest, Not a member yet? Register   Sign In
How to Call CI DB library in custom made helper function
#1

[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
#2

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

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

Please read user guide carefully.




Theme © iAndrew 2016 - Forum software by © MyBB