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

1 vote218 views2 answers
Middleware with model larave 8
PHP
3 votes282 views2 answers
Get image width and height in laravel
PHP
0 vote266 views4 answers
Findmany laravel
PHP Laravel
0 vote268 views1 answer
Php dirpath multiple file extensions
PHP
0 vote244 views1 answer
He PHP exec() function must be enabled.
PHP
18 votes354 views5 answers
Create model, controller and migration in single command laravel
PHP Laravel
0 vote328 views1 answer
Wordpress wp_query orderby random
PHP Wordpress
0 vote268 views1 answer
Iterate over assets container statamic
PHP
5 votes278 views3 answers
Get result count codeigniter
PHP
0 vote310 views1 answer
Laravel change error page to open in vscode
PHP Laravel