PEAR Справочное руководство
Пред.		След.

->delete()

->delete() -- Delete items from table

Synopsis

int $DB_DataObject->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 DB_DATAOBJECT_WHEREADD_ONLY.

Параметр

boolean $use_where - use the whereAdd() conditions (by default, delete will only use primary keys)

Возвращаемое значение

int number of rows affected or FALSE on failure

Throws

Таблица 34-1. Возможные значения PEAR_Error

Error code	Error message	Meaning	Solution
DB_*	"*"	see PEAR::DB	see PEAR::DB
DB_DATAOBJECT_ERROR_NODATA	"delete: No Data specifed for query `$condition`"

Заметка

Эта функция не должна вызываться статически.

Пример

Пример 34-1. Simple Delete

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


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

Пример 34-2. 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

Пред.	Начало	След.
->update()	Уровень выше	Selecting Specific data (SELECT)

HIVE: All information for read only. Please respect copyright!