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

28 votes320 views5 answers
Php get current year
PHP
6 votes351 views2 answers
Nav active in laravel
PHP Laravel
7 votes331 views4 answers
Php sort by associative array value
PHP
0 vote428 views1 answer
Wordpress display post categories
PHP Wordpress
1 vote326 views2 answers
Laravel init
PHP Laravel
0 vote344 views1 answer
Fast excel export laravel
PHP Laravel
0 vote444 views4 answers
Logout php code
PHP
16 votes352 views10 answers
Php hash password
PHP
1 vote342 views2 answers
Sanitize form data php
PHP
0 vote375 views4 answers
Install latest php on feren os
PHP