I am looking for a way to see generated string of the query but without executing it.
Note that the query hasn't been executed before. (I do not want $this->db->last_query();)
I hope there be a method with a name like $this->db->echo_query_string($table_name = ''); to be used exactly like $this->db->get($table_name = ''); BUT THE ONLY DIFFERENCE BE THAT get() executes the code, but echo_query_string() just echoes the string of query without execution.
You can see the compiled query by either of these functions
/* SELECT */ $this->db->_compile_select();
/* INSERT */ $this->db->_insert();
/* UPDATE */ $this->db->_update();
get()? I hope it be able it to have an optional $database_name like get()
$this->db->_compile_select() is protected, and cannot be called. You need to use $this->db->get_compiled_select() (which may or not be in the latest stable version, it's in their dev version).get_compiled_insert and get_compiled_update instead._compile_select still works in 2.0.3, but that's not the most stable. The most stable version is 2.1.0 which removes _compile_select. They added get_compiled_select, but that's not in the stable version, it's only in the development version.I added this little method in DB_active_rec.php
function return_query()
{
return $this->_compile_select();
}
Usage
$this->db->select('id,user_name')->from('user')->where('id',1);
$string = $this->db->return_query();
echo $string;
Result
SELECT `id`, `user_name` FROM (`user`) WHERE `id` = 1
In this way you are bound to use
$this->db->from()
Instead of
$this->db->get()
Which runs the query
You can use some public methods to get SQL queries
$sql = $this->db->get_compiled_select();
$sql = $this->db->get_compiled_insert();
$sql = $this->db->get_compiled_update();
$sql = $this->db->get_compiled_delete();
As of version 3 of Codeigniter, please refer to this url and also to this.
echo $this->db->update_string(); OR echo $this->db->get_compiled_update();echo $this->db->insert_string(); OR $this->db->get_compiled_insert();echo $this->db->get_compiled_delete();echo $this->db->get_compiled_select();
