Cdbcriteria Limit Not Working

mary1122 · December 23, 2013, 12:16pm

[left]Hi! I’m newbie in Yii. I’m having a problem with a search function with limit.

The model function:

[i]/**

Retrieves a list of models based on the current search/filter conditions.
@return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.

*/

public function search($number)

{

&#036;criteria=new CDbCriteria;


&#036;criteria-&gt;limit = &#036;number;


&#036;criteria-&gt;offset = 0;


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


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


));

}[/i]

The controller function calling to search

[i]public function actionReadItems($number = 200)

{

$links = new Links;

$l = $links->search($number)->getData();

…

}[/i]

In table links, there are 10 items, the $number parameter is 2, but I get 10 items as a result instead of 2. What I’m doing wrong?

When I print what is in $criteria:

[i]CDbCriteria#1

(

[select] =&gt; '*'


[distinct] =&gt; false


[condition] =&gt; ''


[params] =&gt; array()


[limit] =&gt; '2'


[offset] =&gt; 0


[order] =&gt; ''


[group] =&gt; ''


[join] =&gt; ''


[having] =&gt; ''


[with] =&gt; null


[alias] =&gt; null


[together] =&gt; null


[index] =&gt; null


[scopes] =&gt; null


[CComponent:_e] =&gt; null


[CComponent:_m] =&gt; null

)

[/i]

argent · December 23, 2013, 12:31pm

Use the pagination’s pageSize variable:




public function search($number)

{

  $criteria=new CDbCriteria;

  return new CActiveDataProvider($this, array(

    'criteria'=>$criteria,

    'pagination' => array(

      'pageSize' => $number

    )

  ));

}

richmest · December 23, 2013, 1:10pm

‘criteria’ is defined as an integer; but it is shown as text.


[limit] => '2'

[offset] => 0

[order] => ''

Could it be that $number is somehow set to ASCII 2?