Yii Php: Getting values having a specific key in an associative array

Question

I have a model/database table that looks like this

id | group_id| first_name | middle_name | last_name
------------------------------------------------------ 
   |          |            |             |      
------------------------------------------------------

After retrieving a model from the database:

say:

$people = PersonModel::model()->findAllByAttributes(array('group_id'=>$groupId));

and suppose i've retrieved 10 rows.. matching the groupId given

I want to store all the first_name of the 10 rows that matched.

I know this can be done by:

$personArray = array();
foreach($people as $person){
   $personArray[] = $person->first_name;
}

but is there another way, e.g. a php function that does the same thing? Thank you!

Daniel Vaquero · Accepted Answer · 2013-10-07 10:03:28Z

3

$criteria = new CDbCriteria;
$criteria->compare('group_id', $groupId);
$criteria->limit = 10;
$people = PersonModel::model()->findAll($criteria);
$personArray = $list = CHtml::listData($people, 'id','first_name');

The CHtml::listData() returns an associative array with like: ['id'] => 'first_name' (attributes of the model)

answered Oct 7, 2013 at 10:03

Daniel Vaquero

1,3051 gold badge8 silver badges13 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 10:25:13Z

0

you can first count the models matching your group_id, like:

PersonModel::model()->countByAttributes(array('group_id'=>$groupId));

then you can limit it to 10 and order it desc and get the latest 10 rows that matched!

Yii : how to count records in a model?

edited May 23, 2017 at 10:25

CommunityBot

11 silver badge

answered Oct 7, 2013 at 8:09

Developerium

7,2755 gold badges41 silver badges57 bronze badges

Collectives™ on Stack Overflow

Yii Php: Getting values having a specific key in an associative array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related