如何从Yii 1.1中的查询中获取数组值
问题描述：
$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.
答
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).