Login Register

CI_DB_query_builder::limit()

limit($value[, $offset = 0])

Parameters:	$value (int) – Number of rows to limit the results to $offset (int) – Number of rows to skip
Returns:	CI_DB_query_builder instance (method chaining)
Return type:	CI_DB_query_builder

Adds LIMIT and OFFSET clauses to a query.

Links:

http://www.codeigniter.com/user_guide/database/query_builder.html#CI_DB_query_builder::limit

doc_CodeIgniter

2025-01-10 15:47:30

Comments

Leave a Comment

Please login to continue.

Popular Articles

CI_DB_query_builder class CI_DB_query_builder reset_query() Returns: CI_DB_query_builder instance (method chaining) Return type: CI_DB_query_builder Resets the cur

CI_DB_query_builder::delete() delete([$table = ''[, $where = ''[, $limit = NULL[, $reset_data = TRUE]]]]) Parameters: $table (mixed) – The table(s) to delete from; string or

CI_DB_query_builder::select() select([$select = '*'[, $escape = NULL]]) Parameters: $select (string) – The SELECT portion of a query $escape (bool) – Whether to escape value

CI_DB_query_builder::set() set($key[, $value = ''[, $escape = NULL]]) Parameters: $key (mixed) – Field name, or an array of field/value pairs $value (string) – Field valu

CI_DB_query_builder::insert() insert([$table = ''[, $set = NULL[, $escape = NULL]]]) Parameters: $table (string) – Table name $set (array) – An associative array of field/va