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 vote242 views1 answer
Augmenter la dimension des fichiers WP
PHP Wordpress
0 vote183 views1 answer
Bitnami lightsail PHP Fatal error: Out of memory (allocated
PHP
0 vote209 views1 answer
Stupidity
PHP
4 votes166 views2 answers
Laravel get current route in app.js
PHP Laravel
4 votes287 views5 answers
Php variable in string
PHP
4 votes225 views2 answers
Ubuntu laravel storage permission
PHP Laravel
0 vote196 views1 answer
Launch new tab and refresh original page codeigniter
PHP CodeIgniter
3 votes183 views1 answer
Ternary expressions php
PHP
9 votes223 views4 answers
Laravel group route controller
PHP Laravel
12 votes182 views2 answers
Get session storage php
PHP