Skip to main content

Yii, update record (update query) method

By 
Update By Primary Key
Model::model()->updateByPk($Model->id,array("status"=>'ok'));    


Update All Rows
Model::model()->updateAll(array('user'=>"$userid",'date'=>$currenttime),"status=>'ok'");
Labels:

Popular posts from this blog

Yii, return to previous url after login or logout

By
If you want to return to your previous url after login or logout try this : <?php $this -> redirect (Yii :: app () -> request -> urlReferrer ); ?> To set the return url to be the url that was before the login page or registeration page was called you can put following code in views/layouts/main.php file : <?php //this checks id the controller action is not 'login' then it keeps the current url in returnUrl if (CController :: getAction () -> id != 'login' ) { Yii :: app () -> user -> setReturnUrl (Yii :: app () -> request -> getUrl ()); } ?>
Read more

yii, Executing a SQL without calling a Model

By
yii, Executing a SQL without calling a Model <? $connection = Yii :: app () -> db ; $sql = "SELECT id,username FROM users" ; $command = $connection -> createCommand ( $sql ); $dataReader = $command -> query (); $rows = $dataReader -> readAll (); print_r ( $rows ); ?>
Read more