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

43 votes82 views5 answers
Laravel create controller command
PHP
8 votes91 views1 answer
Laravel link storage to public
PHP
2 votes100 views3 answers
Laravel get file size uploaded
PHP Laravel
1 vote116 views2 answers
Scheduling in laravel in custom cron
PHP Laravel
8 votes96 views3 answers
Check for an existing user laravel eloquent
PHP
2 votes90 views1 answer
Debug query in moodle
PHP
0 vote85 views1 answer
How to get index 2nd php
PHP
26 votes115 views6 answers
Drop foreign key laravel
PHP
0 vote93 views1 answer
Get nearby from longitude and latitude in laravel
PHP
0 vote118 views2 answers
Laravel get path to storage folder
PHP