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 vote237 views1 answer
Enum artisan codwe
PHP
0 vote216 views1 answer
Get post id contact form 7
PHP
0 vote183 views1 answer
PHP not working centos 8
PHP
3 votes208 views2 answers
Php remove cookie
PHP
0 vote230 views1 answer
Create symfony demo app
PHP Symfony
0 vote185 views1 answer
Yum install php-mysql
PHP
5 votes222 views6 answers
Php get only numbers from string
PHP
0 vote185 views1 answer
Session not working php
PHP
0 vote181 views1 answer
Order by pre get posts
PHP
15 votes162 views10 answers
Laravel pagination
PHP