class vB_dB_MYSQL_QueryBuilder extends vB_dB_QueryBuilder

Mysql specific query interface -- see base class

Traits

Properties

protected $operators Mapping of operators to text. from vB_dB_QueryBuilder
protected $bitOperators from vB_dB_QueryBuilder
protected $quote_char from vB_dB_QueryBuilder
protected $db from vB_dB_QueryBuilder
protected $debug_sql from vB_dB_QueryBuilder
protected $quotechar The character used for quoting in an sql string- usually '. from vB_dB_QueryBuilder

Methods

__sleep()

No description

__wakeup()

No description

__construct($db, $debug_sql)

Construct the query builder

matchValues($queryid, $querystring, $values, $forcetext = array())

This matches a series of values against a query string

mixed
conditionsToFilter(char $conditions, array $forcetext = array())

This function generates the query text against a table.

primaryKeyToFilter($primarykey, $values, $forcetext = array())

No description

valueArrayToFilter($values, $forcetext = array())

No description

valueArrayToSetLine($values, $forcetext = array())

No description

makeSelectQuery($table, $filter, $sortorder, $structure, $params = array())

No description

makeCountQuery($table, $filter, $structure)

No description

makeDeleteQuery($table, $filter, $params = array())

No description

makeUpdateQuery($table, $filter, $setline, $params = array())

No description

makeInsertQuery($table, $ignore, $values, $forcetext = array())

No description

makeReplaceQuery($table, $values, $forcetext = array())

No description

makeInsertMultipleQuery($table, $values, $forcetext = array())

No description

setDebugSQL($debug_sql)

No description

quoteValue($key, $value, $forcetext = array())

No description

escaped
escapeField(string $field)

Handle situations were the field name might be a reserved word. Also allow for qualified names.

escapeFields(array $fields)

No description

logQuery($sql)

No description

Details

in vB_Trait_NoSerialize at line 15
__sleep()

in vB_Trait_NoSerialize at line 20
__wakeup()

in vB_dB_QueryBuilder at line 79
__construct($db, $debug_sql)

Construct the query builder

Parameters

$db
$debug_sql

in vB_dB_QueryBuilder at line 94
matchValues($queryid, $querystring, $values, $forcetext = array())

This matches a series of values against a query string

Parameters

$queryid
$querystring
$values
$forcetext

in vB_dB_QueryBuilder at line 149
mixed conditionsToFilter(char $conditions, array $forcetext = array())

This function generates the query text against a table.

Parameters

char $conditions
array $forcetext

Return Value

mixed

in vB_dB_QueryBuilder at line 349
primaryKeyToFilter($primarykey, $values, $forcetext = array())

Parameters

$primarykey
$values
$forcetext

in vB_dB_QueryBuilder at line 382
valueArrayToFilter($values, $forcetext = array())

Parameters

$values
$forcetext

in vB_dB_QueryBuilder at line 468
valueArrayToSetLine($values, $forcetext = array())

Parameters

$values
$forcetext

in vB_dB_QueryBuilder at line 516
makeSelectQuery($table, $filter, $sortorder, $structure, $params = array())

Parameters

$table
$filter
$sortorder
$structure
$params

in vB_dB_QueryBuilder at line 640
makeCountQuery($table, $filter, $structure)

Parameters

$table
$filter
$structure

in vB_dB_QueryBuilder at line 654
makeDeleteQuery($table, $filter, $params = array())

Parameters

$table
$filter
$params

in vB_dB_QueryBuilder at line 673
makeUpdateQuery($table, $filter, $setline, $params = array())

Parameters

$table
$filter
$setline
$params

in vB_dB_QueryBuilder at line 689
makeInsertQuery($table, $ignore, $values, $forcetext = array())

Parameters

$table
$ignore
$values
$forcetext

in vB_dB_QueryBuilder at line 727
makeReplaceQuery($table, $values, $forcetext = array())

Parameters

$table
$values
$forcetext

in vB_dB_QueryBuilder at line 759
makeInsertMultipleQuery($table, $values, $forcetext = array())

Parameters

$table
$values
$forcetext

in vB_dB_QueryBuilder at line 799
setDebugSQL($debug_sql)

Parameters

$debug_sql

in vB_dB_QueryBuilder at line 805
protected quoteValue($key, $value, $forcetext = array())

Parameters

$key
$value
$forcetext

in vB_dB_QueryBuilder at line 854
protected escaped escapeField(string $field)

Handle situations were the field name might be a reserved word. Also allow for qualified names.

Parameters

string $field -- the field name

Return Value

escaped version of the field name

in vB_dB_QueryBuilder at line 859
protected escapeFields(array $fields)

Parameters

array $fields

in vB_dB_QueryBuilder at line 868
protected logQuery($sql)

Parameters

$sql