Yii app db createcommand join yii1

$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();

Similar codes

3 votes106 views2 answers
How to redirect a particular user role to a page after login laravel
PHP
0 vote96 views1 answer
How to get many of quensation php programming language
PHP
1 vote80 views2 answers
Laravel loop counter
PHP Laravel
0 vote131 views2 answers
Laravel get path to storage folder
PHP Laravel
0 vote108 views1 answer
Larave per page int returns string
PHP
15 votes156 views4 answers
Php Error Reporting
PHP
1 vote118 views1 answer
How to retrieve value from stdclass array in php
PHP
-1 vote97 views1 answer
Php remove control characters from string
PHP
3 votes138 views1 answer
Insert rows in migrations laravel
PHP Laravel
2 votes133 views2 answers
Php split array in half
PHP