retrieve model->search() results

enterjayman · May 5, 2015, 7:55am

I’m new in Yii. How do I retrieve the rows returned by search in ‘admin’ pages? I’m looking for a procedure something similar to findAll()… Thanks

redguy · May 5, 2015, 8:07am

search() returns DataProvider which you can use to retrieve paged results. There is helper object you can use to iterate all record on all pages (http://www.yiiframework.com/doc/api/1.1/CDataProviderIterator):




$dataProvider = $model->search();

$iterator = new CDataProviderIterator($dataProvider);

foreach($iterator as $user) {

 echo $user->name."\n";

}

enterjayman · May 5, 2015, 8:43am

Maciej Liżewski:

search() returns DataProvider which you can use to retrieve paged results. There is helper object you can use to iterate all record on all pages (http://www.yiiframework.com/doc/api/1.1/CDataProviderIterator):
$dataProvider = $model->search();

$iterator = new CDataProviderIterator($dataProvider);

foreach($iterator as $user) {

 echo $user->name."\n";

}

but where do i put that code to get hold of the values? search in cgridview seems like it is triggered by ajax.

skysunil2004 · May 5, 2015, 9:29am

where you will see model file there you will search public function like

public function search() {

  &#036;criteria = new CDbCriteria;


  &#036;criteria-&gt;compare('name', &#036;this-&gt;name);


  &#036;criteria-&gt;compare('city', &#036;this-&gt;city);





 return new CActiveDataProvider(&#036;this, array(


        'criteria' =&gt; &#036;criteria,


        'pagination' =&gt; 10,


    ));

}

"name","city" are table field. please use like this

redguy · May 5, 2015, 9:43am

ajax is used to re-render whole page. search() is called either in controller action, or in view where grid/list is defined (usually index and admin views)