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

コード例 #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