DB::update (method)

Last updated: Tue, Oct 31, 2023 1:43 pm
Return to Knowledgebase


Update records in a specified database table.




# Parameter Data Type Required Description
1 $table string Yes Name of database table to update
2 $id int or arry Yes Unique identifiers of records to be updated. If array, it specifies a set of conditions for the update
3 $fields array Yes Associative array with field names as keys and values to be updated


Data Type Description of Returned Data
bool "true" if operations is successful; "false" if unsuccessful

Further Documentation:

1. The update method in the UserSpice class is used to update records in a specified database table.
2. It generates and executes an SQL UPDATE statement based on the provided table name, unique identifier (id), and field-value pairs to be updated.

// Updating a record in the 'users' table with ID 5

$fields = [
'username' => 'john_doe_updated',
'email' => 'john_doe_updated@example.com'
$result = $db->update('users', 5, $fields);

// Updating records based on specific conditions
$conditions = [
'role' => 'admin',
'active' => 1
$result = $db->update('users', $conditions, $fields);