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 vote209 views1 answer
Laravel check if relationship has data
PHP Laravel
49 votes221 views6 answers
Laravel when
PHP
3 votes240 views1 answer
How to change add to cart button in wordpress
PHP Wordpress
0 vote214 views1 answer
Php default argument
PHP
0 vote232 views1 answer
Register_uninstall_hook
PHP
8 votes240 views2 answers
Php convert spaces to underscores
PHP
5 votes227 views4 answers
Php echo arry
PHP
8 votes220 views3 answers
Php even odd
PHP
14 votes274 views6 answers
Php string starts with
PHP
0 vote227 views1 answer
Mysql php update sum same table
PHP