/PHP/Yii/Yii app db createcommand join yii1

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 vote461 views1 answer
Yii1 findall as array listData
PHP Yii
0 vote477 views1 answer
Yii1 anchor tag
PHP Yii
1 vote496 views2 answers
Yii1 set flash
PHP Yii
0 vote471 views1 answer
Inner pages not found yii
PHP Yii
0 vote471 views1 answer
Modal align center yii2
PHP Yii
0 vote507 views2 answers
Yii2 set cookie
PHP Yii
0 vote478 views1 answer
Hashing passwords in yii 1
PHP Yii
0 vote502 views1 answer
Yii2 modules commands are not showing in console
PHP Yii
0 vote468 views2 answers
Yii2 get cookie
PHP Yii
0 vote466 views1 answer
Yii 1 clear cache
PHP Yii