How to print SQL statement in codeigniter model

Question

I have a SQL statement in my model,

I then say

$query = $this->db->query($sql, array(fields, fields1);

if ($query) {

    return true:

} else {

    echo "failed";

    return false;

}

My query always fails, how do I get PHP to print the exact SQL statement being sent to my database? And display that on my PHP view, page

Answer 1

Use the below query to display the query string:

print_r($this->db->last_query());    

To display the query result follow this:

print_r($query);

The Profiler Class can display benchmark results, queries you have run, and $_POST data at the bottom of your pages. 

To enable the profiler place the below line anywhere within your Controller methods like this:

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

Profiling user guide: https://www.codeigniter.com/user_guide/general/profiling.html

You can learn in-depth about SQL statements, queries and become proficient in SQL queries by enrolling in our industry-recognized SQL online course.