How do I return an SQL query result as an array of objects in Yii?
$connection = Yii::app()->db;
$sql = " SELECT **** ";
$command = $connection->createCommand($sql);
$command->bindParam(":t", $t, PDO::PARAM_INT);
$rawData = $command->queryAll();
$dataProvider=array();
foreach ($rawData as $one) $dataProvider[]=(object)$one;
$dataProvider=new CArrayDataProvider($dataProvider , array('pagination'=>array('pageSize'=>$limit )));
$CountAudio = Yii::app()->db->createCommand('SELECT FOUND_ROWS() AS count_total')->queryScalar();
return $dataProvider;
Comments