|
| __construct (DatabaseInterface $db=null) |
|
| __toString () |
|
| __get ($name) |
|
| call ($columns) |
|
| castAs (string $type, string $value, ?string $length=null) |
|
| castAsChar ($value) |
|
| charLength ($field, $operator=null, $condition=null) |
|
| clear ($clause=null) |
|
| columns ($columns) |
|
| concatenate ($values, $separator=null) |
|
| currentTimestamp () |
|
| dateAdd ($date, $interval, $datePart) |
|
| dateFormat () |
|
| dump () |
|
| delete ($table=null) |
|
| e ($text, $extra=false) |
|
| escape ($text, $extra=false) |
|
| exec ($columns) |
|
| findInSet ($value, $set) |
|
| from ($table) |
|
| alias ($alias) |
|
| year ($date) |
|
| month ($date) |
|
| day ($date) |
|
| hour ($date) |
|
| minute ($date) |
|
| second ($date) |
|
| group ($columns) |
|
| having ($conditions, $glue='AND') |
|
| insert ($table, $incrementField=false) |
|
| join ($type, $table, $condition=null) |
|
| innerJoin ($table, $condition=null) |
|
| outerJoin ($table, $condition=null) |
|
| leftJoin ($table, $condition=null) |
|
| rightJoin ($table, $condition=null) |
|
| length ($value) |
|
| nullDate ($quoted=true) |
|
| isNullDatetime ($column) |
|
| order ($columns) |
|
| q ($text, $escape=true) |
|
| quote ($text, $escape=true) |
|
| qn ($name, $as=null) |
|
| quoteName ($name, $as=null) |
|
| rand () |
|
| regexp ($value) |
|
| select ($columns) |
|
| set ($conditions, $glue=',') |
|
| setLimit ($limit=0, $offset=0) |
|
| setQuery ($sql) |
|
| update ($table) |
|
| values ($values) |
|
| where ($conditions, $glue='AND') |
|
| whereIn (string $keyName, array $keyValues, $dataType=ParameterType::INTEGER) |
|
| whereNotIn (string $keyName, array $keyValues, $dataType=ParameterType::INTEGER) |
|
| extendWhere ($outerGlue, $conditions, $innerGlue='AND') |
|
| orWhere ($conditions, $glue='AND') |
|
| andWhere ($conditions, $glue='OR') |
|
| bind ($key, &$value, $dataType=ParameterType::STRING, $length=0, $driverOptions=[]) |
|
| unbind ($key) |
|
| bindArray (array $values, $dataType=ParameterType::INTEGER) |
|
| __clone () |
|
& | getBounded ($key=null) |
|
| union ($query, $distinct=true) |
|
| unionAll ($query) |
|
| querySet ($query) |
|
| toQuerySet () |
|
| format ($format) |
|
| selectRowNumber ($orderBy, $orderColumnAlias) |
|
| groupConcat ($expression, $separator=',') |
|
| processLimit ($query, $limit, $offset=0) |
|
| merge ($name, $query) |
|
| validateRowNumber ($orderBy, $orderColumnAlias) |
|
MySQLi Query Building Class.
- Depuis
- 1.0