Joomla CMS  3.8.5 (avec JPlatform 13.1 inclus)
Documentation des API du CMS Joomla en version 3.8.5 et du framework Joomla Platform intégré
Référence de l'interface JDatabaseQueryLimitable
+ 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
12.1

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$queryThe query in string format
integer$limitThe limit for the result set
integer$offsetThe offset for the result set
Renvoie
string
Depuis
12.1

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)

Paramètres
integer$limitThe limit for the result set
integer$offsetThe offset for the result set
Renvoie
JDatabaseQuery Returns this object to allow chaining.
Depuis
12.1

Implémenté dans JDatabaseQueryPostgresql, FOFDatabaseQueryPostgresql, JDatabaseQuerySqlsrv, FOFDatabaseQuerySqlsrv, FOFDatabaseQuerySqlite, JDatabaseQuerySqlite, FOFDatabaseQueryOracle, JDatabaseQueryOracle, JDatabaseQueryMysqli, et FOFDatabaseQueryMysqli.


La documentation de cette interface a été générée à partir du fichier suivant :