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 vote175 views2 answers
Php radians to degrees
PHP
102 votes243 views6 answers
Php string replace
PHP
0 vote230 views1 answer
Wordpress display post categories
PHP Wordpress
0 vote213 views2 answers
Laravel migration change column order
PHP Laravel
3 votes224 views3 answers
Laravel clear table
PHP Laravel
0 vote177 views1 answer
Return json in middleware laravel
PHP
1 vote180 views1 answer
Get category post in wordpress
PHP
31 votes194 views4 answers
Laravel seed fresh
PHP
0 vote177 views2 answers
String to array in laravel
PHP
2 votes163 views1 answer
How to get data from html form in php
PHP