blocks|key|129929|text|您可以尝试：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|129930|public+static+function+findByUsername($username)
{
+$criteria+=+new+CDbCriteria;++
+$criteria->addCondition("username+!=+'username'");
+$criteria->addCondition("role+!=+'user'");
+$result+=+User::model()->find($criteria);
+return+$result;
}|code-block|syntax|javascript|129931|或者：|129932|public+static+function+findByUsername($username)
{
++$result=Users::model()->findByAttributes(array('condition'=>"role+!=+'user',username+=+'$username'"));
}|129933|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

You can try:

<pre><code>public static function findByUsername($username)
{
 $criteria = new CDbCriteria; 
 $criteria-&gt;addCondition("username != 'username'");
 $criteria-&gt;addCondition("role != 'user'");
 $result = User::model()-&gt;find($criteria);
 return $result;
}
</code></pre>

Or:

<pre><code>public static function findByUsername($username)
{
 $result=Users::model()-&gt;findByAttributes(array('condition'=&gt;"role != 'user',username = '$username'"));
}
</code></pre>

blocks|key|4636235|text|好的，我已经这样做了：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4636236|public+static+function+findByUsername($username)
{
++++$sql="select+*+from+tbl_user+where+username=:uname+and+status=:st+and+role+!=+'user'";
++++return+static::findBySql($sql,[":uname"=>$username,":st"=>static::STATUS_ACTIVE])->one();
}|code-block|syntax|javascript|4636237|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Ok, i've done by this way:

<pre><code>public static function findByUsername($username)
{
 $sql="select * from tbl_user where username=:uname and status=:st and role != 'user'";
 return static::findBySql($sql,[":uname"=&gt;$username,":st"=&gt;static::STATUS_ACTIVE])-&gt;one();
}
</code></pre>

blocks|key|129987|text|我想提供另一种解决方案，它对我来说更优雅。从Yii+1开始，当我需要检查不相等操作时，我通常使用这种方法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|129988|$models+=+Book::find()->where('id+!=+:id+and+type+!=+:type',+['id'=>1,+'type'=>1])->all();|code-block|syntax|javascript|129989|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I want to offer another solution, it's more elegant for me. I usually use this approach since Yii 1 when i need check not equal operation.

<pre><code>$models = Book::find()-&gt;where('id != :id and type != :type', ['id'=&gt;1, 'type'=&gt;1])-&gt;all();
</code></pre>

blocks|key|4636343|text|你可以试试这个。这只是一个例子|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4636344|+$existEmail+=+Users::model()->findByAttributes(
++++++++array('email'=>$this->email),
++++++++array(
++++++++++++'condition'=>'user_id!=:id',
++++++++'params'=>array('id'=>$this->user_id),
++++++++));|code-block|syntax|javascript|4636345|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

you can try this one . just an example

<pre><code> $existEmail = Users::model()-&gt;findByAttributes(
 array('email'=&gt;$this-&gt;email),
 array(
 'condition'=&gt;'user_id!=:id',
 'params'=&gt;array('id'=&gt;$this-&gt;user_id),
 ));
</code></pre>

blocks|key|4636393|text|您可以像这样传递自定义where子句：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4636394|andWhere(['!=',+'field',+'value'])|code-block|syntax|javascript|4636395|您的最终函数将如下所示：|4636396|public+static+function+findByUsername($username)
{
++++return+static::find()
++++++++->where([
++++++++++++'username'+=>+$username,
++++++++++++'status'+=>+static::STATUS_ACTIVE
++++++++])
++++++++->andWhere(['!=',+'role',+'user'])
++++++++->all();
}|4636397|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

You can pass custom where clause like this:

<pre><code>andWhere(['!=', 'field', 'value'])
</code></pre>

Your final function will look like:

<pre><code>public static function findByUsername($username)
{
 return static::find()
 -&gt;where([
 'username' =&gt; $username,
 'status' =&gt; static::STATUS_ACTIVE
 ])
 -&gt;andWhere(['!=', 'role', 'user'])
 -&gt;all();
}
</code></pre>

I have this code to find a user from db which status is active and role is user

<pre><code>public static function findByUsername($username)
{
 return static::find(['username' =&gt; $username, 'status' =&gt; static::STATUS_ACTIVE, 'role'=&gt;'user']);
}
</code></pre>

I need to find a user that role is not equal to "user". How can I do this?

P.S: I'm using YII2

yii2 active record find column not equal

我使用此代码从db中查找状态为活动、角色为用户的用户。public static function findByUsername($username){ return static::find(['username' => $username, 'status' => static::STATUS_ACTIVE, 'r...

问yii2活动记录查找列不相等
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问yii2活动记录查找列不相等EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问yii2活动记录查找列不相等
EN