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 vote189 views1 answer
Laravel how to query belongsTo relationship
PHP Laravel
88 votes175 views6 answers
Php split string
PHP
2 votes168 views3 answers
How to get the size of an uploaded file in laravel
PHP
0 vote156 views1 answer
Php foreach count rows
PHP
1 vote174 views1 answer
How to catch query exception in laravel 8
PHP
0 vote208 views1 answer
How to get value of textarea in php
PHP
8 votes174 views6 answers
Php array join
PHP
0 vote183 views1 answer
Php function to minify javascript and css
PHP
0 vote161 views1 answer
Laravel check if form has errors
PHP
1 vote163 views1 answer
Group array php by key
PHP