Yii Framework: CDbCriteria sample.

Hoge.php

<?php
class Hoge extends CActiveRecord
{
	...
	/**
	 * 最新のデータを$limit分取得する
	 */
	public function getRecent($limit=5)
	{
		$c = new CDbCriteria;
		$c->select = 't.fuga, t.piyo';
		$c->condition = 't.userid = :userid';
		$c->addCondition('t.is_deleted = 0');
		$c->params[':userid'] = Yii::app()->user->id;
		$c->order = 't.create_time DESC';
		$c->limit = $limit;
		
		return $this->findAll($c);
	}
	...
}