Db\Dialect::limit

public limit (mixed $sqlQuery, mixed $number)

Generates the SQL for LIMIT clause

$sql = $dialect->limit('SELECT * FROM robots', 10);
    echo $sql; // SELECT * FROM robots LIMIT 10
 
    $sql = $dialect->limit('SELECT * FROM robots', [10, 50]);
    echo $sql; // SELECT * FROM robots LIMIT 10 OFFSET 50

Links:

https://docs.phalconphp.com/en/latest/api/Phalcon_Db_Dialect.html#limit

doc_Phalcon

2025-01-10 15:47:30

Comments

Popular Articles

Db\Dialect implements Phalcon\Db\DialectInterface Source on GitHub This is the base class to each database dialect. This implements common methods to transform

Db\Dialect::rollbackSavepoint public rollbackSavepoint (mixed $name) Generate SQL to rollback a savepoint

Db\Dialect::sharedLock public sharedLock (mixed $sqlQuery) Returns a SQL modified with a LOCK IN SHARE MODE clause $sql = $dialect->sharedLock('SELECT * FROM robots');

Db\Dialect::getCustomFunctions public getCustomFunctions () Returns registered functions

Db\Dialect::supportsSavepoints public supportsSavepoints () Checks whether the platform supports savepoints