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

26 votes242 views6 answers
Laravel migration rollback
PHP Laravel
0 vote212 views1 answer
Php is_a
PHP
0 vote207 views1 answer
Php round all values in array
PHP
18 votes227 views6 answers
Laravel authentication
PHP
0 vote242 views1 answer
How to get all the records with same ID in laravel
PHP Laravel
46 votes201 views6 answers
Add new column in existing table in laravel migration
PHP
-2 votes175 views1 answer
Timestamp property in laravle
PHP
0 vote215 views2 answers
Return html in yajra datatables
PHP
0 vote229 views1 answer
Php how to get decimal after devide
PHP
2 votes250 views2 answers
“In fortify.php line 134:Class 'Laravel\Fortify\Features' not found ” Code Answer’s
PHP Laravel