PEAR Handbuch
ZurückNach vorne

Modifying the database

Modifying the database --  ::update(), ::insert(), ::delete(),

::update()

Updating the data.

boolean ::update ()

updates the database using the objects variables, returns TRUE on success

Beispiel 1. Simple fetch and update

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

This would execute the following SQL statements, both fetching and updating the database.

Beispiel 2. Resulting SQL 

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

To perform a general update on a table, use the WhereAdd() method

Beispiel 3. Simple fetch and updated

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

This would execute the following SQL statements, both fetching and updating the database.

Beispiel 4. Resulting SQL 

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

::insert()

Inserting data.

int ::insert ()

Inserts data into the database and returns the key/ID if any.

Beispiel 5. Simple insert 

$person = new DataObjects_Person;
$person->name='fred';
$id = $person->insert();

This would execute the following SQL statements, (It may also do sequences on some databases, it uses mysql_next_id on mysql)

Beispiel 6. Resulting SQL 

INSERT INTO person (name) VALUES ('fred');

::delete()

Deleting data.

::delete ([boolean UseWhere])

Deletes data from the database, either using primary key or based on a WhereAdd() method call. by default the delete will base it's query on the set variables, however if you wish to use the WhereAdd method you should set the UseWhere parameter to TRUE

Beispiel 7. Simple Delete 

$person = new DataObjects_Person;
$person->get(12);
$person->delete();


$person = new DataObjects_Person;
$person->whereAdd('age < 21');
$person->delete(TRUE);

This would execute the following SQL statements,

Beispiel 8. Resulting SQL 

SELECT * FROM person WHERE id=12
DELETE FROM person WHERE id=12 AND name='test' AND age=21
DELETE FROM person WHERE age < 21

ZurückZum AnfangNach vorne
Finding and fetchingNach obenAdvanced Filters