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 vote234 views1 answer
EzSql PDO Connection
PHP
0 vote172 views1 answer
Wp_query custom post type filter by acf field value
PHP
2 votes233 views3 answers
Laravel 8 404 status
PHP
0 vote188 views1 answer
Configuration laravel dompdf
PHP Laravel
1 vote255 views1 answer
Zend redirect to url
PHP
5 votes205 views2 answers
Laravel groupby and latest
PHP Laravel
2 votes203 views1 answer
Get the current page address
PHP
0 vote174 views2 answers
Typeahead bootstrap 4 add multiple values
PHP
17 votes288 views6 answers
Laravel auth user in constructor
PHP Laravel
0 vote283 views1 answer
Veue laravel remove #/
PHP Laravel