php8.5
Home/ Manual/ mysql_xdevapi / crudoperationlimitable/ CrudOperationLimitable::limit

CrudOperationLimitable::limit

PHP function Edit on GitHub ✎

Set result limit

Description

mysql_xdevapi\CrudOperationLimitable::limit(int $rows): mysql_xdevapi\CrudOperationLimitable

Sets the maximum number of records or documents to return.

Func

Parameters

rows

The maximum number of records or documents.

Return Values

A CrudOperationLimitable object.

Examples

mysql_xdevapi\CrudOperationLimitable::limit() example

php
<?php

$res = $coll->find()->fields(['name as n','age as a','job as j'])->groupBy('j')->limit(11)->execute();
$res = $table->update()->set('age',69)->where('age > 15 and age < 22')->limit(4)->orderby(['age asc','name desc'])->execute();

?>

Source: reference/mysql_xdevapi/mysql_xdevapi/crudoperationlimitable/limit.xml · from the official PHP manual (php/doc-en)