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

14 votes148 views3 answers
Php carbon from timestamp
PHP
0 vote180 views1 answer
Laravel extends if
PHP
0 vote146 views1 answer
Change arabic number to english php
PHP
1 vote135 views1 answer
Php 7 strict mode
PHP
0 vote183 views1 answer
How to pass variable to an event listener laravel
PHP Laravel
0 vote160 views1 answer
Php get file from another server
PHP
0 vote136 views1 answer
Laravel collection last
PHP
6 votes160 views2 answers
Login selected user laravel
PHP
0 vote154 views1 answer
Woocommerce pagination
PHP
8 votes185 views1 answer
Laravel symlink command
PHP Laravel