How to run SQL statement in Yii ?

[WarDoGG (Yashd)]

I would NOT like to use activerecord but run my own SQL statements using Yii, How do i do that ?

Also, what are the functions for iterating through a result set once i execute a query ?

[jacmoe (Jacob Moena)]

Read the guide. -> http://www.yiiframework.com/doc/guide/

[shailesh (Shailesh Makwana990)]

Set Following Controller where You can perform

or

May be used in View OR Model as per Your requirement

<?php

$SQL="SQL Statemet"


$connection=Yii::app()->db; 


command=$connection->createCommand($sql);


$rowCount=$command->execute();   // execute the non-query SQL


$dataReader=$command->query();   // execute a query SQL

?>

[DavidTran (Nam Trankhanh Vn)]

Example of a query which return an array

$list= Yii::app()->db->createCommand('select * from post')->queryAll();


$rs=array();

foreach($list as $item){

    //process each item here

    $rs[]=$item['id'];


}

return $rs;

if you want to bind some params:

$list= Yii::app()->db->createCommand('select * from post where category=:category')->bindValue('category',$category)->queryAll();

if you just want to run a query return nothing return:

Yii::app()->db->createCommand('delete * from post')->query();

Hope this help

Best regard

[eelchinn (Abilovelchin)]

@David T, Thank you very much

[morning123 (Saharhalim151)]

Example of a query which return an array

$list= Yii::app()->db->createCommand('select * from post')->queryAll();


$rs=array();

foreach($list as $item){

    //process each item here

    $rs[]=$item['id'];


}

return $rs;

if you want to bind some params:

$list= Yii::app()->db->createCommand('select * from post where category=:category')->bindValue('category',$category)->queryAll();

if you just want to run a query return nothing return:

Yii::app()->db->createCommand('delete * from post')->query();

Hope this help

Best regard

Thank you, your answer worked for me.