Zend框架查询TOP [英] Zend-framework Query TOP

问题描述

你好，我尝试像这样在Zend 2中生成查询

Hello i try generate a query in Zend 2 just like this

 select top 10 * from mensaje where idUsuario = 11 order by fechaAltaMensaje DESC

我尝试使用此

$select = $sql->select();
   $select->from('mensaje');
   $select->where('idUsuario = '.$idUser.' order by fechaAltaMensaje DESC');
$select->limit(5);

但不起作用

推荐答案

为了使代码正常工作，您在代码中缺少一些细节，

You are missing some details in your code in order for it to work,

请参见下文.

$adapter = $this->tableGateway->getAdapter();//use Zend\Db\TableGateway\TableGateway;
$sql = new Sql($adapter);//use Zend\Db\Sql\Sql;
$select = $sql->select();
$select->from('mensaje');
$select->where('idUsuario = '.$idUser.'');
$select->order('fechaAltaMensaje DESC');
$select->limit(5);
$selectString = $sql->getSqlStringForSqlObject($select);//print_r($selectString);die; //gives you the query in string
$results = $adapter->query($selectString, $adapter::QUERY_MODE_EXECUTE);
$resultSet = new ResultSet();//use Zend\Db\ResultSet\ResultSet;
$resultSet->initialize($results);
return $resultSet->toArray();//the result to array

请阅读以下教程，您将获得完整图片

Please read the tutorials below and you will get the full picture

示例

示例2

这篇关于Zend框架查询TOP的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！