Main (PHP)

Home Forums PHP News PHP Tutorials Articles PHP Code Snippets Contact Us Sysadmin Resources Books Template Shop

3rd Party Streams

SlashDot PHPDeveloper.org PHP.Net

Resources

PHP Manual MySQL Manual Smarty Manual PEAR Manual PHP-GTK Manual Symfony Manual

Code Snippets

Authentication Database Graphics HTTP Miscellaneous Time/Date

Affiliates

Scripts TutorialMan TutorialGuide CodingForums.com PHP Scripts Cheap Web Hosting Affordable Web Hosting Dreamweaver Templates

->update()

PEAR Manual
Prev		Next

->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

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 26-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 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

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

Print this page

Top Sponsor

$Symantec\'s Norton SystemWorks 2006$