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 vote190 views1 answer
In php einen div
PHP
9 votes177 views3 answers
Object values to array php
PHP
-1 vote170 views2 answers
Apache 2
PHP
0 vote177 views1 answer
Find template serving current page
PHP
8 votes172 views4 answers
Session unset
PHP
0 vote169 views1 answer
Laravel imap - Set message flags
PHP
5 votes217 views3 answers
Laravel created_at where date format
PHP
4 votes184 views2 answers
Define home url wp
PHP
0 vote173 views1 answer
Retrieve data from database xampp
PHP
1 vote203 views1 answer
How to override default name for apiresourc route in laravel
PHP Laravel