Namespaces

Composer
- Autoload
Joomla
- Application
  - Cli
    - Output
      - Processor
  - Web
- Data
- DI
  - Exception
- Event
- Filter
- Input
- Ldap
- Registry
  - Format
- Session
  - Storage
- String
- Uri
- Utilities
None
PasswordCompat
- binary
PHP
Psr
- Log
Symfony
- Component
  - Yaml
    - Exception
- Polyfill
  - Util

Classes

Interfaces

Exceptions

Constants

Functions

Class FOFDatabaseQueryMysqli

Query Building Class.

FOFDatabaseQuery

Extended by

FOFDatabaseQueryMysqli implements FOFDatabaseQueryLimitable

Direct known subclasses

FOFDatabaseQueryMysql, FOFDatabaseQueryPdomysql

Package: FrameworkOnFramework\database
Copyright: Copyright (C) 2010-2016 Nicholas K. Dionysopoulos / Akeeba Ltd. All rights reserved.
License: General Public License version 2 or later; see LICENSE.txt This file is adapted from the Joomla! Platform. It is used to iterate a database cursor returning FOFTable objects instead of plain stdClass objects
Since: 11.1
Located at fof/database/query/mysqli.php

Methods summary

`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 `FOFDatabaseQuery::concatenate`
`public FOFDatabaseQuery`	# `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 `FOFDatabaseQuery` - 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

Methods inherited from FOFDatabaseQuery

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

Magic methods summary

Magic methods inherited from FOFDatabaseQuery

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 FOFDatabaseQuery

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

Magic properties inherited from FOFDatabaseQuery

$group, $having, $select, $type