Ubiquity  2.0.3
php rapid development framework
SqlUtils Class Reference

Utilitaires SQL. More...

Static Public Member Functions

static getWhere ($keyAndValues)
 
static getMultiWhere ($values, $field)
 
static getSearchWhere ($fields, $value, $jokerBefore="%", $jokerAfter="%")
 
static getInsertFields ($keyAndValues)
 
static getInsertFieldsValues ($keyAndValues)
 
static getUpdateFieldsKeyAndValues ($keyAndValues)
 
static checkWhere ($condition)
 
static getCondition ($keyValues, $classname=NULL, $separator=" AND ")
 
static getFieldList ($fields, $tableName=false)
 

Static Public Attributes

static $quote ='`'
 

Static Private Member Functions

static getParameters ($keyAndValues)
 
static getQuotedKeys ($keyAndValues)
 

Detailed Description

Utilitaires SQL.

Author
jc
Version
1.0.0.4

Definition at line 13 of file SqlUtils.php.

Member Function Documentation

◆ checkWhere()

static checkWhere (   $condition)
static

Definition at line 73 of file SqlUtils.php.

◆ getCondition()

static getCondition (   $keyValues,
  $classname = NULL,
  $separator = " AND " 
)
static

Definition at line 81 of file SqlUtils.php.

◆ getFieldList()

static getFieldList (   $fields,
  $tableName = false 
)
static

Definition at line 99 of file SqlUtils.php.

◆ getInsertFields()

static getInsertFields (   $keyAndValues)
static

Definition at line 57 of file SqlUtils.php.

◆ getInsertFieldsValues()

static getInsertFieldsValues (   $keyAndValues)
static

Definition at line 61 of file SqlUtils.php.

◆ getMultiWhere()

static getMultiWhere (   $values,
  $field 
)
static

Definition at line 41 of file SqlUtils.php.

◆ getParameters()

static getParameters (   $keyAndValues)
staticprivate

Definition at line 17 of file SqlUtils.php.

◆ getQuotedKeys()

static getQuotedKeys (   $keyAndValues)
staticprivate

Definition at line 25 of file SqlUtils.php.

◆ getSearchWhere()

static getSearchWhere (   $fields,
  $value,
  $jokerBefore = "%",
  $jokerAfter = "%" 
)
static

Definition at line 49 of file SqlUtils.php.

◆ getUpdateFieldsKeyAndValues()

static getUpdateFieldsKeyAndValues (   $keyAndValues)
static

Definition at line 65 of file SqlUtils.php.

◆ getWhere()

static getWhere (   $keyAndValues)
static

Definition at line 33 of file SqlUtils.php.

Field Documentation

◆ $quote

$quote ='`'
static

Definition at line 15 of file SqlUtils.php.


The documentation for this class was generated from the following file: