Implements interfaces:

• JDatabaseQueryLimitable

Query Building Class.

• since: 11.1

Located in /libraries/joomla/database/query/mysqli.php (line 19)

JDatabaseQuery
   |
   --JDatabaseQueryMysqli

integer $limit (line 31)

• var: The limit for the result set.
• since: 12.1
• access: protected

integer $offset (line 25)

• var: The offset for the result set.
• since: 12.1
• access: protected

Inherited Variables

Inherited from JDatabaseQuery

JDatabaseQuery::$autoIncrementField
JDatabaseQuery::$call
JDatabaseQuery::$columns
JDatabaseQuery::$db
JDatabaseQuery::$delete
JDatabaseQuery::$element
JDatabaseQuery::$exec
JDatabaseQuery::$from
JDatabaseQuery::$group
JDatabaseQuery::$having
JDatabaseQuery::$insert
JDatabaseQuery::$join
JDatabaseQuery::$order
JDatabaseQuery::$select
JDatabaseQuery::$set
JDatabaseQuery::$sql
JDatabaseQuery::$type
JDatabaseQuery::$union
JDatabaseQuery::$unionAll
JDatabaseQuery::$update
JDatabaseQuery::$values
JDatabaseQuery::$where

concatenate (line 66)

Concatenates an array of column names or values.

• return: The concatenated values.
• since: 11.1
• access: public

string concatenate (array $values, [string $separator = null])

• array $values: An array of values to concatenate.
• string $separator: As separator to place between each value.

---

Redefinition of:

JDatabaseQuery::concatenate()

Concatenates an array of column names or values.

processLimit (line 46)

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.

• since: 12.1
• access: public

string processLimit (string $query, integer $limit, [integer $offset = 0])

• string $query: The query in string format
• integer $limit: The limit for the result set
• integer $offset: The offset for the result set

---

Implementation of:

JDatabaseQueryLimitable::processLimit()

Method to modify a query already in string format with the needed

setLimit (line 99)

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)

• return: Returns this object to allow chaining.
• since: 12.1
• access: public

JDatabaseQuery setLimit ([integer $limit = 0], [integer $offset = 0])

• integer $limit: The limit for the result set
• integer $offset: The offset for the result set

---

Implementation of:

JDatabaseQueryLimitable::setLimit()

Sets the offset and limit for the result set, if the database driver supports it.

Inherited Methods

Inherited From JDatabaseQuery

JDatabaseQuery::__construct()
JDatabaseQuery::call()
JDatabaseQuery::castAsChar()
JDatabaseQuery::charLength()
JDatabaseQuery::clear()
JDatabaseQuery::columns()
JDatabaseQuery::concatenate()
JDatabaseQuery::currentTimestamp()
JDatabaseQuery::dateAdd()
JDatabaseQuery::dateFormat()
JDatabaseQuery::day()
JDatabaseQuery::delete()
JDatabaseQuery::dump()
JDatabaseQuery::escape()
JDatabaseQuery::exec()
JDatabaseQuery::format()
JDatabaseQuery::from()
JDatabaseQuery::group()
JDatabaseQuery::having()
JDatabaseQuery::hour()
JDatabaseQuery::innerJoin()
JDatabaseQuery::insert()
JDatabaseQuery::join()
JDatabaseQuery::leftJoin()
JDatabaseQuery::length()
JDatabaseQuery::minute()
JDatabaseQuery::month()
JDatabaseQuery::nullDate()
JDatabaseQuery::order()
JDatabaseQuery::outerJoin()
JDatabaseQuery::quote()
JDatabaseQuery::quoteName()
JDatabaseQuery::rightJoin()
JDatabaseQuery::second()
JDatabaseQuery::select()
JDatabaseQuery::set()
JDatabaseQuery::setQuery()
JDatabaseQuery::union()
JDatabaseQuery::unionAll()
JDatabaseQuery::unionDistinct()
JDatabaseQuery::update()
JDatabaseQuery::values()
JDatabaseQuery::where()
JDatabaseQuery::year()
JDatabaseQuery::__call()
JDatabaseQuery::__clone()
JDatabaseQuery::__get()
JDatabaseQuery::__toString()