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 vote188 views3 answers
Laravel where json array column
PHP
0 vote209 views1 answer
Get post data in laravel
PHP Laravel
0 vote168 views1 answer
Indian time laravel
PHP
0 vote188 views2 answers
Obtener datos de usuario registrado en WordPress
PHP Wordpress
18 votes206 views3 answers
Laravel blade for loop
PHP
0 vote181 views1 answer
Php max value in associative array
PHP
1 vote204 views1 answer
Laravel iseed
PHP Laravel
0 vote219 views1 answer
Hardening PHP7
PHP
0 vote198 views1 answer
Mysqli_test
PHP
3 votes148 views1 answer
Laravel inrandomorder
PHP Laravel