Class JDatabaseQueryMysqli

Query Building Class.

JDatabaseQueryMysqli implements JDatabaseQueryLimitable

Direct known subclasses

JDatabaseQueryMysql, JDatabaseQueryPdomysql

Package: Joomla\Platform\Database
Copyright: Copyright (C) 2005 - 2017 Open Source Matters, Inc. All rights reserved.
License: General Public License version 2 or later; see LICENSE
Since: 11.1
Located at joomla/database/query/mysqli.php

Methods summary

`public string`	# `__toString( )` Magic function to convert the query to a string. Magic function to convert the query to a string. Returns `string` - The completed query. Since 11.1 Overrides `JDatabaseQuery::__toString`
`public string`	# `processLimit( string $query, integer $limit, integer $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. 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. Parameters `$query` `string` - $query The query in string format `$limit` `integer` - $limit The limit for the result set `$offset` `integer` - $offset The offset for the result set Returns `string` Since 12.1
`public string`	# `concatenate( array $values, string $separator = null )` Concatenates an array of column names or values. Concatenates an array of column names or values. Parameters `$values` `array` - $values An array of values to concatenate. `$separator` `string` - $separator As separator to place between each value. Returns `string` - The concatenated values. Since 11.1 Overrides `JDatabaseQuery::concatenate`
`public JDatabaseQuery`	# `setLimit( integer $limit = 0, integer $offset = 0 )` Sets the offset and limit for the result set, if the database driver supports it. 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) Parameters `$limit` `integer` - $limit The limit for the result set `$offset` `integer` - $offset The offset for the result set Returns `JDatabaseQuery` - Returns this object to allow chaining. Since 12.1
`public string`	# `regexp( string $value )` Return correct regexp operator for mysqli. Return correct regexp operator for mysqli. Ensure that the regexp operator is mysqli compatible. Usage: $query->where('field ' . $query->regexp($search)); Parameters `$value` `string` - $value The regex pattern. Returns `string` - Returns the regex operator. Since 11.3
`public string`	# `Rand( )` Return correct rand() function for Mysql. Return correct rand() function for Mysql. Ensure that the rand() function is Mysql compatible. Usage: $query->Rand(); Returns `string` - The correct rand function. Since 3.5
`public JDatabaseQuery`	# `selectRowNumber( string $orderBy, string $orderColumnAlias )` Return the number of the current row. Return the number of the current row. Parameters `$orderBy` `string` - $orderBy An expression of ordering for window function. `$orderColumnAlias` `string` - $orderColumnAlias An alias for new ordering column. Returns `JDatabaseQuery` - Returns this object to allow chaining. Throws `RuntimeException` Since 3.7.0 Overrides `JDatabaseQuery::selectRowNumber`
`public string`	# `castAsChar( string $value, string $len = null )` Casts a value to a char. Casts a value to a char. Ensure that the value is properly quoted before passing to the method. Usage: $query->select($query->castAsChar('a')); $query->select($query->castAsChar('a', 40)); Parameters `$value` `string` - $value The value to cast as a char. `$len` `string` - $len The lenght of the char. Returns `string` - Returns the cast value. Since 3.7.0 Overrides `JDatabaseQuery::castAsChar`

Methods inherited from JDatabaseQuery

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

Magic methods summary

Magic methods inherited from JDatabaseQuery

e(), q(), qn()

Properties summary

`protected integer`	`$offset`	# The offset for the result set. The offset for the result set. Since 12.1
`protected integer`	`$limit`	# The limit for the result set. The limit for the result set. Since 12.1

Properties inherited from JDatabaseQuery

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

Magic properties inherited from JDatabaseQuery

$group, $having, $select, $type

Namespaces

Classes

Interfaces

Exceptions

Constants

Functions

Class JDatabaseQueryMysqli

Direct known subclasses

Methods summary

Returns

Since

Overrides

Parameters

Returns

Since

Parameters

Returns

Since

Overrides

Parameters

Returns

Since

Parameters

Returns

Since

Returns

Since

Parameters

Returns

Throws

Since

Overrides

Parameters

Returns

Since

Overrides

Methods inherited from JDatabaseQuery

Magic methods summary

Magic methods inherited from JDatabaseQuery

Properties summary

Since

Since

Properties inherited from JDatabaseQuery

Magic properties inherited from JDatabaseQuery