+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: How to Call CI DB library in custom made helper function (/showthread.php?tid=10418)
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.