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 vote173 views1 answer
Test laravel scheduler
PHP
0 vote285 views1 answer
Get the user detail inside the constructor Laravel
PHP
0 vote195 views1 answer
Wordpress disable posts
PHP
30 votes179 views6 answers
Php loop array
PHP
1 vote158 views3 answers
Get field object acf
PHP
1 vote208 views1 answer
The token has been blacklisted laravel jwt
PHP
33 votes160 views5 answers
Php case switch
PHP
2 votes185 views6 answers
Get last id in laravel
PHP
8 votes155 views2 answers
Laravel Edit
PHP
4 votes149 views1 answer
Laravel mail send flexible subject
PHP