|
| __toString () |
|
| castAsChar ($value) |
|
| charLength ($field, $operator=null, $condition=null) |
|
| concatenate ($values, $separator=null) |
|
| currentTimestamp () |
|
| length ($value) |
|
| dateAdd ($date, $interval, $datePart) |
|
| processLimit ($query, $limit, $offset=0) |
|
| setLimit ($limit=0, $offset=0) |
|
| Rand () |
|
| __call ($method, $args) |
|
| __construct (FOFDatabaseDriver $db=null) |
|
| __toString () |
|
| __get ($name) |
|
| call ($columns) |
|
| castAsChar ($value) |
|
| charLength ($field, $operator=null, $condition=null) |
|
| clear ($clause=null) |
|
| columns ($columns) |
|
| concatenate ($values, $separator=null) |
|
| currentTimestamp () |
|
| dateFormat () |
|
| dump () |
|
| delete ($table=null) |
|
| escape ($text, $extra=false) |
|
| exec ($columns) |
|
| from ($tables, $subQueryAlias=null) |
|
| year ($date) |
|
| month ($date) |
|
| day ($date) |
|
| hour ($date) |
|
| minute ($date) |
|
| second ($date) |
|
| group ($columns) |
|
| having ($conditions, $glue='AND') |
|
| innerJoin ($condition) |
|
| insert ($table, $incrementField=false) |
|
| join ($type, $conditions) |
|
| leftJoin ($condition) |
|
| length ($value) |
|
| nullDate ($quoted=true) |
|
| order ($columns) |
|
| outerJoin ($condition) |
|
| quote ($text, $escape=true) |
|
| quoteName ($name, $as=null) |
|
| rightJoin ($condition) |
|
| select ($columns) |
|
| set ($conditions, $glue=',') |
|
| setQuery ($sql) |
|
| update ($table) |
|
| values ($values) |
|
| where ($conditions, $glue='AND') |
|
| __clone () |
|
| union ($query, $distinct=false, $glue='') |
|
| unionDistinct ($query, $glue='') |
|
| format ($format) |
|
| dateAdd ($date, $interval, $datePart) |
|
| unionAll ($query, $distinct=false, $glue='') |
|
Query Building Class.
- Depuis
- 11.1
◆ __toString()
Magic function to convert the query to a string.
- Renvoie
- string The completed query.
- Depuis
- 11.1
Références $query, et elseif.
◆ castAsChar()
Casts a value to a char.
Ensure that the value is properly quoted before passing to the method.
- Paramètres
-
string | $value | The value to cast as a char. |
- Renvoie
- string Returns the cast value.
- Depuis
- 11.1
Références $value.
◆ charLength()
charLength |
( |
|
$field, |
|
|
|
$operator = null , |
|
|
|
$condition = null |
|
) |
| |
Gets the function to determine the length of a character string.
- Paramètres
-
string | $field | A value. |
string | $operator | Comparison operator between charLength integer value and $condition |
string | $condition | Integer value to compare charLength with. |
- Renvoie
- string The required char length call.
- Depuis
- 11.1
Références $condition, et $field.
◆ concatenate()
concatenate |
( |
|
$values, |
|
|
|
$separator = null |
|
) |
| |
Concatenates an array of column names or values.
- Paramètres
-
array | $values | An array of values to concatenate. |
string | $separator | As separator to place between each value. |
- Renvoie
- string The concatenated values.
- Depuis
- 11.1
Références $separator.
◆ currentTimestamp()
Gets the current date and time.
- Renvoie
- string
- Depuis
- 11.1
◆ dateAdd()
dateAdd |
( |
|
$date, |
|
|
|
$interval, |
|
|
|
$datePart |
|
) |
| |
Add to the current date and time. Usage: $query->select($query->dateAdd()); Prefixing the interval with a - (negative sign) will cause subtraction to be used.
- Paramètres
-
datetime | $date | The date to add to; type may be time or datetime. |
string | $interval | The string representation of the appropriate number of units |
string | $datePart | The part of the date to perform the addition on |
- Renvoie
- string The string with the appropriate sql for addition of dates
- Depuis
- 13.1
- Note
- Not all drivers support all units. for more information
Références $date.
◆ length()
Get the length of a string in bytes.
- Paramètres
-
string | $value | The string to measure. |
- Renvoie
- integer
- Depuis
- 11.1
Références $value.
◆ processLimit()
processLimit |
( |
|
$query, |
|
|
|
$limit, |
|
|
|
$offset = 0 |
|
) |
| |
Method to modify a query already in string format with the needed additions to make the query limited to a particular number of results, or start at a particular offset.
- Paramètres
-
string | $query | The query in string format |
integer | $limit | The limit for the result set |
integer | $offset | The offset for the result set |
- Renvoie
- string
- Depuis
- 12.1
Implémente JDatabaseQueryLimitable.
Références $limit, $offset, $query, et $start.
◆ Rand()
Return correct rand() function for MSSQL.
Ensure that the rand() function is MSSQL compatible.
Usage: $query->Rand();
- Renvoie
- string The correct rand function.
- Depuis
- 3.5
◆ setLimit()
setLimit |
( |
|
$limit = 0 , |
|
|
|
$offset = 0 |
|
) |
| |
Sets the offset and limit for the result set, if the database driver supports it.
Usage: $query->setLimit(100, 0); (retrieve 100 rows, starting at first record) $query->setLimit(50, 50); (retrieve 50 rows, starting at 50th record)
- Paramètres
-
integer | $limit | The limit for the result set |
integer | $offset | The offset for the result set |
- Renvoie
- FOFDatabaseQuery Returns this object to allow chaining.
- Depuis
- 12.1
Implémente JDatabaseQueryLimitable.
Références $limit, et $offset.
◆ $limit
◆ $name_quotes
◆ $null_date
$null_date = '1900-01-01 00:00:00' |
|
protected |
◆ $offset
La documentation de cette classe a été générée à partir du fichier suivant :