Flow PHP

ReadQuery

Read onlyYes
FinalYes

Methods

count()  : string
declareCursor()  : DeclareCursorOptionsStep
isOrdered()  : bool
keySetFirstPage()  : string
The first page: LIMIT $first, no key condition.
keySetNextPage()  : string
Every later page: LIMIT $first, and the last row's key values from $first + 1 on.
of()  : self
page()  : string
LIMIT $first OFFSET $first + 1.
sql()  : string

Methods

count()

public count() : string
Return values
string

declareCursor()

public declareCursor(string $cursorName) : DeclareCursorOptionsStep
Parameters
$cursorName : string
Return values
DeclareCursorOptionsStep

isOrdered()

public isOrdered() : bool
Return values
bool

keySetFirstPage()

The first page: LIMIT $first, no key condition.

public keySetFirstPage(KeySet $keySet, int $first) : string
Parameters
$keySet : KeySet
$first : int

the first placeholder after the caller's parameters

Return values
string

keySetNextPage()

Every later page: LIMIT $first, and the last row's key values from $first + 1 on.

public keySetNextPage(KeySet $keySet, int $first) : string
Parameters
$keySet : KeySet
$first : int

the first placeholder after the caller's parameters

Return values
string

of()

public static of(Sql|string $query, class-string $extractor) : self
Parameters
$query : Sql|string
$extractor : class-string
Tags
throws
ParserException
InvalidArgumentException
Return values
self

page()

LIMIT $first OFFSET $first + 1.

public page(int $first) : string
Parameters
$first : int

the first placeholder after the caller's parameters

Return values
string

sql()

public sql() : string
Return values
string
On this page

Search results