How To Use Update And Join Queries Using Createcommand

Yii 1.1 General Discussion
1

how to use update queries and join queries using Createcommand in yii?

plz help me :-[

2

using joins:

http://www.yiiframework.com/doc/guide/1.1/en/database.query-builder:




$user = Yii::app()->db->createCommand()

    ->select('id, username, profile')

    ->from('tbl_user u')

    ->join('tbl_profile p', 'u.id=p.user_id')

    ->where('id=:id', array(':id'=>$id))

    ->queryRow();

update queries:

http://www.yiiframework.com/doc/guide/1.1/en/database.query-builder#building-data-manipulation-queries




$command->insert('tbl_user', array(

    'name'=>'Tester',

    'email'=>'tester@example.com',

));


$command->update('tbl_user', array(

    'name'=>'Tester',

), 'id=:id', array(':id'=>1));
3

Thank you red guy :D