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

5 votes341 views2 answers
PDOException::("could not find driver") windows
PHP
0 vote345 views1 answer
Centos 8 laravel permission denied
PHP Laravel
1 vote375 views1 answer
Create empty 2d array php
PHP
0 vote394 views1 answer
Laravel Exclude URI from csrf token verification
PHP
0 vote326 views1 answer
Ignore user id on email validation laravel
PHP
0 vote323 views3 answers
Password_verify php
PHP
1 vote461 views1 answer
Get year in laravel 8
PHP Laravel
-1 vote343 views3 answers
Absolute path php
PHP
0 vote362 views3 answers
Remove string after comma in php
PHP
0 vote336 views1 answer
Php know if city exist gmap api
PHP