在symfony中执行自定义SQL [英] Execute custom SQL in symfony

问题描述

我正在尝试执行一些自定义SQL以在Symfony应用程序中检索一些模型对象。我在网页上发现一个教程，说这样的话可以让我执行查询，虽然没有填充模型（填充模型不是一个主要问题，只是为了只读数据）。

I'm trying to execute some custom SQL to retrieve some model objects in a Symfony application. I found a tutorial on the web that said something like this would allow me to execute the query although not populate the models (populating the model isn't a major issue, it's just for read only data).

$pdo = Doctrine_Manager::getInstance()->connection()->getDbh();
$pdo->prepare("SELECT * from something complicated");
$pdo->execute();
$this->sensorReadings = $pdo->fetchAll();

但是我收到错误：

Fatal error: Call to undefined method PDO::execute()
in sfproject/apps/frontend/modules/site/actions/actions.class.php 

推荐答案

$query = "SELECT * from something complicated";
$rs = Doctrine_Manager::getInstance()->getCurrentConnection()->fetchAssoc($query);

结果集是一个数组。

这篇关于在symfony中执行自定义SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！