CodeIgniter Icon Logo
me@grafxflow

Written by me@grafxflow

28 Nov, 2012

3

7,111

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;
}
?>

Add comment

3 Response

  1. avatar

    Darren

    28 Sep 2013
    Thank you!
    This worked perfectly!
  2. avatar

    me@grafxflow

    28 Sep 2013
    Glad to help.
  3. avatar

    Chinkush Varshney

    16 Sep 2014
    Hey Thanks its working......

Smart Search

119 Following
50 Followers

me@grafxflow

Hull, United Kingdom

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!

Follow