blocks|key|669998|text|您可以使用以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|669999|$this->db->last_query();|code-block|syntax|javascript|670000|返回上次运行的查询(查询字符串，而不是结果)。|670001|Reff：https://www.codeigniter.com/userguide3/database/helpers.html|offset|length|670002|entityMap|0|LINK|mutability|MUTABLE|url|https://www.codeigniter.com/userguide3/database/helpers.html^0|0|0|0|5|1O|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|X|8|@]|9|@$K|Y|L|Z|1|10]]|A|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

You can use this:

<pre><code>$this-&gt;db-&gt;last_query();
</code></pre>

"Returns the last query that was run (the query string, not the result)."

Reff: <a href="https://www.codeigniter.com/userguide3/database/helpers.html" rel="noreferrer">https://www.codeigniter.com/userguide3/database/helpers.html</a>

blocks|key|887104|text|您可以显示ActiveRecord生成的SQL：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|887105|在运行查询之前：|887106|$this->db->_compile_select();+|code-block|syntax|javascript|887107|在它运行之后：|887108|$this->db->last_query();+|887109|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

You can display the ActiveRecord generated SQL:

Before the query runs:

<pre><code>$this-&gt;db-&gt;_compile_select(); 
</code></pre>

And after it has run:

<pre><code>$this-&gt;db-&gt;last_query(); 
</code></pre>

blocks|key|887396|text|如果您需要对您的查询进行快速测试，这对我非常有用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|887397|echo+$this->db->last_query();+die;|code-block|syntax|javascript|887398|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

if you need a quick test on your query, this works great for me

<pre><code>echo $this-&gt;db-&gt;last_query(); die;
</code></pre>

blocks|key|887330|text|在尝试使用_compiled_select()或get_compiled_select()但没有成功之后，我只打印了db对象，您可以在queries属性中看到该查询。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|887331|你自己试试吧：|887332|var_dump(+$this->db+);|code-block|syntax|javascript|887333|如果你知道你只有一个查询，你可以直接打印出来：|887334|echo+$this->db->queries[0];|887335|entityMap^0|5|I|O|L|1M|2|1V|7|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]|$9|V|A|W|B|C]|$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|11|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|12|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|13|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|14|8|@]|D|@]|E|$K|L]]|$1|Q|3|-4|5|6|7|15|8|@]|D|@]|E|$]]]|R|$]]

After trying without success to use <code>_compiled_select()</code> or <code>get_compiled_select()</code> I just printed the <code>db</code> object, and you can see the query there in the <code>queries</code> property.

Try it yourself:

<pre><code>var_dump( $this-&gt;db );
</code></pre>

If you know you have only one query, you can print it directly:

<pre><code>echo $this-&gt;db-&gt;queries[0];
</code></pre>

blocks|key|670064|text|有一个新的公共方法get_compiled_select，它可以在运行查询之前打印查询。_compile_select现在受到保护，因此无法使用。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|670065|echo+$this->db->get_compiled_select();+//+before+$this->db->get();|code-block|syntax|javascript|670066|entityMap^0|9|J|18|F|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|L|$]]

There is a new public method <code>get_compiled_select</code> that can print the query before running it. <code>_compile_select</code> is now protected therefore can not be used.

<pre><code>echo $this-&gt;db-&gt;get_compiled_select(); // before $this-&gt;db-&gt;get();
</code></pre>

blocks|key|670235|text|您可以简单地在末尾使用此命令。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|670236|echo+$this->db->last_query();|code-block|syntax|javascript|670237|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can simply use this at the end..

<pre><code>echo $this-&gt;db-&gt;last_query();
</code></pre>

blocks|key|887248|text|last_query()和get_compiled_select()都不适合我，所以稍微修改一下pedro的代码就可以了。不要在构建中包含->get()，这必须在->get()之前|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|887249|+echo+$this->EE->db->_compile_select();|code-block|syntax|javascript|887250|entityMap^0|0|C|D|L|1X|7|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|U|8|@]|D|@]|E|$]]]|L|$]]

Neither <code>last_query()</code> or <code>get_compiled_select()</code> works for me, so a slight change of pedro's code works for me just fine. Do not include <code>-&gt;get()</code> in your build, this must be before the ->get()

