Blog ›
28 Nov
2012

Call CodeIgniter MySQL query inside a helper file
This is a short snippet of php code if you want to use a CodeIgniter database query inside a helper file/function which is based in the following folder 'application/helpers/'.
<?php
// outputs the query results //
function array_output()
{
$ci=& get_instance();
$ci->load->database();
$sql = "SELECT *
FROM table";
$query = $ci->db->query($sql);
$row = $query->result();
return $row;
}
?>
Posted in: <
PHP MVC
>


me@grafxflow
I am a Full-stack Developer who also started delving into the world of UX/UI Design a few years back. I blog and tweet to hopefully share a little bit of knowledge that can help others around the web. Thanks for stopping by!
Visitors also viewed these posts
3 Thoughts
28 Sep
2013
Darren
Thank you!This worked perfectly!
28 Sep
2013
me@grafxflow
Glad to help.16 Sep
2014
Chinkush Varshney
Hey Thanks its working......