posted by aqshakirzhan on March 13, 2015

$thumb = self::model()->find('img_parent=:img_parent', array(':img_parent'=>(int)$this->img_id));

// возвращает объект текущего класса AR


        $command = Yii::app()->db->createCommand("
SELECT *
FROM " . self::$tableName . "
WHERE LOWER(img_title) LIKE '%" . addslashes($str) . "%'
OR LOWER(img_filename) LIKE '%" . addslashes($str) . "%'
ORDER BY $order
LIMIT $limit
");

$result = $command->queryAll();

// получаем массив данных

Leave a Comment

Fields with * are required.