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

0 vote397 views1 answer
Wordpress get page number
PHP Wordpress
0 vote350 views1 answer
Laravel: Validation unique on update
PHP Laravel
0 vote360 views1 answer
Wp main menu
PHP Wordpress
3 votes304 views5 answers
Php artisan jwt secret
PHP
3 votes307 views2 answers
Remove admin bar wordpress front end
PHP
0 vote311 views1 answer
Php csv to multirow array $_FILES
PHP
1 vote336 views1 answer
Laravel model created_at format edit
PHP Laravel
0 vote302 views1 answer
Php remove anchor tag from string
PHP
0 vote278 views5 answers
Run schedule laravel
PHP
2 votes387 views2 answers
Laravel many to many update all pivot
PHP Laravel