如何在 yii 中运行 mysql 查询

2022-01-04 00:00:00 sql php mysql yii

我想通过 mysql 查询从表中获取列中的最高 5 个值，所以查询是:

I want to make mysql query to get the highest 5 values in a column from a table, so the query is : 

'SELECT * FROM files ORDER BY  `uploadDate` DESC LIMIT 5'

如何运行此查询并将其值保存在变量中?

how to run this query and save its value in a variable?

如果可能的话，我更喜欢使用 findAll() 方法和这些选项.

I prefer to use findAll() method with these options if it is possible.

推荐答案

有几种方法可以实现这一点，但如果您更喜欢查询构建器的方式

There are several ways to achieve this, but if you prefer the query builder way 

$results = Yii::app()->db->createCommand()->
          select('id, filename, uploadDate')->
          from('files')->
          order('uploadDate DESC')->
          limit(5)->
          queryAll();

var_dump($results);

阅读本文档了解更多详情:http://www.yiiframework.com/doc/guide/1.1/en/database.query-builder

Read this documentation for more detail : http://www.yiiframework.com/doc/guide/1.1/en/database.query-builder

相关文章