+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Display SQL Query generated (/showthread.php?tid=53574)
Display SQL Query generated - El Forum - 07-30-2012
[eluser]Alex Jurado[/eluser]
How I can see the query that is generated from ...
Code:
$ci->db->select('id,name,token',FALSE)->from('users')->where(array('id'=>1,'status'=>true));I need to create a function to get the SQL query, I mean
Code:
SELECT id,name,token FROM users WHERE id = 1 AND status = TRUE;Display SQL Query generated - El Forum - 07-30-2012
[eluser]thisischris[/eluser]
Use $this->db->_compile_select().
Display SQL Query generated - El Forum - 07-30-2012
[eluser]Alex Jurado[/eluser]
Thanks, but get this error when running,
Code:
Fatal error: Call to protected method CI_DB_active_record::_compile_select() from context 'CI_Loader' ...But when I run this, if it works,
Code:
print "SQL Query: ".$this->db->last_query();Thanks for your help
Display SQL Query generated - El Forum - 07-30-2012
[eluser]thisischris[/eluser]
Is this within a library?
I just noticed your using $ci, in which case I would use $ci->db->_compile_select();
Display SQL Query generated - El Forum - 07-30-2012
[eluser]Alex Jurado[/eluser]
Do not think that's the problem, because I use $this
Display SQL Query generated - El Forum - 07-30-2012
[eluser]tpetrone[/eluser]
perhaps this?
Code:
echo $CI->db->last_query();Display SQL Query generated - El Forum - 07-30-2012
[eluser]Alex Jurado[/eluser]
Yes,
[quote author="Alex Jurado" date="1343658610"]..., if it works,
Code:
print "SQL Query: ".$this->db->last_query();Thanks for your help[/quote]
Display SQL Query generated - El Forum - 07-30-2012
[eluser]CroNiX[/eluser]
Shouldn't "true" be quoted in your where()? It's a string.