Yii2: check exist ActiveRecord model in database

Question

How to check existence of model in DB? In Yii 1 version it was so User::model()->exist()

Answer 1

In Yii2 you can add exists() to your query chain:

User::find()     ->where( [ 'id' => 1 ] )     ->exists();  

(The generated SQL looks like this: SELECT 1 FROM `tbl_user` WHERE `id`=1.)

Here is Query->exists()from Yii2 source:

/**  * Returns a value indicating whether the query result contains any row of data.  * @param Connection $db the database connection used to generate the SQL statement.  * If this parameter is not given, the `db` application component will be used.  * @return bool whether the query result contains any row of data.  */ public function exists($db = null) {     if ($this->emulateExecution) {         return false;     }     $command = $this->createCommand($db);     $params = $command->params;     $command->setSql($command->db->getQueryBuilder()->selectExists($command->getSql()));     $command->bindValues($params);     return (bool) $command->queryScalar(); } 

Answer 2

if(Mastersettings::find()->where(['id'=>1,'status'=>1])->exists()) {                       //....... Your code Here ...... }  

http://yii2ideas.blogspot.in/2017/06/yii2-database-operations.html