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

7 votes141 views3 answers
Ubuntu apache php version
PHP
0 vote143 views1 answer
Select max id laravel
PHP Laravel
0 vote144 views2 answers
How to use php in laravel blade
PHP
2 votes134 views2 answers
Laravel migration remove unique
PHP
0 vote153 views1 answer
Laravel validating birthdate by 13 years old
PHP
1 vote128 views1 answer
Get taxonomy name in singhle post
PHP
0 vote152 views1 answer
Get_transient wordpress
PHP Wordpress
2 votes136 views2 answers
How to use vue 3 in laravel 8
PHP
-1 vote128 views1 answer
Codeigniter get num_rows
PHP
1 vote163 views5 answers
Laravel jobs tutorial
PHP Laravel