ManaPHP\Db::limit PHP Method

Db Class Documentation Show file Open project: manaphp/manaphp

limit() public method

Appends a LIMIT clause to $sqlQuery argument


   echo $connection->limit("SELECT * FROM robots", 5);

public limit ( string $sql, integer $number, integer $offset ) : string
$sql	string
$number	integer
$offset	integer
return	string

    public function limit($sql, $number, $offset = 0)
    {
        return $sql . ' LIMIT ' . $number . ($offset === 0 ? '' : ' OFFSET ' . $offset);
    }

__construct

_executePrepared

_parseBindValue

affectedRows

begin

commit

delete

execute

fetchAll

fetchOne

getBind

getEmulatedSQL

getSQL

insert

isUnderTransaction

lastInsertId

limit

query

rollback

update