Overview

Namespaces

  • zsql
  • PHP

Classes

  • Database
  • Delete
  • Expression
  • ExtendedQuery
  • Insert
  • Model
  • Query
  • Result
  • Select
  • Update

Exceptions

  • Exception
  • Overview
  • Namespace
  • Class
  • Tree

Class ExtendedQuery

Abstract class for queries that support select-like functionality (delete, select, update)

zsql\Query
Extended by zsql\ExtendedQuery

Direct known subclasses

zsql\Delete, zsql\Select, zsql\Update
Abstract
Namespace: zsql
Located at zsql/ExtendedQuery.php
Methods summary
public zsql\ExtendedQuery
# group( string $column )

Set group by

Set group by

Parameters

$column
string
$column

Returns

zsql\ExtendedQuery
public zsql\ExtendedQuery
# limit( integer $limit, integer $offset = null )

Set limit

Set limit

Parameters

$limit
integer
$limit
$offset
integer
$offset

Returns

zsql\ExtendedQuery
public zsql\ExtendedQuery
# offset( integer $offset, integer $limit = null )

Set offset

Set offset

Parameters

$offset
integer
$offset
$limit
integer
$limit

Returns

zsql\ExtendedQuery
public zsql\ExtendedQuery
# order( string $order, string $direction = 'ASC' )

Set order

Set order

Parameters

$order
string
$order
$direction
string
$direction

Returns

zsql\ExtendedQuery
protected zsql\ExtendedQuery
# pushLimit( )

Push limit clause onto parts

Push limit clause onto parts

Returns

zsql\ExtendedQuery
protected zsql\ExtendedQuery
# pushGroup( )

Push group by clause onto parts

Push group by clause onto parts

Returns

zsql\ExtendedQuery
protected zsql\ExtendedQuery
# pushOrder( )

Push order by clause onto parts

Push order by clause onto parts

Returns

zsql\ExtendedQuery
protected zsql\ExtendedQuery
# pushWhere( )

Push where clause onto parts

Push where clause onto parts

Returns

zsql\ExtendedQuery
public zsql\ExtendedQuery
# where( mixed $where, mixed $value = null )

Set where

Set where

Parameters

$where
mixed
$where
$value
mixed
$value

Returns

zsql\ExtendedQuery
public zsql\ExtendedQuery
# whereExpr( string $where )

Set where expression. Shorthand for: where(new Expression('string'))

Set where expression. Shorthand for: where(new Expression('string'))

Parameters

$where
string
$where

Returns

zsql\ExtendedQuery
public zsql\ExtendedQuery
# whereIn( mixed $where, array $value )

Set where in

Set where in

Parameters

$where
mixed
$where
$value
array
$value

Returns

zsql\ExtendedQuery
Methods inherited from zsql\Query
__construct(), __toString(), assemble(), interpolateParams(), interpolation(), params(), parts(), push(), pushTable(), pushValues(), query(), quoteIdentifier(), quoteIdentifierIfNotExpression(), setQuoteCallback(), table(), toString()
Properties summary
protected string $direction
#

Order direction

Order direction

protected string $group
#

Group by column

Group by column

protected integer $limit
#

Limit number

Limit number

protected integer $offset
#

Offset number

Offset number

protected string $order
#

Order by column

Order by column

protected array $where
#

Where expressions

Where expressions

Properties inherited from zsql\Query
$database, $interpolation, $params, $parts, $query, $queryCallback, $quoteCallback, $quoteChar, $quoteIdentifierChar, $table
API documentation generated by ApiGen 2.8.0