Overview

Namespaces

  • zsql
  • PHP

Classes

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

Exceptions

  • Exception
  • Overview
  • Namespace
  • Class
  • Tree

Class Insert

Insert query generator

zsql\Query
Extended by zsql\Insert
Namespace: zsql
Located at zsql/Insert.php
Methods summary
protected
# assemble( )

Assemble parts

Assemble parts

public zsql\Insert
# delayed( boolean $delayed = true )

Set delayed clause

Set delayed clause

Parameters

$delayed
boolean
$delayed

Returns

zsql\Insert
public zsql\Insert
# ignore( boolean $ignore = true )

Set ignore clause

Set ignore clause

Parameters

$ignore
boolean
$ignore

Returns

zsql\Insert
public zsql\Insert
# insert( array $values )

Alias for zsql\Insert::values()

Alias for zsql\Insert::values()

Parameters

$values
array
$values

Returns

zsql\Insert
public zsql\Insert
# into( string $table )

Alias for zsql\Query::table()

Alias for zsql\Query::table()

Parameters

$table
string
$table

Returns

zsql\Insert
public
# onDuplicateKeyUpdate( array $key, mixed $value = null )

Set on duplicate key update clause

Set on duplicate key update clause

Parameters

$key
array
$values
$value
protected zsql\Insert
# pushIgnoreDelayed( )

Push ignore or delayed onto parts

Push ignore or delayed onto parts

Returns

zsql\Insert
protected zsql\Insert
# pushOnDuplicateKeyUpdate( )

Push on duplicate key update clause

Push on duplicate key update clause

Returns

zsql\Insert
public zsql\Insert
# replace( boolean $replace = true )

Use replace instead of insert

Use replace instead of insert

Parameters

$replace
boolean
$replace

Returns

zsql\Insert
public zsql\Insert
# set( mixed $key, mixed $value = null )

Alias for zsql\Insert::value() or zsql\Insert::values()

Alias for zsql\Insert::value() or zsql\Insert::values()

Parameters

$key
mixed
$key
$value
mixed
$value

Returns

zsql\Insert
public zsql\Insert
# value( mixed $key, mixed $value = null )

Set a value

Set a value

Parameters

$key
mixed
$key
$value
mixed
$value

Returns

zsql\Insert
public zsql\Insert
# values( array $values )

Set values

Set values

Parameters

$values
array
$values

Returns

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

Set delayed clause

Set delayed clause

protected boolean $ignore
#

Set ignore clause

Set ignore clause

protected array $onDuplicateKeyUpdate
#

Set on duplicate key update clause

Set on duplicate key update clause

protected boolean $replace
#

Use replace instead of insert

Use replace instead of insert

protected array $values
#

Values

Values

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