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 vote140 views1 answer
Laravel belongsto nested
PHP
0 vote149 views1 answer
Create An Array Of Data With many Rows
PHP
-1 vote142 views1 answer
How to get php ext-gd with
PHP
3 votes135 views1 answer
Rus text check php
PHP
0 vote161 views1 answer
Dummy data in laravel
PHP
0 vote141 views1 answer
Add action hook
PHP
0 vote208 views1 answer
Ajouter du contenu personnalisé sous chaque article/publication WordPress
PHP
1 vote136 views3 answers
Wordpress admin url
PHP
0 vote139 views1 answer
Composer require guzzlehttp/guzzle
PHP
2 votes155 views1 answer
Livewire not working
PHP