Skip to main content

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);
?>



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

Yii2 Gridview bulk action using checkbox column. How to properly create checkbox column in gridview for bulk actions

By
To add a CheckboxColumn to the  yii\grid\GridView , add it to the  columns  configuration as follows: 'columns'  => [      // ...      [          'class'  =>  'yii\grid\CheckboxColumn' ,          // you may configure additional properties here      ], ] This is the view: <?= Html :: beginForm ([ 'controller/bulk' ], 'post' );?> <?= Html :: dropDownList ( 'action' , '' ,[ '' => 'Mark selected as: ' , 'c' => 'Confirmed' , 'nc' => 'No Confirmed' ],[ 'class' => 'dropdown' ,])?> <?= Html :: submitButton ( 'Send' , [ 'class' => 'btn btn-info' ,]);?> <?= GridView :: widget ([ 'dataProvider' => $dataProvider , 'columns' => [ [ 'class' => 'yii\grid\CheckboxColumn' ], 'id' , ], ]); ?> <?= Html :: endForm...
Read more