DeleteStatement

MMO\pdo\statements · 1 symbol · generated 5 Oct 2026

class

DeleteStatement

DELETE FROM table [WHERE …] [ORDER BY …] [LIMIT …]

class MMO\pdo\statements\DeleteStatement extends MMO\pdo\statements\FilterStatement

Namespace: MMO\pdo\statements
Extends: FilterStatement

WARNING: with no filter this deletes every row. [`Table::delete`](https://mcp.mmoframework.fr/documentation/mmo.pdo/php/helpers/Table.md#table-delete) refuses that by default.

$handler->deleteStatement('user', ['id' => 3])->execute();

Index

	TABLE_KEY
	from($name)
	ignore($value)
	lowPriority($value)
	quick($value)
	__construct($handler, $table, $filter)

Constants1

TABLE_KEY

const TABLE_KEY = 'table'

Methods5

from($name)

DeleteStatement.php:38

function from(string $name): self

$name	string
returns	self

ignore($value)

DeleteStatement.php:53

function ignore(bool $value = true): self

$value = true	bool
returns	self

lowPriority($value)

DeleteStatement.php:45

function lowPriority(bool $value = true): self

$value = true	bool
returns	self

quick($value)

DeleteStatement.php:49

function quick(bool $value = true): self

$value = true	bool
returns	self

__construct($handler, $table, $filter)

DeleteStatement.php:29

function __construct( MMO\pdo\interfaces\iHandler $handler, ?string $table = null, MMO\core\interfaces\iFilter|array|string|null $filter = null )

$handler	iHandler
$table = null	null \| string
$filter = null	iFilter \| array \| string \| null

Inherited members (61)

Constants	Declared by	Description
`ALL_FLAG`	Statement
`CREATE_IF_NOT_EXISTS_FLAG`	Statement
`CREATE_TEMPORARY_FLAG`	Statement
`DELAYED_FLAG`	Statement
`DISTINCT_FLAG`	Statement
`DISTINCT_ROW_FLAG`	Statement
`HIGH_PRIORITY_FLAG`	Statement
`IF_EXISTS_FLAG`	Statement
`IGNORE_FLAG`	Statement
`LIMIT_KEY`	FilterStatement
`LOW_PRIORITY_FLAG`	Statement
`MAX_LIMIT`	FilterStatement
`ORDER_KEY`	FilterStatement
`QUICK_FLAG`	Statement
`STRAIGHT_JOIN_FLAG`	Statement
`WHERE_KEY`	FilterStatement	Reserved content keys for the trailing clauses this class appends to every template.

	Properties	Declared by	Description
	`content`	Statement
	`handler`	Statement
	`opts`	Statement
	`stmt`	Statement
	`template`	Statement

Methods	Declared by	Description
`addOptions($opts, $appendList)`	Statement	Merge $opts into the existing options (through `merge`), rather than replacing them wholesale like `setOptions`.
`bindValue($pdo, $index, $value, $type, $binds)`	Statement	Bind one already-emitted value onto the PDO statement.
`clear()`	Statement	Empty the underlying content, keeping the object itself.
`clearOptions()`	Statement	Empty the options bag.
`count()`	Statement	\Countable::count
`execute()`	Statement	Execute the query and set the current statement
`fetch($opt)`	Statement	Fetch the first row of the query's result
`fetchAll($clear)`	Statement	Fetch all the result of a query
`fetchAllObjects($class, $constructFirst, $args, $clear)`	Statement	Fetch all the result of a query as Objects.
`fetchObject($class, $constructFirst, $args)`	Statement	Fetch the result of a query as an Object.
`fetchValue($key)`	Statement	Fetch the column's value of the first row of the query's result and advance fetch pointer
`fetchValues($key)`	Statement	Fetch the column's value of all the row of the query's result
`flag($key, $flag, $set)`	Statement
`getFilter()`	FilterStatement
`getIterator()`	Statement	\IteratorAggregate::getIterator
`getOption($key, $default)`	Statement
`getOptions()`	Statement
`getPDOStatement()`	Statement
`getPlaceholders()`	Statement	Extract placeholder from template
`isEmpty()`	Statement
`jsonSerialize()`	Statement	\JsonSerializable::jsonSerialize -- the raw content is returned as-is (not recursively converted), so json_encode() relies on any nested iArray values being JsonSerializable themselves.
`keys()`	Statement
`limit($count, $offset)`	FilterStatement
`loadArray($data)`	Statement	Load every entry of a plain array into the content, through `offsetSet` (so any offsetSet() override defined by the class using this trait, e.g.
`offsetExists($key)`	Statement	\ArrayAccess::offsetExists
`offsetGet($key)`	Statement	\ArrayAccess::offsetGet
`offsetSet($key, $value)`	Statement	\ArrayAccess::offsetSet -- a null $key appends (`$bag[] = $value`), like a plain PHP array.
`offsetUnset($key)`	Statement	\ArrayAccess::offsetUnset -- on a list (sequential integer keys, as produced by `$bag[] = ...`), the element is spliced out (closing the gap and reindexing), matching \unset() semantics on a plain …
`order($fields)`	FilterStatement
`prepare($binds, $sql)`	Statement	Prepare a PDO statement by binding values.
`push($key, $fields)`	Statement
`render($opts)`	Statement
`reset()`	Statement
`rowCount()`	Statement
`setFilter($filter)`	FilterStatement
`setOption($key, $value)`	Statement	Set (or, with a null $value, remove) a single option.
`setOptions($opts)`	Statement	Replace the whole options bag.
`SplitType($key)`	Statement	Split a `column:type` key used by the INSERT/UPDATE value lists.
`toArray()`	Statement	Convert the content to a plain array, recursively converting any nested `iArray` value (e.g.
`__toString()`	Statement