Zend框架的RAW SQL查询 [英] RAW SQL Query with Zend Framework
问题描述
在Zend Framework中是否可以将SQL字符串作为查询执行?
Is there a way to execute a SQL String as a query in Zend Framework?
我有一个像这样的字符串:
I have a string like that:
$sql = "SELECT * FROM testTable WHERE myColumn = 5"
现在,我想直接执行此字符串,然后对其进行解析并手动"从中创建一个Zend_Db_Table_Select
对象.或者,如果可能的话,请从该字符串中创建一个Zend_Db_Table_Select
对象,以执行该对象.
now I want to execute this string directly withput parsing it and creating a Zend_Db_Table_Select
object from it "by hand". Or if thats possible create a Zend_Db_Table_Select
object from this string, to execute that object.
我该怎么做?我在Zend文档中找不到解决方案.
How can I do that? I didn't find a solution for this in the Zend doc.
推荐答案
如果一开始就创建Zend_DB对象,则可以使用该对象创建查询.请查看手册中的以下条目: https://framework.zend.com/manual/1.12/en/zend.db.statement.html
If you're creating a Zend_DB object at the start you can create a query using that. Have a look at this entry in the manual : https://framework.zend.com/manual/1.12/en/zend.db.statement.html
$stmt = $db->query(
'SELECT * FROM bugs WHERE reported_by = ? AND bug_status = ?',
array('goofy', 'FIXED')
);
或
$sql = 'SELECT * FROM bugs WHERE reported_by = ? AND bug_status = ?';
$stmt = new Zend_Db_Statement_Mysqli($db, $sql);
这篇关于Zend框架的RAW SQL查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!