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 vote125 views1 answer
How to style echo in php
PHP
0 vote110 views1 answer
Italic text in laravel notification
PHP
0 vote145 views1 answer
Laravel cmd add to column
PHP Laravel
8 votes124 views2 answers
Php replace space with underscore
PHP
0 vote127 views3 answers
Array fill key use in php project
PHP
7 votes104 views3 answers
Php artisan serve port
PHP
0 vote151 views1 answer
Artisan laravel require bootstrap
PHP Laravel
0 vote118 views1 answer
Wordpress disable file mods
PHP
0 vote146 views1 answer
Laravel get mysql column datatype
PHP
0 vote155 views1 answer
Form validation for file type in codeigniter
PHP CodeIgniter