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 | |
bind ($key=null, &$value=null, $dataType=PDO::PARAM_STR, $length=0, $driverOptions=array()) | |
& | getBounded ($key=null) |
clear ($clause=null) | |
Fonctions membres publiques hérités de JDatabaseQueryPostgresql | |
__toString () | |
clear ($clause=null) | |
castAsChar ($value, $len=null) | |
concatenate ($values, $separator=null) | |
currentTimestamp () | |
forUpdate ($tableName, $glue=',') | |
forShare ($tableName, $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 () | |
selectRowNumber ($orderBy, $orderColumnAlias) | |
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) | |
Attributs protégés | |
$bounded = array() | |
Attributs protégés hérités de JDatabaseQueryPostgresql | |
$forUpdate = null | |
$forShare = null | |
$noWait = null | |
$limit = null | |
$offset = null | |
$returning = null | |
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 | |
Membres hérités additionnels | |
Fonctions membres protégées hérités de JDatabaseQuery | |
validateRowNumber ($orderBy, $orderColumnAlias) | |
PDO PostgreSQL Query Building Class.
bind | ( | $key = null , |
|
& | $value = null , |
||
$dataType = PDO::PARAM_STR , |
|||
$length = 0 , |
|||
$driverOptions = array() |
|||
) |
Method to add a variable to an internal array that will be bound to a prepared SQL statement before query execution. Also removes a variable that has been bounded from the internal bounded array when the passed in value is null.
string | integer | $key | The key that will be used in your SQL query to reference the value. Usually of the form ':key', but can also be an integer. |
mixed | &$value | The value that will be bound. The value is passed by reference to support output parameters such as those possible with stored procedures. |
integer | $dataType | Constant corresponding to a SQL datatype. |
integer | $length | The length of the variable. Usually required for OUTPUT parameters. |
array | $driverOptions | Optional driver options to be used. |
Implémente JDatabaseQueryPreparable.
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.
& getBounded | ( | $key = null | ) |
Retrieves the bound parameters array when key is null and returns it by reference. If a key is provided then that item is returned.
mixed | $key | The bounded variable key to retrieve. |
Implémente JDatabaseQueryPreparable.
Références $key.
|
protected |