使用 Zend 框架的原始 SQL 查询

2021-12-29 00:00:00 sql php mysql 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);

相关文章