How to Print SQL Statements from CodeIgniter Models?

Printing SQL Statements in CodeIgniter Models

When working with databases in CodeIgniter, it can be helpful to view the exact SQL statements being sent to the database. This can aid in debugging queries or understanding how specific data is being retrieved.

To print an SQL statement in a CodeIgniter model, use the following methods:

Method 1: Using last_query()

The last_query() method returns the last query that was run. It provides the query string, not the result.

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

You can then access the $last_query variable to print the SQL statement.

Method 2: Using get() Query Method

The get() query method returns an array of result objects. However, it also allows you to access the SQL statement that was run.

$query = $this->db->get('table_name', array(fields, fields1));
$sql_statement = $query->getQuery();

The getQuery() method returns the SQL statement as a string.

Usage in Views

To display the SQL statement in a view, you can use the php tag to access the $last_query or $sql_statement variable.

// Using $last_query
echo "SQL Statement: {$last_query}";

// Using $sql_statement
echo "SQL Statement: {$sql_statement}";

Reference:

• [CodeIgniter Database Helpers Reference](https://www.codeigniter.com/userguide3/database/helpers.html)

The above is the detailed content of How to Print SQL Statements from CodeIgniter Models?. For more information, please follow other related articles on the PHP Chinese website!