FindAll In Yii

Yii Framework. I list out all types of find, findall conditions in yii framework. It will very helpful for us.

Yii find()

find()

<?php
     $model = User::model()->find();

find() With Condition

<?php
     $model = User::model()->find('userid=1 AND status="A"');
(OR)
     $model = User::model()->find('userid=:userId And status=:Status',
                                   array(':userId'=>1,':status'=>'A'));

find() Width Criteria

<?php
     $criteria = new CDbCriteria;
     $criteria->condition='userid=1 AND status="A"'; 
     $model = User::model()->find($criteria);
(OR)
     $criteria=new CDbCriteria;     
     $criteria->condition='userid=:userId AND status=:Status';
     $criteria->params=array(':userId'=>10,':Status'=>'A');
     $model=User::model()->find($criteria);

find() Max Id

<?php
     $criteria=new CDbCriteria;
     $criteria->select='max(userid) as id';
     $model = User->model()->find($criteria);

Yii findAll()

findAll()

<?php
     $model=User::model()->findAll();

findAll() With Select

<?php
     $model=User::model()->findAll(array(
                                'select'=>'userid, username'
                             ));     

findAll() With Conditon

<?php
     $model=User::model()->findAll(
                              array(
                              'select'=>'userid, username',
                              'condition'=>'status="A"'
                             ));     

findAll() With Conditon, Group

<?php
     $model=User::model()->findAll(
                              array(
                              'condition'=>'status="A"',
                              'group'=>'type'
                             ));  

findAll() With Conditon, Order

<?php
     $model=User::model()->findAll(
                              array(
                              'select'=>'userid,username',
                              'condition'=>'status="A"',
                              'order'=>'username'
                             ));  

findAll() With limit

<?php
     $model=User::model()->findAll(
                              array(
                              'condition'=>'status="A"',
                              'limit'=>'5'
                             ));  

findAll() “with()” function

<?php
      $model=User::model()->with('login')->findAll(
                              array(
                               'select'=>'t.userid,t.username,login.time',
                               'condition'=>'login.satus="L"'
                              ));

findAllByPk Array value

<php
$usermodel=User::model()->findAllByPk($useridarray);
$usermodel=User::model()->findAllByPk(array(2,3,10));
?>

Yii findAll() Join

findAll inner join

<php
        $categorymodel=Category::model()->with(array(
            'user'=>array(
            'select'=>'categoryname',
            'joinType'=>'INNER JOIN',
            'condition'=>'user.categoryname="activeuser"',
        ),
        ))->findAll();
?>            

Yii Sql command

Yii findAll() by Sql command

    
    public function findallbysql(){
        $categorylist=Yii::app()->db->createCommand("SELECT category.categoryid as categoryid,category.categoryname as categoryname FROM `documentindex` `t`  LEFT OUTER JOIN `tbl_category` `category`
ON (`t`.`categoryid`=`category`.`categoryid`)  WHERE category.isactive=1 group by t.categoryid")->queryAll();
        $category_array["all"]="All";
        foreach($categorylist as $data){
            $category_array[$data['categoryid']]=$data['categoryname'];
        }
        return $category_array;
    }

Leave a Reply

Your email address will not be published. Required fields are marked *