如何使用Zend Framework 2运行原始SQL查询 [英] How to run raw SQL Query with Zend Framework 2
本文介绍了如何使用Zend Framework 2运行原始SQL查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
在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屋!
查看全文