Written by me@grafxflow
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;
}
?>
Smart Search
Latest Articles
The 2027 Star Wars Pivot: How Disney Should Weaponise Nostalgia and Fix the Box Office
320 views
Install Deus Ex GOTY with Wineskin for Mac M Series
621 views
The Ultimate Preservation? Reviewing the Stereoscopic 3D Fan Edits of Star Wars
359 views
The Falcon Needs a Refurb: The 3-Step Blueprint to Save the Star Wars Universe
1,225 views
Darth Maul and Micro-Organisms: Inside George Lucas's Cancelled Star Wars Sequel Trilogy
478 views
How to Automatically Convert DVD Subtitles to SRT on Mac
447 views
Popular Articles
Markdown Syntax Cheatsheet
470,763 views
How to install GitLab CE with Vagrant on macOS
310,527 views
Disable macOS 11 (Big Sur) 'kernel_task' which is throttling the CPU
227,974 views
Shadow Catcher plugin in Cinema 4D - Part 1
178,100 views
Defective AMD GPU fix on Macbook Pro 2011
154,812 views
Adding an email template for apple mac mail.app
146,638 views
Popular Tags
me@grafxflow
Founder, 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. I build lighting-fast dynamic content engines with Laravel, Winter CMS and Tailwind CSS. Thanks for stopping by!
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......