Orpheus

WhereFacet

Table of Contents

Methods

formatCondition()  : void
fromOffset()  : mixed|$this
Set/Get the offset from which we are getting results
get()  : void
maxRows()  : mixed|SqlSelectRequest
Set/Get the number of expected result (as limit)
number()  : mixed|SqlSelectRequest
Set/Get the number of expected result (as limit)
orderBy()  : mixed|static
Set/Get the order by filter
set()  : void
sget()  : void
where()  : static
Set the where clause

Methods

formatCondition()

public formatCondition(array<string|int, mixed>|string $condition, string|null $operator, mixed $value, bool $escapeValue) : void
Parameters
$condition : array<string|int, mixed>|string
$operator : string|null
$value : mixed
$escapeValue : bool

fromOffset()

Set/Get the offset from which we are getting results

public fromOffset([int|null $offset = null ]) : mixed|$this
Parameters
$offset : int|null = null
Return values
mixed|$this

get()

public get(string $string, mixed $array = null) : void
Parameters
$string : string
$array = null : mixed

orderBy()

Set/Get the order by filter

public orderBy([string|null $fields = null ]) : mixed|static
Parameters
$fields : string|null = null
Return values
mixed|static

set()

public set(string $string, mixed $where) : void
Parameters
$string : string
$where : mixed

sget()

public sget(string $string, string|null $fields) : void
Parameters
$string : string
$fields : string|null

where()

Set the where clause

public where(array<string|int, mixed>|string $condition[, string|null $operator = null ][, string|null $value = null ][, bool $escapeValue = true ]) : static

If only $condition is provided, this is used as complete string, e.g. where("id = 5") If $equality & $value are provided, it uses it with $condition as a field (identifier), e.g. where('id', '=', '5') where identifier and value are escaped with escapeIdentifier() & escapeValue() If $equality is provided but $value is not, $equality is the value and where are using a smart comparator, e.g. where('id', '5') All examples return the same results. Smart comparator is IN for array values and = for all others.

Parameters
$condition : array<string|int, mixed>|string
$operator : string|null = null
$value : string|null = null
$escapeValue : bool = true
Return values
static 

							

							
						

					

					
					
				
				

			

			

				
				

					On this page
					
					
				

			
			

		

		

			

				

					
Search results