javascript python java c# php android html jquery c++ css ios mysql sql r node.js arrays reactjs c asp.net json ruby-on-rails .net sql-server swift python-3.x objective-c django angular angularjs excel regex pandas ruby iphone ajax linux xml vba asp.net-mvc spring laravel database wordpress typescript string wpf mongodb windows xcode postgresql bash oracle git vb.net amazon-web-services multithreading list firebase flutter eclipse spring-boot dataframe azure react-native algorithm docker macos forms image visual-studio scala powershell function twitter-bootstrap numpy api performance selenium winforms python-2.7 matlab vue.js sqlite apache hibernate entity-framework loops rest shell facebook express android-studio csv linq maven qt swing unit-testing file tensorflow

[ACCEPTED]-Getting raw SQL Queries in CodeIgniter 1.7-codeigniter

Accepted answer
Score: 45

Before the query runs:

$this->db->_compile_select();

And after it has run:

$this->db->last_query();

0

Score: 10

Of course, I found it 2 minutes after posting, courtesy 1 of Phil Sturgeon.

echo $this->db->last_query();
Score: 8

Also, you can put the following in your 2 controller:

$this->output->enable_profiler(TRUE);

You'll get queries and a lot 1 more.

Score: 1

For anyone finding this old post and wondering 2 what this is in the latest v3 the function 1 is $this->db->get_compiled_select().

Source: stackoverflow.com

More Related questions

Set up Apache for local development/testing?

Creating an object from a class in Codeigniter

Create Simple Codeigniter library

PHP equivalent to python's triple-quotes - How to print bulk / lots of HTML within PHP without escaping

I want codeigniter to echo php errors instead of 500 internal error

How to do "while fetch assoc" in CodeIgniter?

Is it possible to override default error handler of CodeIgniter framework to output it as json?

Codeigniter Redirect -- The URI you submitted has disallowed characters

Vertical Text in PHPExcel Cell

CodeIgniter HMVC object_to_array() error