How to get an array value from the query in Yii 1.1

Question

$us= Yii::app()->db->createCommand()
    ->select('default_number_of_devices')
    ->from('user')
    ->where('id=1')
    ->queryRow();
echo "$us";

I should have got one value instead of array type because id is unique. But $us appears to be an array instead of single number.

when i write <?php echo "$us"; ?> display is (array) I would like to insert a single number like 3 => fill in the default_number_of_devices ricord because it uses where id 1, and only appears one digit — kagami
– kagami, Commented Oct 11, 2018 at 8:05
the above query is to define select default_number_of_devices from user where id = 1; if in sql only appears one number like number 3 but when I roll over $us just write the array instead of number 3 — kagami
– kagami, Commented Oct 11, 2018 at 8:20
It you want to array instead of single column value, then you should try queryAll(). And please ask you questions in proper way with exact output and expected output. — Mayank Vadiya
– Mayank Vadiya, Commented Oct 11, 2018 at 8:54

rob006 · Accepted Answer · 2018-10-11 09:03:50Z

3

You should use queryScalar() if you want to get single value from single column:

$us = Yii::app()->db->createCommand()
    ->select('default_number_of_devices')
    ->from('user')
    ->where('id=1')
    ->queryScalar();
echo $us;

queryRow() returns first row from query. And since row usually contains multiple columns, array is expected format (each element of array contains value of single column).

answered Oct 11, 2018 at 9:03

rob006

22.3k5 gold badges57 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

kagami Over a year ago

it's use ->queryScalar(); and not queryRow()

Damian Dziaduch Over a year ago

@kagami there are three ways to fetch the data. First one is queryScalar() which returns just the single value from query, which you wanted here. Second one is queryRow() which returns a single row from query as array. Last, there is queryAll() which returns one array with all rows and columns. Cheers!

Collectives™ on Stack Overflow

How to get an array value from the query in Yii 1.1

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related