urlSuffix [.html,.php] yii

RewriteEngine on

# if a directory or a file exists, use it directly
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d

# otherwise forward it to index.php
RewriteRule . index.php

'urlManager'=>array(
    'urlFormat'=>'path',
    'rules'=>array(
        '/'=>'/view',
        '//'=>'/',
        '/'=>'/',
       ),
     'showScriptName'=>false,
     'urlSuffix'=>'.html',
  ),

show/display image in GridView

$this->widget('zii.widgets.grid.CGridView', array(
 'id'=>'sponsor-grid',
 'dataProvider'=>$model->search(),
 'filter'=>$model,
 'columns'=>array(
// -------------------------------//
array(
       'name'=>'image', // 
        'type'=>'image',
        'value'=>'Yii::app()->request->baseUrl."/uploads/sponsor/".$data->image',
  'htmlOptions'=>array('width'=>'100px','height'=>'50px'),
        ),

array(
            'name'=>'image',
            'type'=>'html',
            'value'=>'(!empty($data->image))?CHtml::image("' . Yii::app()->baseUrl . '/uploads/slider/$data->image","",array("style"=>"display: block;width:80px;height:80px; margin: 0 auto;")):CHtml::image("' . Yii::app()->baseUrl . '/images/no-image.jpg","")',

        ),


array(
   'class'=>'CButtonColumn',
  ),
 ),
));

FindAll & find In Yii

find() With Condition

     $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

 $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

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

Yii findAll()

$model=User::model()->findAll();

findAll() With Select

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

findAll() With Conditon

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

findAll() With Conditon, Group

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

findAll() With Conditon, Order

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

 $events = Events::model()->findAll(array(
    "order" => "id DESC",
));

findAll() With Conditon, Order

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

findAll() With limit

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

findAll with distinct results

StudentEnrollmentInfo::model()->findAll(array(
    'distinct'=>true,
)), 'session', 'session');

 $Criteria = new CDbCriteria();
                        $Criteria->limit = 8;
                        $Criteria->offset = 1;
                        $Criteria->order = "id DESC";
                        $emplaoyee = Employees::model()->findAll($Criteria);

findAll() "with()" function

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

findAllByPk Array value

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

Yii findAll() Join

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