Graphe d'héritage de JDatabaseQueryLimitable:

Fonctions membres publiques
	processLimit ($query, $limit, $offset=0)

	setLimit ($limit=0, $offset=0)

Description détaillée

Joomla Database Query Limitable Interface. Adds bind/unbind methods as well as a getBounded() method to retrieve the stored bounded variables on demand prior to query execution.

Depuis: 3.0.0

Documentation des fonctions membres

◆ 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. This method is used automatically by the __toString() method if it detects that the query implements the JDatabaseQueryLimitable interface.

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émenté dans JDatabaseQueryPostgresql, FOFDatabaseQueryPostgresql, JDatabaseQuerySqlsrv, FOFDatabaseQuerySqlsrv, FOFDatabaseQuerySqlite, JDatabaseQuerySqlite, FOFDatabaseQueryOracle, JDatabaseQueryOracle, JDatabaseQueryMysqli, et FOFDatabaseQueryMysqli.

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