->delete() -- Delete items from table
Beschreibung
Deletes data from the database, either using primary key or based on a
whereAdd() method call.
By default the delete will base its query on the set variables,
however if you wish to use the
whereAdd()
method you should set the $useWhere parameter to DB_DATAOBJECT_WHEREADD_ONLY.
Rückgabewert
int number of rows affected or FALSE on failure
Hinweise
Diese Methode kann nicht
statisch aufgerufen werden.
Beispiel
Beispiel 39-1. Simple Delete
<?php
$person = new DataObjects_Person;
$person->get(12);
$person->delete();
$person = new DataObjects_Person;
$person->name = 'test';
$person->age = 21;
$person->delete();
$person = new DataObjects_Person;
$person->whereAdd('age < 21');
$person->delete(DB_DATAOBJECT_WHEREADD_ONLY);
?>
|
|
Beispiel 39-2. Resulting SQL
<?php
SELECT * FROM person WHERE person.id = 12
DELETE FROM person WHERE ( person.id = 12 )
DELETE FROM person WHERE ( person.name = 'test' ) AND ( person.age = 21 )
DELETE FROM person WHERE ( age < 21 )
?>
|
|
