grafxflow

Blog ›

28 Nov
2012

Call CodeIgniter MySQL query inside a helper file

Written by me@grafxflow - 28 Nov, 2012

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!