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 vote196 views1 answer
Closing a php
PHP
0 vote193 views1 answer
Laravel withValidator
PHP
139 votes333 views6 answers
Strlen php
PHP
1 vote276 views3 answers
Laravel destroy or delete
PHP Laravel
0 vote204 views1 answer
Php 7.1 functions parameters with "?"
PHP
0 vote237 views4 answers
Form::select laravel
PHP Laravel
3 votes200 views3 answers
Wordpress logout
PHP
0 vote236 views3 answers
Add factory data laravel
PHP Laravel
3 votes200 views1 answer
If online php
PHP
5 votes210 views1 answer
Php get age from dob
PHP