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

3 votes304 views2 answers
Laravel withtrashed
PHP
1 vote366 views1 answer
Laravel return list of ids
PHP Laravel
2 votes313 views3 answers
Laravel subdays
PHP Laravel
0 vote293 views1 answer
Laravel require vendor autoload
PHP
5 votes292 views1 answer
Bootstrap blade pagination
PHP Laravel
1 vote378 views2 answers
DeleteAll cakephp 2
PHP CakePHP
3 votes331 views1 answer
Phone number validation, laravel
PHP
0 vote322 views2 answers
Mixed Content heroku laravel
PHP
0 vote318 views2 answers
Php check if value exists in multidimensional array
PHP
0 vote325 views1 answer
Codeigniter remote queries very slow
PHP