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 JDatabaseQuerySqlsrv
+ Graphe d'héritage de JDatabaseQuerySqlsrv:

Fonctions membres publiques

 __toString ()
 
 castAsChar ($value, $len=null)
 
 charLength ($field, $operator=null, $condition=null)
 
 concatenate ($values, $separator=null)
 
 currentTimestamp ()
 
 length ($value)
 
 dateAdd ($date, $interval, $datePart)
 
 processLimit ($query, $limit, $offset=0)
 
 setLimit ($limit=0, $offset=0)
 
 Rand ()
 
- 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)
 

Fonctions membres protégées

 splitSqlExpression ($string)
 
 fixSelectAliases ()
 
 fixGroupColumns ($selectColumns)
 
- Fonctions membres protégées hérités de JDatabaseQuery
 validateRowNumber ($orderBy, $orderColumnAlias)
 

Attributs protégés

 $name_quotes = '`'
 
 $null_date = '1900-01-01 00:00:00'
 
 $limit = 0
 
 $offset = 0
 
- 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
 

Description détaillée

Query Building Class.

Depuis
1.7.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 $columns, $query, elseif, et null.

◆ castAsChar()

castAsChar (   $value,
  $len = null 
)

Casts a value to a char.

Ensure that the value is properly quoted before passing to the method.

Paramètres
string$valueThe value to cast as a char.
string$lenThe length of the char.
Renvoie
string Returns the cast value.
Depuis
1.7.0

Références $value.

◆ charLength()

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

Gets the function to determine the length of a character string.

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
1.7.0

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

◆ concatenate()

concatenate (   $values,
  $separator = null 
)

Concatenates an array of column names or values.

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.

Renvoie
string
Depuis
1.7.0

◆ 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 to add to; type may be time or datetime.
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
Note
Not all drivers support all units. for more information

Références $date.

◆ fixGroupColumns()

fixGroupColumns (   $selectColumns)
protected

Add missing columns names to GROUP BY clause.

Paramètres
array[]$selectColumns Array of columns from splitSqlExpression method.
Renvoie
JDatabaseQuery Returns this object to allow chaining.
Depuis
3.7.0

Références $i, $name, $type, et elseif.

◆ fixSelectAliases()

fixSelectAliases ( )
protected

Add required aliases to columns for select statement in subquery.

Renvoie
array[] Array of columns with added missing aliases.
Depuis
3.7.0

Références $columns, $i, et elseif.

◆ length()

length (   $value)

Get the length of a string in bytes.

Paramètres
string$valueThe string to measure.
Renvoie
integer
Depuis
1.7.0

Références $value.

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

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, $position, $query, et $total.

◆ Rand()

Rand ( )

Return correct rand() function for MSSQL.

Ensure that the rand() function is MSSQL compatible.

Usage: $query->Rand();

Renvoie
string The correct rand function.
Depuis
3.5

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

Implémente JDatabaseQueryLimitable.

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

◆ splitSqlExpression()

splitSqlExpression (   $string)
protected

Split a string of sql expression into an array of individual columns. Single line or line end comments and multi line comments are stripped off. Always return at least one column.

Paramètres
string$stringInput string of sql expression like select expression.
Renvoie
array[] The columns from the input string separated into an array.
Depuis
3.7.0

Références $columns, $current, $i, $n, $start, elseif, et null.

Documentation des champs

◆ $limit

$limit = 0
protected

◆ $name_quotes

$name_quotes = '`'
protected

◆ $null_date

$null_date = '1900-01-01 00:00:00'
protected

◆ $offset

$offset = 0
protected

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