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 votes141 views4 answers
Laravel login by id
PHP Laravel
11 votes216 views6 answers
Curl php
PHP
1 vote188 views1 answer
Laravel uppercase first letter
PHP
-1 vote137 views1 answer
Update php ubuntu
PHP
13 votes138 views6 answers
Prefix laravel route
PHP
0 vote143 views1 answer
Check if array contains only unique values php
PHP
1 vote142 views1 answer
Visual studio php dollar sign double click
PHP
4 votes127 views3 answers
How to trim text php
PHP
0 vote206 views2 answers
Php 30days
PHP
0 vote146 views1 answer
Php sql get single value
PHP