<pre><code> echo $this-&gt;EE-&gt;db-&gt;_compile_select();
</code></pre>

blocks|key|887586|text|在CodeIgniter4中，您可以执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|887587|$db+=+\Config\Database::connect();++
//+your+queries+here
$query+=+$db->getLastQuery();
$sql+=+$query->getQuery();
echo+$sql;|code-block|syntax|javascript|887588|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In CodeIgniter4, you do this:
<pre><code>$db = \Config\Database::connect(); 
// your queries here
$query = $db-&gt;getLastQuery();
$sql = $query-&gt;getQuery();
echo $sql;
</code></pre>

blocks|key|670422|text|使用get_compiled_select()检索查询，而不是替换查询|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|670423|entityMap^0|2|L|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

use <code>get_compiled_select()</code> to retrieve query instead of replace it

blocks|key|887564|text|我使用xdebug在VSCode中监视此值，扩展名和CIv2.x分别为。我在watch部分中添加了表达式$this->db->last_query()，并在launch.json中添加了xdebugSettings节点，如下所示用于获取非截断值。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|887565|{
++"name":+"Launch+currently+open+script",
++"type":+"php",
++"request":+"launch",
++"program":+"${file}",
++"cwd":+"${fileDirname}",
++"port":+9000,
++"xdebugSettings":+{
++++"max_data":+-1,
++++"max_children":+-1
++}
},|code-block|syntax|javascript|887566|然后使用断点运行我的调试器，最后只需选择我的表达式，然后单击right+>+copy+value。|887567|entityMap^0|1G|N|2L|E|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|V|8|@]|D|@]|E|$]]]|N|$]]

I'm using xdebug for watch this values in VSCode with the respective extension and CI v2.x. I add the expresion <code>$this-&gt;db-&gt;last_query()</code> in the watch section, and I add <code>xdebugSettings</code> node like these lines for get non truncate value in the launch.json.

<pre><code>{
 "name": "Launch currently open script",
 "type": "php",
 "request": "launch",
 "program": "${file}",
 "cwd": "${fileDirname}",
 "port": 9000,
 "xdebugSettings": {
 "max_data": -1,
 "max_children": -1
 }
},
</code></pre>

And run my debuger with the breakpoint and finally just select my expresion and do click right > copy value.

blocks|key|887443|text|我遇到了完全相同的问题，并最终找到了解决方案。我的查询如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|887444|$result+=+mysqli_query($link,'SELECT+*+FROM+clients+WHERE+'+.+$sql_where+.+'+AND+'+.+$sql_where2+.+'+ORDER+BY+acconame+ASC+');|code-block|syntax|javascript|887445|为了显示sql命令，我所要做的就是创建一个与查询内容完全相同的变量($resultstring)，然后像这样回显它：<?php+echo+$resultstring+=+'SELECT+*+FROM+clients+WHERE+'+.+$sql_where+.+'+AND+'+.+$sql_where2+.+'+ORDER+BY+acconame+ASC+';+?>|offset|length|style|CODE|887446|它起作用了!|887447|entityMap^0|0|0|1M|3I|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@$I|T|J|U|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

I had exactly the same problem and found the solution eventually. My query runs like:

<pre><code>$result = mysqli_query($link,'SELECT * FROM clients WHERE ' . $sql_where . ' AND ' . $sql_where2 . ' ORDER BY acconame ASC ');
</code></pre>

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:<code>&lt;?php echo $resultstring = 'SELECT * FROM clients WHERE ' . $sql_where . ' AND ' . $sql_where2 . ' ORDER BY acconame ASC '; ?&gt;</code>

It works!

I have a sql statement in my model,

I then say

<pre><code>$query = $this-&gt;db-&gt;query($sql, array(fields, fields1);

if ($query) {
 return true:
} else {
 echo "failed";
 return false;
}
</code></pre>

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

How to print SQL statement in codeigniter model

数据库

调试器

我的模型中有一条sql语句，然后我说$query = $this->db->query($sql, array(fields, fields1);if ($query) {    return true:} else {    echo "failed";    return false;}我的查询总是失败，如何让php打印发送到数据库的确切sql语句？并将其显示在我的php视图页面上

问如何在codeigniter模型中打印SQL语句
EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在codeigniter模型中打印SQL语句EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在codeigniter模型中打印SQL语句
EN