Pdo::delete

Set delete query

Description

public self Pdo::delete( [ string $table = '' ] )

Builds a DELETE on $table with the condition set with setWhere. This removes the rows; for a soft delete (valid = 0) use Model::delete().

Pdo does not refuse a DELETE without a condition: without setWhere() every row is removed.

Arguments

Name	Data type	Default	Remarks
$table	string	''	Target table name

Example

Controller

$db = new \Fegg\Database\Pdo();

// Delete From "cms_news" Where news_id = ?
$db->setWhere('news_id = ?', 3)->delete('cms_news')->execute();
$deleted = $db->getAffectedRow();