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 vote189 views5 answers
Check if value change laravel
PHP Laravel
1 vote210 views1 answer
Get year in laravel 8
PHP Laravel
0 vote177 views1 answer
Laravel make trait command
PHP Laravel
2 votes159 views2 answers
Prevent form submit on page refresh php\
PHP
1 vote271 views2 answers
Laravel check if email is verified
PHP
0 vote158 views1 answer
Wordpress echo the page title
PHP
0 vote160 views2 answers
How to use a session in blade
PHP
12 votes182 views2 answers
Php code to check if variable is null
PHP
0 vote179 views1 answer
@method overide form laravel
PHP Laravel
4 votes176 views3 answers
Laravel eloquent remove from db
PHP Laravel