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

13 votes322 views6 answers
Object php
PHP
0 vote330 views1 answer
Extension gd missing laravel composer update
PHP
2 votes307 views7 answers
How to convert date to string in php
PHP
0 vote357 views1 answer
Wordpress change post format
PHP
0 vote401 views1 answer
Wordpress if is not page template
PHP Wordpress
15 votes328 views6 answers
Php date from format
PHP
0 vote344 views1 answer
Csv file import to mysqli using php
PHP
0 vote311 views2 answers
Php multiplei str
PHP
2 votes350 views1 answer
Php sleep half a second
PHP
52 votes335 views6 answers
Php now
PHP