Joomla CMS  3.8.5 (avec JPlatform 13.1 inclus)
Documentation des API du CMS Joomla en version 3.8.5 et du framework Joomla Platform intégré
Référence de la classe JDatabaseQueryOracle
+ Graphe d'héritage de JDatabaseQueryOracle:

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)
 

Description détaillée

Oracle Query Building Class.

Depuis
12.1

Documentation des fonctions membres

◆ bind()

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.

Paramètres
string | integer$keyThe 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&$valueThe value that will be bound. The value is passed by reference to support output parameters such as those possible with stored procedures.
integer$dataTypeConstant corresponding to a SQL datatype.
integer$lengthThe length of the variable. Usually required for OUTPUT parameters.
array$driverOptionsOptional driver options to be used.
Renvoie
JDatabaseQueryOracle
Depuis
12.1

Implémente JDatabaseQueryPreparable.

Références $key, et $value.

◆ clear()

clear (   $clause = null)

Clear data from the query or a specific clause of the query.

Paramètres
string$clauseOptionally, the name of the clause to clear, or nothing to clear the whole query.
Renvoie
JDatabaseQueryOracle Returns this object to allow chaining.
Depuis
12.1

Références null.

◆ getBounded()

& 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.

Paramètres
mixed$keyThe bounded variable key to retrieve.
Renvoie
mixed
Depuis
12.1

Implémente JDatabaseQueryPreparable.

Références $key.

◆ processLimit()

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.

Paramètres
string$queryThe query in string format
integer$limitThe limit for the result set
integer$offsetThe offset for the result set
Renvoie
string
Depuis
12.1

Implémente JDatabaseQueryLimitable.

Références $limit, $offset, et $query.

◆ setLimit()

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)

Paramètres
integer$limitThe limit for the result set
integer$offsetThe offset for the result set
Renvoie
JDatabaseQueryOracle Returns this object to allow chaining.
Depuis
12.1

Implémente JDatabaseQueryLimitable.

Références $limit, et $offset.

Documentation des champs

◆ $bounded

$bounded = array()
protected

◆ $limit

$limit
protected

◆ $offset

$offset
protected

La documentation de cette classe a été générée à partir du fichier suivant :