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 vote262 views1 answer
Php 8 loadmodule
PHP
5 votes239 views2 answers
Trim elements of array php
PHP
0 vote278 views1 answer
Laravel number input positive only
PHP
43 votes241 views2 answers
Get array length using php
PHP
0 vote246 views1 answer
If any comma in string in php
PHP
0 vote284 views2 answers
Laravel pagination vuetify
PHP Laravel
0 vote241 views1 answer
Model find by certain column laravel
PHP
1 vote240 views1 answer
Session_destroy not working
PHP
10 votes281 views2 answers
Laravel collection toArray
PHP Laravel
2 votes226 views2 answers
Laravel sidebar menu active
PHP