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é
Tout Structures de données Espaces de nommage Fichiers Fonctions Variables Pages
Référence de la classe JDatabaseQuerySqlite
+ Graphe d'héritage de JDatabaseQuerySqlite:

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 ()
 
 __toString ()
 
 selectRowNumber ($orderBy, $orderColumnAlias)
 
- 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

SQLite Query Building Class.

Depuis
3.0.0

Documentation des fonctions membres

◆ __toString()

__toString ( )

Magic function to convert the query to a string.

Renvoie
string The completed query.
Depuis
1.7.0

Références $fields, $key, $limit, $offset, $query, $value, et null.

◆ 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
JDatabaseQuerySqlite
Depuis
3.0.0

Implémente JDatabaseQueryPreparable.

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

◆ charLength()

charLength (   $field,
  $operator = null,
  $condition = null 
)

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'));

Paramètres
string$fieldA value.
string$operatorComparison operator between charLength integer value and $condition
string$conditionInteger value to compare charLength with.
Renvoie
string The required char length call.
Depuis
3.2.0

Références $condition, et $field.

◆ 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
JDatabaseQuerySqlite Returns this object to allow chaining.
Depuis
3.0.0

Références null.

◆ concatenate()

concatenate (   $values,
  $separator = null 
)

Concatenates an array of column names or values.

Usage: $query->select($query->concatenate(array('a', 'b')));

Paramètres
array$valuesAn array of values to concatenate.
string$separatorAs separator to place between each value.
Renvoie
string The concatenated values.
Depuis
1.7.0

Références $separator.

◆ currentTimestamp()

currentTimestamp ( )

Gets the current date and time.

Usage: $query->where('published_up < '.$query->currentTimestamp());

Renvoie
string
Depuis
3.4

◆ dateAdd()

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.

Paramètres
datetime$dateThe date or datetime to add to
string$intervalThe string representation of the appropriate number of units
string$datePartThe part of the date to perform the addition on
Renvoie
string The string with the appropriate sql for addition of dates
Depuis
3.2.0 http://www.sqlite.org/lang_datefunc.html

Références $date.

◆ 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
3.0.0

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
3.0.0

Implémente JDatabaseQueryLimitable.

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

◆ selectRowNumber()

selectRowNumber (   $orderBy,
  $orderColumnAlias 
)

Return the number of the current row.

Paramètres
string$orderByAn expression of ordering for window function.
string$orderColumnAliasAn alias for new ordering column.
Renvoie
JDatabaseQuery Returns this object to allow chaining.
Depuis
3.7.0
Exceptions
RuntimeException

◆ 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
JDatabaseQuerySqlite Returns this object to allow chaining.
Depuis
3.0.0

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 :