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 vote229 views1 answer
Make model controller in single command
PHP
0 vote243 views2 answers
How to add woocommerce cart counter
PHP
0 vote239 views1 answer
Change php version in vagrant
PHP
1 vote220 views2 answers
Laravel return response with headers
PHP
0 vote244 views1 answer
Pdo mysqli error handling
PHP
3 votes300 views5 answers
Xampp
PHP
2 votes278 views1 answer
Laravel get only relationship
PHP Laravel
1 vote197 views2 answers
Laravel loop counter
PHP Laravel
0 vote226 views1 answer
Wordpress disable errors
PHP
2 votes246 views2 answers
Laravel switch
PHP