Joomla CMS
3.10.11 (avec JPlatform 13.1 inclus)
Documentation des API du CMS Joomla en version 3.10.11 et du framework Joomla Platform intégré
|
Fonctions membres publiques | |
__toString () | |
castAsChar ($value, $len=null) | |
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 () | |
Fonctions membres publiques hérités de JDatabaseQuery | |
__call ($method, $args) | |
__construct (JDatabaseDriver $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') | |
extendWhere ($outerGlue, $conditions, $innerGlue='AND') | |
orWhere ($conditions, $glue='AND') | |
andWhere ($conditions, $glue='OR') | |
__clone () | |
union ($query, $distinct=false, $glue='') | |
unionDistinct ($query, $glue='') | |
format ($format) | |
dateAdd ($date, $interval, $datePart) | |
unionAll ($query, $distinct=false, $glue='') | |
selectRowNumber ($orderBy, $orderColumnAlias) | |
Fonctions membres protégées | |
splitSqlExpression ($string) | |
fixSelectAliases () | |
fixGroupColumns ($selectColumns) | |
Fonctions membres protégées hérités de JDatabaseQuery | |
validateRowNumber ($orderBy, $orderColumnAlias) | |
Attributs protégés | |
$name_quotes = '`' | |
$null_date = '1900-01-01 00:00:00' | |
$limit = 0 | |
$offset = 0 | |
Attributs protégés hérités de JDatabaseQuery | |
$db = null | |
$sql = null | |
$type = '' | |
$element = null | |
$select = null | |
$delete = null | |
$update = null | |
$insert = null | |
$from = null | |
$join = null | |
$set = null | |
$where = null | |
$group = null | |
$having = null | |
$columns = null | |
$values = null | |
$order = null | |
$autoIncrementField = null | |
$call = null | |
$exec = null | |
$union = null | |
$unionAll = null | |
$selectRowNumber = null | |
Query Building Class.
__toString | ( | ) |
castAsChar | ( | $value, | |
$len = null |
|||
) |
Casts a value to a char.
Ensure that the value is properly quoted before passing to the method.
string | $value | The value to cast as a char. |
string | $len | The length of the char. |
Références $value.
Gets the function to determine the length of a character string.
string | $field | A value. |
string | $operator | Comparison operator between charLength integer value and $condition |
string | $condition | Integer value to compare charLength with. |
Références $condition, et $field.
concatenate | ( | $values, | |
$separator = null |
|||
) |
Concatenates an array of column names or values.
array | $values | An array of values to concatenate. |
string | $separator | As separator to place between each value. |
Références $separator.
currentTimestamp | ( | ) |
Gets the current date and time.
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.
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 |
Références $date.
|
protected |
Add missing columns names to GROUP BY clause.
array[] | $selectColumns Array of columns from splitSqlExpression method. |
|
protected |
length | ( | $value | ) |
Get the length of a string in bytes.
string | $value | The string to measure. |
Références $value.
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.
string | $query | The query in string format |
integer | $limit | The limit for the result set |
integer | $offset | The offset for the result set |
Implémente JDatabaseQueryLimitable.
Rand | ( | ) |
Return correct rand() function for MSSQL.
Ensure that the rand() function is MSSQL compatible.
Usage: $query->Rand();
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)
integer | $limit | The limit for the result set |
integer | $offset | The offset for the result set |
Implémente JDatabaseQueryLimitable.
|
protected |
Split a string of sql expression into an array of individual columns. Single line or line end comments and multi line comments are stripped off. Always return at least one column.
string | $string | Input string of sql expression like select expression. |
Références $columns, $current, $i, $n, $start, elseif, et null.
|
protected |
|
protected |
|
protected |
|
protected |