Documentation

Core_QueryBuilder_Replace extends Core_QueryBuilder_Statement
in package

REPLACE Database Abstraction Layer (DBAL)

https://dev.mysql.com/doc/refman/5.5/en/replace.html

// Sample 1 $oCore_QueryBuilder_Replace = Core_QueryBuilder::replace('tableName') ->columns('column1', 'column2', 'column3') // Option 1 ->values('value1', 'value2', 11) // Option 2 ->values(array('value3', 'value4', 17)) ->execute(); // Sample 2 $oCore_QueryBuilder_Replace = Core_QueryBuilder::replace('tableName', array('column1' => 'value1', 'column2' => 'value2')) ->execute();
Tags
subpackage

Core\Querybuilder

version
7.x
author

Hostmake LLC

copyright

© 2005-2024 ООО "Хостмэйк" (Hostmake LLC), http://www.hostcms.ru

Table of Contents

Properties

$_columns  : array<string|int, mixed>
Columns
$_dataBase  : mixed
DataBase
$_ignore  : mixed
Use IGNORE
$_into  : mixed
Table name
$_priority  : mixed
Use LOW_PRIORITY
$_queryType  : mixed
DataBase Query Type 1 - INSERT
$_unbuffered  : mixed
Query without fetching and buffering the result rows
$_values  : array<string|int, mixed>
Array of values

Methods

__call()  : mixed
Triggered when invoking inaccessible methods in an object context
__construct()  : mixed
Constructor.
__set()  : self
Run when writing data to inaccessible properties
build()  : string
Build the SQL query
clearLimit()  : self
Clear LIMIT
clearOffset()  : self
Clear OFFSET
clearValues()  : Core_QueryBuilder_Replace
Clear values
columns()  : Core_QueryBuilder_Replace
Add columns for INSERT
delayed()  : Core_QueryBuilder_Replace
Set DELAYED
execute()  : Core_DataBase
Execute query
getDataBase()  : Core_DataBase
Get DataBase
highPriority()  : Core_QueryBuilder_Replace
Set HIGH_PRIORITY
ignore()  : Core_QueryBuilder_Replace
Set IGNORE
into()  : Core_QueryBuilder_Replace
Set table name
lowPriority()  : Core_QueryBuilder_Replace
Set LOW_PRIORITY
setDataBase()  : Core_QueryBuilder_Statement
Set DataBase
unbuffered()  : self
Query without fetching and buffering the result rows
values()  : Core_QueryBuilder_Replace
Set values for INSERT
_isObjectSelect()  : bool
Is $object Core_QueryBuilder_Select
_quoteColumns()  : array<string|int, mixed>
Quote columns
_quoteValues()  : array<string|int, mixed>
Quote arary of values

Properties

$_columns

Columns

protected array<string|int, mixed> $_columns = array()

$_dataBase

DataBase

protected mixed $_dataBase = \NULL

$_ignore

Use IGNORE

protected mixed $_ignore = \FALSE

$_into

Table name

protected mixed $_into = \NULL

$_priority

Use LOW_PRIORITY

protected mixed $_priority = \NULL

$_queryType

DataBase Query Type 1 - INSERT

protected mixed $_queryType = 1

$_unbuffered

Query without fetching and buffering the result rows

protected mixed $_unbuffered = \FALSE

$_values

Array of values

protected array<string|int, mixed> $_values = array()

Methods

__call()

Triggered when invoking inaccessible methods in an object context

public __call(string $name, array<string|int, mixed> $arguments) : mixed
Parameters
$name : string

method name

$arguments : array<string|int, mixed>

arguments

__construct()

Constructor.

public __construct([array<string|int, mixed> $args = array() ]) : mixed
Parameters
$args : array<string|int, mixed> = array()

list of arguments $oCore_QueryBuilder_Replace = Core_QueryBuilder::replace('tableName');

$oCore_QueryBuilder_Replace = Core_QueryBuilder::replace('tableName', array('column1' => 'value1', 'column2' => 'value2'));
Tags
see
into()

__set()

Run when writing data to inaccessible properties

public __set(string $property, string $value) : self
Parameters
$property : string

property name

$value : string

property value

Return values
self

build()

Build the SQL query

public build() : string
Return values
string —

The SQL query

clearLimit()

Clear LIMIT

public clearLimit() : self
Return values
self

clearOffset()

Clear OFFSET

public clearOffset() : self
Return values
self

clearValues()

Clear values

public clearValues() : Core_QueryBuilder_Replace
$oCore_QueryBuilder_Replace = Core_QueryBuilder::replace('tableName') ->columns('column1', 'column2', 'column3') ->values('value1', 'value2', 11); $oCore_QueryBuilder_Replace->execute(); $oCore_QueryBuilder_Replace->clearValues(); $oCore_QueryBuilder_Replace->values('value3', 'value4', 17) ->execute();
Return values
Core_QueryBuilder_Replace

unbuffered()

Query without fetching and buffering the result rows

public unbuffered(bool $unbuffered) : self
Parameters
$unbuffered : bool
Return values
self

values()

Set values for INSERT

public values() : Core_QueryBuilder_Replace
$oCore_QueryBuilder_Replace = Core_QueryBuilder::replace('tableName') ->columns('column1', 'column2', 'column3') // Option 1 ->values('value1', 'value2', 11) // Option 2 ->values(array('value3', 'value4', 17))
Return values
Core_QueryBuilder_Replace

_isObjectSelect()

Is $object Core_QueryBuilder_Select

protected _isObjectSelect( $object) : bool
Parameters
$object :
Return values
bool

_quoteColumns()

Quote columns

protected _quoteColumns(array<string|int, mixed> $array) : array<string|int, mixed>
Parameters
$array : array<string|int, mixed>
Return values
array<string|int, mixed>

_quoteValues()

Quote arary of values

protected _quoteValues(array<string|int, mixed> $array) : array<string|int, mixed>
Parameters
$array : array<string|int, mixed>
Return values
array<string|int, mixed> 

        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results