通过使用Yii ActiveRecord的大表来预告 - “内存不足”错误

Question

I have a website on Yii Framework and I want to search a table for matching words.

I keep getting "out of memory" (it is a large table).

I try this code but it keeps loading the page

$dataProvider = new CActiveDataProvider('Data');
$iterator = new CDataProviderIterator($dataProvider);
foreach($iterator as $data) {
    echo $data->name."
";
}

So I try this code but it keeps limiting the result to 10:

$dataProvider = new CActiveDataProvider('Data');
$iterator = new CDataProviderIterator($dataProvider);
foreach($dataProvider as $data) {
    echo $data->name."
";
}

and if I do this I get the "out of memory" message:

$dataProvider = new CActiveDataProvider('Data' array(
    'criteria'=>array(
        'order'=>'id DESC',
    ),
    'pagination' => false
));

foreach($dataProvider as $data) {
    echo $data->name."
";
}

Answer 1

I don't know why are you need to load all search results in one page, but you can change number of items per page to desire value by this code (and using pagination):

$dataProvider = new CActiveDataProvider('Data' array(
    'criteria'=>array(
        'order'=>'id DESC',
        'condition' => 'town LIKE :search_town AND FK_country > :country_id',
        'params' => array(':search_town' => $search_town.'%', ':country_id' => 10)
    ),
     'pagination' => array(
         "pageSize" => 100,
         //"currentPage" => 0, //using for pagination
     )
));
$iterator = new CDataProviderIterator($dataProvider);
foreach($iterator as $data) {
     echo $data->name."
";
}

Here http://sonsonz.wordpress.com/2011/10/14/yii-examples-of-using-cdbcriteria/ more examples