如何在 yii 中使用 findAll() 编写查询 [英] How to write the query in yii,using findAll()

问题描述

我有以下 sql 查询，如何在 yii 中使用 findAll() 编写查询?

I have the following sql query, how can I write the query in yii using findAll()?

我没有使用 CDbCriteria 并且暂时避免使用它.

I am not using CDbCriteria and for the time being avoiding it.

使用三个表 user、category 和 job_profile.

Using three tables user, category and job_profile.

SELECT * 
FROM job_profile
INNER JOIN user ON user.id = job_profile.user_id
INNER JOIN category ON category.id = job_profile.category_id
WHERE category_id = 1
  AND experience = 2
  AND key_skills LIKE  '%php%'

我编写了以下查询，但我不知道如何包含连接:

I have written the following queries but I do not know how to include join:

 $results = SearchEmployee::model()->findAll("category_id=:category AND key_skills like 
:skill AND experience=:experience", array(
            'category'=>$category,
            'skill'=>'%'.$skills.'%',
            'experience'=>$experience
            ));        

推荐答案

$model = JobProfile::model()->with('userrelationname','categoryrelationname')->findAll(array("condition"=>"t.category_id =1 and t.experience =2 and t.key_skills LIKE '%php%'"));

您可以在 JobProfile 模型中找到关系名称

You can find relations names in your JobProfile model

关系示例

您的 JobProfile 模型文件中会有源代码，例如

There will be source code in your JobProfile Model File like

 public function relations(){
    return array(
      'user' => array (self::BELONGS_TO, 'User', 'id' ),
    )
 }

这里的用户"是关系名称...

Here is 'user' is relation name...

然后在您的控制器示例中；

then in your controller example;

foreach($model as $m){
    echo $m['user_id']; // in your job_profile table
    echo $m->user->id;  // in your user table
}

这篇关于如何在 yii 中使用 findAll() 编写查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！