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

12 votes157 views2 answers
Get current authenticated user laravel
PHP Laravel
0 vote124 views1 answer
Php date modify plus 1 day
PHP
0 vote124 views1 answer
Laravel range query
PHP
0 vote134 views1 answer
Save my name, email, and website in this browser for the next time I comment remove in wp
PHP
5 votes133 views1 answer
Eloquent chunk laravel model chunk
PHP
1 vote149 views1 answer
Laravel best practices
PHP
1 vote107 views1 answer
Laravel roles
PHP
0 vote127 views1 answer
Php search in array case insensitive
PHP
0 vote122 views1 answer
Php iife
PHP
0 vote119 views1 answer
How To Check If A String Ends With Another String In PHP
PHP