PEAR Manual
PrevNext

->update()

->update() -- Update objects variables into database

Synopsis

int $DB_DataObject->update ([dataobject $original])

Description

Updates current objects variables into the database. if you supply it with a dataObject, as an argument, it will only update the differences between the new and old.

Parameter

Return value

int number of rows affected or FALSE on failure

Throws

Table 26-1. Possible PEAR_Error values

Error codeError messageMeaningSolution
DB_DATAOBJECT_ERROR_INVALIDCONFIG"update:No table definition for $table"  
DB_DATAOBJECT_ERROR_NODATA"update: No Data specifed for query $settings"  

Note

This function can not be called statically.

Example

Example 26-1. Simple fetch and update

$person = new DataObjects_Person;
$person->get(12);
$person->name='fred';
$person->update();     

$person = new DataObjects_Person;
$person->get(12);
$original = $person; // clone or copy 
$person->name='fred';
$person->update($original);

Example 26-2. Resulting SQL

SELECT * FROM person WHERE id = 12
UPDATE person SET name='fred', age='21', eyes='blue' WHERE id = 12

SELECT * FROM person WHERE id = 12
UPDATE person SET name='fred'  WHERE id = 12

Example 26-3. Simple fetch and update

$person = new DataObjects_Person;
$person->removed=1;
$person->whereAdd('age > 21');
$person->update();

Example 26-4. Resulting SQL

SELECT * FROM person WHERE id = 12;
UPDATE person SET removed=1 WHERE age > 21
PrevHomeNext
->insert()Up->delete()