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 vote279 views1 answer
Wordpress deactivate widgets gutenberg
PHP
0 vote328 views1 answer
Check if data inserted in database wordpress plugin
PHP Wordpress
1 vote280 views2 answers
Target class [Barryvdh\Cors\HandleCors] does not exist.
PHP
27 votes258 views10 answers
Google translate
PHP
0 vote283 views1 answer
Laravel download file from storage with progress bar
PHP
0 vote357 views1 answer
Laravel creating event get data
PHP Laravel
1 vote264 views1 answer
Send mail infinityfree phpmailer
PHP
0 vote219 views1 answer
Get category name form single post wordpress
PHP
0 vote274 views1 answer
Iterating rows in php
PHP
1 vote316 views1 answer
Laravel multiple group by
PHP Laravel