Login Register

CI_DB_query_builder::update_batch()

update_batch($table[, $set = NULL[, $value = NULL[, $batch_size = 100]]])

Parameters:	$table (string) – Table name $set (array) – Field name, or an associative array of field/value pairs $value (string) – Field value, if $set is a single field $batch_size (int) – Count of conditions to group in a single query
Returns:	Number of rows updated or FALSE on failure
Return type:	mixed

Compiles and executes batch UPDATE statements.

Note

When more than $batch_size field/value pairs are provided, multiple queries will be executed, each handling up to $batch_size field/value pairs.

Links:

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

doc_CodeIgniter

2016-10-15 16:31:23

Comments

Leave a Comment

Please login to continue.

Popular Articles

CI_DB_query_builder::update() update([$table = ''[, $set = NULL[, $where = NULL[, $limit = NULL]]]]) Parameters: $table (string) – Table name $set (array) – An associative a

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

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::limit() limit($value[, $offset = 0]) Parameters: $value (int) – Number of rows to limit the results to $offset (int) – Number of rows to skip Returns: