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

DataObject $original - if provided the update query will be built from the difference between the current and original dataobject.

Return value

int number of rows affected or FALSE on failure

Throws

Table 21-1. Possible PEAR_Error values

Error code	Error message	Meaning	Solution
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 21-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 21-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 21-3. Simple fetch and update

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

Example 21-4. Resulting SQL

SELECT * FROM person WHERE id = 12; UPDATE person SET removed=1 WHERE age > 21

Prev	Home	Next
->insert()	Up	->delete()

Who's Online
Guest Users: 9

Free Sample Chapters
	Deliver First Class Web Sites: 101 Essential Checklists Want to learn how to make your web sites usable and accessible? Want to ensure that your sites meet current best practice, without spending hours trawling through incomprehensible specifications and recommendations from dozens of different books, research papers, and web sites? Want to make sure that the sites you build are "right the first time," requiring no costly redevelopments?
More Sample Chapters

PHP General