Yii selecting only specified attributes in array

Question

I often face this problem..

Lets say ..In blog application, I need to email all the active users..

What I do is write findAll on users with some conditions of their last login being greater than some value..and get all the User objects...Then run a foreach through all the user model objects and store emails in a array, then use the array..

I other words what is happening in back-end is I am loading whole model, while I only need barely0.5% of that information, and then running a dirty code to get values in in array, and then process with it..

Isn't it quite bad in performance and dirty code..

Now other approach I can think of is using commandBuilder and write query and then run same dirty code to get values in array..one problem of performance resolved..but as people say writing sql in mvc frameworks, is not a really good idea..

What I really want...some similar functions which give me column values in array if it is a single column, or array with column name as index if multiple columns..

So what I am thinkin of doing is implement it by extending ActiveRecord or something similar, what I want to check is if some one has already implemented something similar, or have some ideas for it..:)

Is that what you are looking for?yiiframework.com/doc/guide/1.1/en/database.ar#named-scopes — SALMAN
– SALMAN, Commented Jul 19, 2012 at 18:20
Probably he needs to select some fields instead of all fields. Use the CDbCriteria::select to get which fields you need. — Panagiotis
– Panagiotis, Commented Jul 19, 2012 at 18:40

Onkar Janwa · Accepted Answer · 2012-07-20 05:08:59Z

15

You must study of CDbCriteria deeply, their is all the things what your looking.

Have an example::

$criteria = new CDbCriteria;
$criteria->select = 't.first_name, t.email'; // select fields which you want in output
$criteria->condition = 't.status = 1';

$data = Users::model()->findAll($criteria);

$data is also an array output.

answered Jul 20, 2012 at 5:08

Onkar Janwa

3,9603 gold badges34 silver badges47 bronze badges

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

4 Comments

Onkar Janwa Over a year ago

Please clear your question, i replied on the basis of what i understood.

Tebe Over a year ago

why settings 't.first_name' but not 'a.first_name'. I tried 'a.first_name' but it didn't work unlike the first one. Is it some kind of convention?

Alexey Borovikov Over a year ago

Alex, It's a default table alias. Yii creates queries like "SELECT t.id FROM table t", but it may vary depends on query complexity (multiple tables queries). Check yiiframework.com/doc/api/1.1/CActiveRecord#getTableAlias-detail

Chinmay235 Over a year ago

@Копать_Шо_я_нашел remove alias

Zhang Buzz · Accepted Answer · 2015-04-10 04:00:35Z

14

In Yii2, you can use like this:

User::find()->select(['field1', 'field2']);

answered Apr 10, 2015 at 4:00

Zhang Buzz

11.2k6 gold badges44 silver badges47 bronze badges

3 Comments

realtebo Over a year ago

This should be the approved answer

Chinmay235 Over a year ago

@realtebo Yes this should be the approved answer but Question asking upon yii1 not yii2

Kushagra Over a year ago

Say you do $data = User::find()->select(['field1','field2']); and then you print $data->attributes. You'll find all the columns of the table will null values.

Rajat Singhal · Accepted Answer · 2012-07-21 21:24:51Z

11

I created the behavior as I said, the way it works is:

$active_users_emails = User::model()->findColumn('email', 'active = 1');

**returns array('[email protected]','[email protected]')..**

Now one doesn't need to go through all activerecords and collect column in array, then proceed, and also bear weight of loading whole column..

You can find the extension on git ..https://github.com/rajatsinghal/CAdvancedArFindBehavior

edited Jul 21, 2012 at 21:24

answered Jul 20, 2012 at 5:14

Rajat Singhal

11.3k5 gold badges40 silver badges57 bronze badges

Comments

Sascha Hennig · Accepted Answer · 2013-03-12 09:45:15Z

6

This would also work without any behavior or without the addition to CActiveRecord. Nevertheless I also like the solution with the behavior.

$active_users_emails=CHtml::listData(User::model()->findAllByAttributes(array('active'=>1)), 'id', 'email');

edited Mar 12, 2013 at 9:45

Sascha Hennig

2,5721 gold badge19 silver badges23 bronze badges

answered Mar 12, 2013 at 9:22

hurz

611 silver badge1 bronze badge

Comments

Rohit Suthar · Accepted Answer · 2015-04-17 07:55:10Z

2

Need to filter the model attributes using array_filter function. Try like this, its working great -

$criteria = new CDbCriteria;
$criteria->select = 't.first_name, t.email'; // select fields which you want in output
$criteria->condition = 't.status = 1';

$data = Users::model()->findAll($criteria);

Use array_filter before assign.

foreach($data as $model){
      $rows[] = array_filter($model->attributes);
   }

echo CJSON::encode($rows)

So, you will get output like this -

[{"first_name" : "Rohit", "email" : "[email protected]"}, {"first_name" : "Rajat", "email" : "[email protected]"}]

answered Apr 17, 2015 at 7:55

Rohit Suthar

3,6282 gold badges48 silver badges49 bronze badges

Comments

ajitpawarink · Accepted Answer · 2018-02-12 13:59:55Z

1

In same situation as question describes. After trying all above answers and some other resources here is what I am doing.

$emailIds = Yii::app()->db->createCommand(
                 'SELECT email FROM users WHERE is_active = 1'
            )->queryAll();

$emailIds = array_column( $emailIds, 'email' ) );

answered Feb 12, 2018 at 13:59

ajitpawarink

4446 silver badges14 bronze badges

Collectives™ on Stack Overflow

Yii selecting only specified attributes in array

6 Answers 6

4 Comments

3 Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

4 Comments

3 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related