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 vote345 views3 answers
Laravel eloquent to array key value
PHP Laravel
1 vote346 views2 answers
Php parse query string
PHP
1 vote371 views2 answers
Set nav link active on the basis of route laravel 8
PHP Laravel
0 vote368 views1 answer
H1 wordpress theme php
PHP Wordpress
0 vote318 views1 answer
The `url` supplied for the path (./nova) repository does not exist
PHP
14 votes352 views6 answers
Update query in laravel eloquent
PHP
1 vote294 views1 answer
Twig symfony get route
PHP
12 votes382 views2 answers
Get current authenticated user laravel
PHP
0 vote310 views1 answer
Get header sent var
PHP
0 vote359 views1 answer
Verify laravel string must be null
PHP Laravel