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é
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 :