Код: Выделить всё
$db = Yii::app()->db;
$film_table = Film::tableName();
$sql = "SELECT * FROM {$film_table}
LIMIT 1000";
$command=$db->createCommand($sql);
$rows = $command->queryAll();
$filmCollection = new FilmCollection;
foreach($rows as $row) {
$film = new Film;
$film->id = (int)$row['id'];
$film->name_ru = $row['name_ru'];
$film->name_en = $row['name_en'];
$film->year = $row['year'];
$film->director_id = (int)$row['director_id'];
$film->country = $row['country'];
$film->presents = $row['presents'];
$film->desc = $row['desc'];
$film->video_better = (int)$row['video_better'];
$film->audio_better = (int)$row['audio_better'];
$filmCollection->add($film);
}
return $filmCollection;
Код: Выделить всё
$criteria = new CDbCriteria;
$criteria->limit = 1000;
$films = films::model()->findAll($criteria);