CodeIgniter Icon Logo
me@grafxflow

Written by me@grafxflow

28 Nov, 2012

3

7,471

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

    Darren
    28 Sep 2013

    Thank you!
    This worked perfectly!

    |

    me@grafxflow
    28 Sep 2013

    Glad to help.

    |

    Chinkush Varshney
    16 Sep 2014

    Hey Thanks its working......

Smart Search

133 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