View source for Inserting, Updating and Removing data using JDatabase

=== Using an Object === <!--T:28-->
</translate>
<translate><!--T:29-->
Like ''insertObject'', the JDatabaseDriver class provides a convenient method for updating an object.</translate>

<translate><!--T:30-->
Below we will update our custom table with new values using an existing id primary key:</translate>

<syntaxhighlight lang="php">
$updateNulls = true;

// Create an object for the record we are going to update.
$object = new stdClass();

// Must be a valid primary key value.
$object->id = 1;
$object->title = 'My Custom Record';
$object->description = 'A custom record being updated in the database.';

// If you would like to store NULL value, you should specify that.
$object->short_description = null;

// Update their details in the users table using id as the primary key.
// You should provide forth parameter with value TRUE, if you would like to store the NULL values.
$result = JFactory::getDbo()->updateObject('#__custom_table', $object, 'id', $updateNulls);
</syntaxhighlight>

<translate><!--T:31-->
Just like insertObject, updateObject takes care of escaping table names for us.</translate>

<translate><!--T:32-->
The updateObject method will throw a error if there is a problem updating the record into the database table.</translate>

<translate><!--T:33-->
We need to ensure that the record already exists before attempting to update it, so we would probably add some kind of record check before executing the updateObject method.</translate>

<translate>