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

10 votes128 views2 answers
Laravel success message
PHP
14 votes132 views3 answers
Laravel setup auth
PHP
3 votes244 views2 answers
Laravel drop column softdeletes
PHP Laravel
0 vote223 views1 answer
Laravel custom abort message
PHP Laravel
0 vote116 views2 answers
Wordpress wp_logout_url redirect
PHP
0 vote146 views1 answer
Wordpress post type template
PHP Wordpress
0 vote142 views1 answer
Install or enable PHP's zip extension mac os
PHP
3 votes190 views1 answer
Codeigniter form_validation email
PHP CodeIgniter
6 votes125 views3 answers
Php get file contents
PHP
23 votes207 views6 answers
Laravel logs
PHP