how to read yii create command object without foreachloop

Question

I use create command of Yii as

$sql = "select name from users where id = 2";

$EmployeeName=Yii::app()->db->createCommand($sql)->queryAll();

now i have to use foreachloop to get specific value like

foreach($EmployeeName as $value)
$name = $value['name'];

Can i bypass foreach loop like

$EmployeeName -> name; //To get value of specific field

Question is why i use foreach loop when i know i have single index array? when i am using print_r($EmployeeName) its showing me sql command in object instead of data so i am confused how to debug object array

I think its because you are using query all. try $EmployeeName[0]->name — Jericko Ramilo
– Jericko Ramilo, Commented Dec 4, 2014 at 7:04

topher · Accepted Answer · 2014-12-04 07:12:21Z

1

Assuming id is your primary key, you should use queryScalar instead. This will return a single value and not an array.

$name=Yii::app()->db->createCommand($sql)->queryScalar();

answered Dec 4, 2014 at 7:12

topher

14.9k8 gold badges56 silver badges71 bronze badges

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

Comments

Rishabh · Accepted Answer · 2014-12-04 07:42:11Z

0

You can use this syntax in Yii:

$user = Users::model()->findByAttributes(array('id' => 2));
$name = $user->name;
echo $name;

answered Dec 4, 2014 at 7:42

Rishabh

1872 silver badges13 bronze badges

Comments

Igor Savinkin · Accepted Answer · 2014-12-08 14:26:46Z

0

Single line solution

The simplest approach is find by primary key (PK).

Suppose id is PK in the Users model (Users model should be set thru gii model generator):

$name = Users::model()->findByPk(2)->name;

answered Dec 8, 2014 at 14:26

Igor Savinkin

6,35910 gold badges39 silver badges76 bronze badges

Collectives™ on Stack Overflow

how to read yii create command object without foreachloop

3 Answers 3

Comments

Comments

Single line solution

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Single line solution

Comments

Your Answer

Sign up or log in

Post as a guest

Related