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 vote96 views1 answer
Optional chain operator php
PHP
0 vote141 views1 answer
Db seed in controller
PHP
2 votes99 views1 answer
Laravel upload image to public folder
PHP
0 vote104 views1 answer
Wp post view
PHP
0 vote98 views1 answer
Php call class method dynamically
PHP
2 votes144 views2 answers
Php dirname
PHP
4 votes136 views1 answer
Laravel deployment
PHP Laravel
0 vote106 views2 answers
Minishlink/web-push v5.2.5 requires ext-gmp *
PHP
0 vote129 views1 answer
Beanstalk run laravel command
PHP Laravel
2 votes108 views2 answers
Php pdo fetch from db
PHP