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 vote207 views1 answer
Html windows logo
PHP
0 vote195 views5 answers
Download file laravel s3
PHP
0 vote171 views1 answer
Encryption and decryption in php example
PHP
0 vote265 views2 answers
Laravel file upload
PHP Laravel
0 vote259 views1 answer
Php regex replace all non alphanumeric characters
PHP
2 votes276 views1 answer
Php remove first and last char
PHP
0 vote192 views1 answer
An einem string etwas anfügen php
PHP
0 vote188 views1 answer
- tijsverkoyen/css-to-inline-styles 2.2.3 requires ext-dom * -> the requested PHP extension dom is missing from your system.
PHP
0 vote214 views1 answer
Php get ip by domain
PHP
25 votes206 views3 answers
Php decode json file
PHP