How to print SQL statement in codeigniter model

Question

I have a sql statement in my model   I then say   query    this- gt db- gt 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

User · Accepted Answer

To display the query string   print r  this- gt db- gt last query           To display the query result   print r  query       The Profiler Class will display benchmark results  queries you have run  and   POST data at the bottom of your pages  To enable the profiler place the following line anywhere within your Controller methods    this- gt output- gt enable profiler TRUE     Profiling user guide  https   www codeigniter com user guide general profiling html

User · Answer

I read all answers here  but cannot get   echo  this- gt db- gt get compiled select      to work  It gave me error like       Call to protected method CI DB active record   compile select   from context  Welcome in controllers on line xx   So i removed protected from the below line from file  system database DB active rec php and it worked  protected function  compile select  select override   FALSE

User · Answer

I had exactly the same problem and found the solution eventually  My query runs like    result   mysqli query  link  SELECT   FROM clients WHERE      sql where     AND      sql where2     ORDER BY acconame ASC       In order to display the sql command  all I had to do was to create a variable   resultstring  with the exact same content as my query and then echo it  like this  lt  php echo  resultstring    SELECT   FROM clients WHERE      sql where     AND      sql where2     ORDER BY acconame ASC      gt   It works

User · Answer

There is a new public method get compiled select that can print the query before running it   compile select is now protected therefore can not be used   echo  this- gt db- gt get compiled select       before  this- gt db- gt get

User · Answer

Add this line right after the query you want to print   Example    query    this- db- query  SELECT   FROM table WHERE condition       Add this line   var dump  this- db- last query      exit      or  echo  this- db- last query

User · Answer

I m using xdebug for watch this values in VSCode with the respective extension and CI v2 x  I add the expresion  this- gt db- gt last query   in the watch section  and I add xdebugSettings node like these lines for get non truncate value in the launch json        name    Launch currently open script      type    php      request    launch      program      file       cwd      fileDirname       port   9000     xdebugSettings          max data   -1       max children   -1          And run my debuger with the breakpoint and finally just select my expresion and do click right    copy value

User · Answer

After trying without success to use  compiled select   or get compiled select   I just printed the db object  and you can see the query there in the queries property   Try it yourself   var dump   this- gt db      If you know you have only one query  you can print it directly   echo  this- gt db- gt queries 0

User · Answer

use get compiled select   to retrieve query instead of replace it

User · Answer

I try to  Chumillas s answer and  chhameed s answer  but it not work because the sql is wrong So I found new approach like this     Insert echo  sql  flush    exit  into before return  sql   compile select function of DB active rec php

User · Answer

Neither last query   or get compiled select   works for me  so a slight change of pedro s code works for me just fine  Do not include - gt get   in your build  this must be before the - get     echo  this- gt EE- gt db- gt  compile select

User · Answer

You can use this    this- gt db- gt last query       Returns the last query that was run  the query string  not the result     Reff  https   www codeigniter com userguide3 database helpers html

User · Answer

You can simply use this at the end    echo  this- gt db- gt last query

User · Answer

if you need a quick test on your query  this works great for me  echo  this- gt db- gt last query    die

User · Answer

You can display the ActiveRecord generated SQL   Before the query runs    this- gt db- gt  compile select       And after it has run    this- gt db- gt last query

[php] How to print SQL statement in codeigniter model

Examples related to php

Examples related to sql

Examples related to codeigniter