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

4 votes173 views1 answer
Php echo json
PHP
0 vote188 views1 answer
Redirect to intent url after login laravel
PHP
0 vote212 views1 answer
Woocommerce php products list div
PHP
0 vote182 views1 answer
How to Add Custom Fonts to a WordPress Theme
PHP Wordpress
0 vote245 views1 answer
Twig superglobal get
PHP
-1 vote173 views4 answers
Include blade file in laravel
PHP
1 vote175 views1 answer
Laravel where multiple conditions on single colmn
PHP
0 vote153 views1 answer
Logout php mysql
PHP
0 vote204 views2 answers
Woocommerce get user id by email
PHP
0 vote170 views2 answers
How to use a session in blade
PHP