How to filter data in a Yii 2 model?

Question

I have a table Company and one of it's field is status. It may have one of two values: open or closed.

I've generated a Model using Gii.

How can i filter data in a model so that I'll see only companies with "closed" status on my r=company/index page?

Usually i'd write a query like "SELECT * FROM company WHERE status = 'closed'" but i don't know where to write it in Yii 2. All these MVC stuff makes me mad. Can't understand anything, really.

There are a lot of documentation on Yii site about framework structure. Read about ActiveRecord http://www.yiiframework.com/doc-2.0/guide-db-active-record.html — Anton M., Oct 06 '15 at 17:15
you can also build an `ActiveQuery` for it so you can do : `Company::find()->closed()->all();` (check this: http://stackoverflow.com/questions/31948917/yii2-activequery-example-and-what-is-the-reason-to-generate-activequery-class/31950149#31950149) — Salem Ouerdani, Oct 07 '15 at 09:12

score 0 · Answer 1 · edited Mar 15 '18 at 20:03

0

You can try this:

You can filter the model search results with the following code in your controller:

$companies = Company::find()
        ->where(['status' => 'closed'])
        ->all();

edited Mar 15 '18 at 20:03

waza-ari

928
1
13
34

answered Oct 06 '15 at 17:24

Amin Shafiee

366
1
6
19

Should I be filtering data in controller or in model? – Marat Oct 06 '15 at 17:25
You should do it inside your controller. Also, are you using CRUD generated with gii? – marche Oct 06 '15 at 17:31
@marche yes, gii generated – Marat Oct 06 '15 at 17:34
You should filter data in controller – Amin Shafiee Oct 06 '15 at 17:37
`where` condition should be an array – stig-js Oct 07 '15 at 08:13

How to filter data in a Yii 2 model?

1 Answers1