php - 如何在cakephp2中运行普通的sql查询并获取结果

Question

我是 cakephp2 的新手，我想问一下如何运行正常的 sql 查询并获取结果最后将结果设置为变量？当我运行下面的脚本时，我无法获取结果并将其设置为变量。

$results = $this->PvCount->query("SELECT
    dt,
    SUM(total_pv) AS Total
FROM
    pv_counts
WHERE
    curdate()
GROUP BY
    dt");

Answer 1

这是一种正确的写法:

 $results = $this->PvCount->find
('all',array(
'fields'=>array('PvCount.dt','SUM(PvCount.total_pv) as Total'),
'conditions'=>array('PvCount.date '=>' curdate() '),
'group'=>array('PvCount.dt')
));

从 .ctp 获取数据:

foreach ($results as $result):
   echo  $result['PvCount']['dt'];
   echo  $result[0]['Total'];
endforeach;

希望有帮助...