如何使用Zend Framework 2运行原始SQL查询 [英] How to run raw SQL Query with Zend Framework 2

问题描述

在Zend Framework 2中是否可以将SQL字符串作为查询执行?

Is there a way to execute a SQL String as a query in Zend Framework 2?

我有一个像这样的字符串:

I have a string like that:

$sql = "SELECT * FROM testTable WHERE myColumn = 5"

现在我想直接执行此字符串.

now I want to execute this string directly.

推荐答案

use Zend\Db\Sql\Sql;
use Zend\Db\Adapter\Adapter;

$dbAdapterConfig = array(
    'driver'   => 'Mysqli',
    'database' => 'dbname',
    'username' => 'dbusername',
    'password' => 'dbuserpassword'
);
$dbAdapter = new Adapter($dbAdapterConfig);

$sql = new Sql($dbAdapter);
$select = $sql->select();
$select->from('testTable');
$select->where(array('myColumn' => 5));

$statement = $sql->prepareStatementForSqlObject($select);
$result = $statement->execute();

S.文档: Zend \ Db → Zend \ Db \ Sql

S. docu: Zend\Db → Zend\Db\Sql

这篇关于如何使用Zend Framework 2运行原始SQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！