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 vote250 views1 answer
Curl failed laravel centos
PHP
4 votes292 views1 answer
Php set alternatives
PHP
0 vote402 views3 answers
Email or phone required in laravel
PHP
0 vote334 views1 answer
Dump die laravel
PHP Laravel
0 vote379 views1 answer
Update Custom Cart Count (or any HTML) after AJAX Add to Cart in WooCommerce
PHP
6 votes292 views3 answers
Laravel collection put
PHP
0 vote337 views1 answer
Taxonomy_get_parents drupal 8
PHP
16 votes333 views2 answers
Laravel/ui v3.0.0 requires php ^7.3 -> your php version (8.0.2) does not satisfy that requirement.
PHP Laravel
0 vote285 views1 answer
Xdebug phpstorm
PHP
0 vote327 views1 answer
Maintaining serial number in laravel pagination table
PHP Laravel