|
| __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 () |
|
| __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) |
|
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 | $query | The query in string format |
integer | $limit | The limit for the result set |
integer | $offset | The offset for the result set |
- Renvoie
- string
- Depuis
- 3.0.0
Implémente JDatabaseQueryLimitable.
Références $limit, $offset, $position, $query, et $total.
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 | $limit | The limit for the result set |
integer | $offset | The 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 |
( |
|
$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 | $string | Input 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.