如何在zend框架中打印确切的sql查询? [英] How to print exact sql query in zend framework ?
本文介绍了如何在zend框架中打印确切的sql查询?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有以下代码是我从模型中提取的,
I have the following piece of code which i taken from model,
...
$select = $this->_db->select()
->from($this->_name)
->where('shipping=?',$type)
->where('customer_id=?',$userid);
echo $select; exit; // which gives exact mysql query.
.....
当我在zend中使用更新查询时,
When i use update query in zend like ,
$up_value = array('billing'=> '0');
$this->update($up_value,'customer_id ='.$userid.' and address_id <> '.$data['address_Id']);
在这里我想知道确切的mysql查询.有什么可能的方法来打印zend中的mysql查询吗?友善的建议
Here i want to know the exact mysql query. Is there any possible way to print the mysql query in zend ? kindly advice
推荐答案
选择对象在Zend Framework中具有__toString()方法.
Select objects have a __toString() method in Zend Framework.
从Zend Framework手册中:
From the Zend Framework manual:
$select = $db->select()
->from('products');
$sql = $select->__toString();
echo "$sql\n";
// The output is the string:
// SELECT * FROM "products"
另一种解决方案是使用Zend_Db_Profiler. 即
An alternative solution would be to use the Zend_Db_Profiler. i.e.
$db->getProfiler()->setEnabled(true);
// your code
$this->update($up_value,'customer_id ='.$userid.' and address_id <> '.$data['address_Id']);
Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery());
Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams());
$db->getProfiler()->setEnabled(false);
http://framework.zend.com/manual/en/zend.db.select .html
这篇关于如何在zend框架中打印确切的sql查询?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文