public static function getImageById($id)
{
$criteria = new CDbCriteria();
$criteria->select = "image_path, image_title, image_ext";
$criteria->condition = "id=:id";
$criteria->params = array(':id' => (int) $id);
/*
$connection = Yii::app()->db;
$sql = "SELECT image_path, image_title, image_ext
FROM {{images}}
WHERE id = ".$id;
$command = $connection->createCommand($sql);
$rs = $command->queryRow();
*/
$rs = AImages::model()->find($criteria);
if ($rs) {
return "<img src='" . Yii::app()->params->upload_path . $rs['image_path'] . $rs['image_title'] . "_110." . $rs['image_ext'] . "'/>";
} else {
return false;
}
}
