yii Get The First Image From a Post

    public function catch_that_image($str){

        $output = preg_match_all('/]+src=[\'"]([^\'"]+)[\'"][^>]*>/i', $str, $matches);
        return $matches[1][0];

    }

$recentnew->catch_that_image($recentnew->details);

Yii count()

 echo Video::model()->count(); 

by using params:
Video::model()->count('video_type <> :type', array('type' => $video_type); 

using commandBuilder:

Yii::app()->db->createCommand()
            ->select('COUNT(*)')
            ->from('video')
            ->where('video_type <> '.$video_type)
            ->queryScalar();

yii Criteria date_format between

$lastmonth= date('Y-m-d', strtotime('today - 30 days'));
                    $today= date('Y-m-d');
                   $criteria = new CDbCriteria;   
            
                    $criteria->addCondition(
   "DATE_FORMAT(create_date, '%Y-%m-%d') >='$lastmonth' 
   and 
   DATE_FORMAT(create_date, '%Y-%m-%d') <= '$today'"
  );
   $criteria->limit = 10;
   $criteria->order = 'total_view DESC';
   //$criteria->group = 'id';
 
    $modelvideo= Video::model()->findAll($criteria);

Register function through clientScript->registerScript

Yii::app()->clientScript->registerScript('rightclick', "
    $('body').bind('contextmenu', function(e){
   return false;
    });
");

yii CStarRating displays and rating

  
$this->widget('CStarRating',array(
    'name'=>'video_rating',
   // 'minRating'=>1,
  //  'maxRating'=>10,
    'starCount'=>10,
    'allowEmpty' => FALSE,
    'value'=>$model->videorating($model->id),
    'callback'=>'
        function(){
                $.ajax({
                    type: "POST",
                    url: "'.Yii::app()->createUrl('video/rating', array('id'=>$model->id)).'",
                    data: "star_rating=" + $(this).val(),
                    success: function(data){
                                $("#mystar_voting").html(data);
                        }})}'
  ));

Yii homeUrl and baseUrl

Yii::app()->getBaseUrl(true);   // => http://localhost/yii_projects
Yii::app()->getHomeUrl();       // => /yii_projects/index.php
Yii::app()->getBaseUrl(false);  // => /yii_projects

Using counters with ActiveRecord

public function actionDetails($id)
 {
             $video = Video::model()->findByPk($id);
             $video->total_view += 1;
             $video->save();
    
  $this->render('details',array(
   'model'=>$this->loadModel($id),
  ));
 }

public function actionDetails($id)
 {
         
              $video = Video::model()->findByPk($id);
              $video->saveCounters(array('total_view'=>1));
    
  $this->render('details',array(
   'model'=>$this->loadModel($id),
  ));
 }

public function actionDetails($id) {
    Video::model()->updateCounters(
        array('total_view'=>1),
        array('condition' => "id = :id"),
        array(':id' => $id),
    );
    $this->render('details', array('video' => $video));
}