Cake\Database\Query::limit PHP Method

limit() public method

In some databases, this operation might not be supported or will require the query to be transformed in order to limit the result set size. ### Examples $query->limit(10) // generates LIMIT 10 $query->limit($query->newExpr()->add(['1 + 1'])); // LIMIT (1 + 1)
public limit ( integer | Cake\Database\ExpressionInterface $num )
$num integer | Cake\Database\ExpressionInterface number of records to be returned
    public function limit($num)
    {
        $this->_dirty();
        if ($num !== null && !is_object($num)) {
            $num = (int) $num;
        }
        $this->_parts['limit'] = $num;
        return $this;
    }

Usage Example

Example #1
3
 public function findCursor(Query $query)
 {
     $current = $this->request->query('cursor');
     $limit = $this->request->query('limit') ?: 10;
     if ($current) {
         $query->where(['id >' => $current]);
     }
     $query->limit($limit);
     return $query;
 }
All Usage Examples Of Cake\Database\Query::limit