query_sql

//-----------------------------------------penerapan query sql untuk yang terbiasa menggunakan php native------------------------------
public function actionDelete($id){
        $SQL="DELETE FROM `kategori_kurir` WHERE `id`='".$id."' ";
        $commands=Yii::app()->db->createCommand($SQL);
        $commands->execute();
       $this->redirect(array('/paketpengiriman'));
    }
//-------------------------------------------------------------------------------------------------------------------------------------

public function actionTambah(){

        if (isset($_POST['addsubmit'])) {
            $SQL="INSERT INTO tutorial_combobox values('','".$_POST['province']."','".$_POST['kabupaten']."','".$_POST['kecamatan']."','".$_POST['kelurahan']."','".$_POST['harga']."')";
            $command= Yii::app()->db->createCommand($SQL);
            $n=$command->execute();

            $this -> redirect(array('combobox/index'));
        }else{
        $this->render('tambah');
        }
    }
//-------------------------------------------------------------------------------------------------------------------------------------

    public function actionIndex()
    {
        $sql="SELECT * FROM nama_tabel  ";
        $commands=Yii::app()->db->createCommand($sql);
        $model=$commands->queryAll();
        $this->render('index',array('model'=>$model));
    }

//------------CARA PEMANGGILANYA
foreach($model as $data):
echo $data['field];
endforeach;