Reading Record

To read data in a database table, we call one of the find methods as follows.

// find the first row satisfying the specified condition
$post=Post::model()->find($condition,$params);
// find the row with the specified primary key
$post=Post::model()->findByPk($postID,$condition,$params);
// find the row with the specified attribute values
$post=Post::model()->findByAttributes($attributes,$condition,$params);
// find the first row using the specified SQL statement
$post=Post::model()->findBySql($sql,$params);



hen multiple rows of data matching the specified query condition, we can bring them in all together using the following findAll methods, each of which has its counterpart find method, as we already described.

// find all rows satisfying the specified condition

$posts=Post::model()->findAll($condition,$params);

// find all rows with the specified primary keys

$posts=Post::model()->findAllByPk($postIDs,$condition,$params);

// find all rows with the specified attribute values

$posts=Post::model()->findAllByAttributes($attributes,$condition,$params);

// find all rows using the specified SQL statement

$posts=Post::model()->findAllBySql($sql,$params);

More.....