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 vote291 views1 answer
Get user type wp php
PHP
120 votes504 views6 answers
Replace all occurrences of a string in javascript
PHP
0 vote277 views2 answers
Uuidv4 php
PHP
0 vote271 views1 answer
Laravel create text file
PHP
13 votes268 views5 answers
Remove empty array elements php
PHP
0 vote292 views2 answers
Php enablem mod
PHP
-1 vote251 views1 answer
Connect to ftp server php
PHP
0 vote281 views1 answer
Php remove dashes from string
PHP
0 vote327 views1 answer
Laravel migration add date of birth column
PHP Laravel
0 vote251 views1 answer
If(!empty($_POST['full_name'])){ echo("Hello " . $_POST['full_name']); }
PHP