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 () | |
clear ($clause=null) | |
castAsChar ($value) | |
concatenate ($values, $separator=null) | |
currentTimestamp () | |
forUpdate ($table_name, $glue=',') | |
forShare ($table_name, $glue=',') | |
year ($date) | |
month ($date) | |
day ($date) | |
hour ($date) | |
minute ($date) | |
second ($date) | |
noWait () | |
limit ($limit=0) | |
offset ($offset=0) | |
returning ($pkCol) | |
setLimit ($limit=0, $offset=0) | |
processLimit ($query, $limit, $offset=0) | |
dateAdd ($date, $interval, $datePart) | |
regexp ($value) | |
Rand () | |
Fonctions membres publiques hérités de FOFDatabaseQuery | |
__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='') | |
Attributs protégés | |
$forUpdate = null | |
$forShare = null | |
$noWait = null | |
$limit = null | |
$offset = null | |
$returning = null | |
Attributs protégés hérités de FOFDatabaseQuery | |
$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 | |
Query Building Class.
__toString | ( | ) |
Magic function to convert the query to a string, only for postgresql specific query
Références $query.
castAsChar | ( | $value | ) |
Casts a value to a char.
Ensure that the value is properly quoted before passing to the method.
Usage: $query->select($query->castAsChar('a'));
string | $value | The value to cast as a char. |
Références $value.
clear | ( | $clause = null | ) |
Clear data from the query or a specific clause of the query.
string | $clause | Optionally, the name of the clause to clear, or nothing to clear the whole query. |
Références null.
concatenate | ( | $values, | |
$separator = null |
|||
) |
Concatenates an array of column names or values.
Usage: $query->select($query->concatenate(array('a', 'b')));
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 in Postgresql. 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 |
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.
day | ( | $date | ) |
Used to get a string to extract day from date column.
Usage: $query->select($query->day($query->quoteName('dateColumn')));
string | $date | Date column containing day to be extracted. |
Références $date.
forShare | ( | $table_name, | |
$glue = ',' |
|||
) |
Sets the FOR SHARE lock on select's output row
string | $table_name | The table to lock |
string | $glue | The glue by which to join the conditions. Defaults to ',' . |
forUpdate | ( | $table_name, | |
$glue = ',' |
|||
) |
Sets the FOR UPDATE lock on select's output row
string | $table_name | The table to lock |
string | $glue | The glue by which to join the conditions. Defaults to ',' . |
hour | ( | $date | ) |
Used to get a string to extract hour from date column.
Usage: $query->select($query->hour($query->quoteName('dateColumn')));
string | $date | Date column containing hour to be extracted. |
Références $date.
limit | ( | $limit = 0 | ) |
Set the LIMIT clause to the query
integer | $limit | An int of how many row will be returned |
Références $limit.
minute | ( | $date | ) |
Used to get a string to extract minute from date column.
Usage: $query->select($query->minute($query->quoteName('dateColumn')));
string | $date | Date column containing minute to be extracted. |
Références $date.
month | ( | $date | ) |
Used to get a string to extract month from date column.
Usage: $query->select($query->month($query->quoteName('dateColumn')));
string | $date | Date column containing month to be extracted. |
Références $date.
noWait | ( | ) |
Sets the NOWAIT lock on select's output row
Références null.
offset | ( | $offset = 0 | ) |
Set the OFFSET clause to the query
integer | $offset | An int for skipping row |
Références $offset.
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 Postgresql.
Ensure that the rand() function is Postgresql compatible.
Usage: $query->Rand();
regexp | ( | $value | ) |
Return correct regexp operator for Postgresql.
Ensure that the regexp operator is Postgresql compatible.
Usage: $query->where('field ' . $query->regexp($search));
string | $value | The regex pattern. |
Références $value.
returning | ( | $pkCol | ) |
Add the RETURNING element to INSERT INTO statement.
mixed | $pkCol | The name of the primary key column. |
second | ( | $date | ) |
Used to get a string to extract seconds from date column.
Usage: $query->select($query->second($query->quoteName('dateColumn')));
string | $date | Date column containing second to be extracted. |
Références $date.
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.
year | ( | $date | ) |
Used to get a string to extract year from date column.
Usage: $query->select($query->year($query->quoteName('dateColumn')));
string | $date | Date column containing year to be extracted. |
Références $date.