Cake\Database\Query::limit PHP 메소드

limit() 공개 메소드

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