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) | |
processLimit ($query, $limit, $offset=0) | |
setLimit ($limit=0, $offset=0) | |
Fonctions membres publiques hérités de JDatabaseQueryPdo | |
castAsChar ($value, $len=null) | |
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 | |
$offset | |
$limit | |
$bounded = array() | |
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) | |
Oracle 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.
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. This method is used automatically by the __toString() method if it detects that the query implements the JDatabaseQueryLimitable interface.
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.
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 |
|
protected |
|
protected |