yii CActiveRecord 查询

最新推荐文章于 2020-07-15 16:31:58 发布

yuhui_fish

最新推荐文章于 2020-07-15 16:31:58 发布

阅读量8.9k

点赞数

分类专栏： YII

YII 专栏收录该内容

15 篇文章

订阅专栏

本文介绍了在Yii框架中使用ActiveRecord进行数据查询的各种方法，包括find、findByAttributes及findBySql等，并展示了如何通过条件参数和CDbCriteria来精确检索数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

find（）

// find the first row satisfying the specified condition
$post=Post::model()->find($condition,$params);
// find the row with postID=10
$post=Post::model()->find('postID=:postID', array(':postID'=>10));

配合CDbCriteria

$criteria=new CDbCriteria;
$criteria->select='title';  // only select the 'title' column
$criteria->condition='postID=:postID';
$criteria->params=array(':postID'=>10);
$post=Post::model()->find($criteria); // $params is not needed

$post=Post::model()->find(array(
    'select'=>'title',
    'condition'=>'postID=:postID',
    'params'=>array(':postID'=>10),
));
// find the row with the specified primary key
$post=Post::model()->findByPk($postID,$condition,$params);

findByAttributes()

$post=Post::model()->findByAttributes($attributes,$condition,$params);

$checkuser = user_field_data::model()->findByAttributes(
    array('user_id' => Yii::app()->user->user_id, 'field_id' => $fieldid));

$user_field_data = user_field_data::model()->findAllByAttributes(
    $attributes = array('user_id' => ':user_id'),
    $condition = "field_id in (:fields)",
    $params = array(':user_id' => Yii::app()->user->user_id, ':fields' => "$rule->dep_fields"));

findBySql($sql,$params)

// find the first row using the specified SQL statement
$post=Post::model()->findBySql($sql,$params);
//例子
user_field_data::model()->findBySql(“select id from user_field_data where user_id = :user_id and field_id = :field_id “, array(‘:user_id’ => $userid,’:field_id’=>$fieldid));
//此时回传的是一个对象