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) |
charLength ($field, $operator=null, $condition=null) | |
clear ($clause=null) | |
concatenate ($values, $separator=null) | |
processLimit ($query, $limit, $offset=0) | |
setLimit ($limit=0, $offset=0) | |
dateAdd ($date, $interval, $datePart) | |
currentTimestamp () | |
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 | |
$offset | |
$limit | |
$bounded = array() | |
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 | |
SQLite 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.
Gets the number of characters in a string.
Note, use 'length' to find the number of bytes in a string.
Usage: $query->select($query->charLength('a'));
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.
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.
Usage: $query->where('published_up < '.$query->currentTimestamp());
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 or datetime 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.
& 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 FOFDatabaseQueryLimitable 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 |