Delete

Purpose:

The delete method creates a delete query that will delete the requested rows from the database

Definition:

$this->delete($strTableName, $arrFields = [], $arrWhere = [], $arrJoins = []);

  • strTableName - (string) Table name to act on
  • arrFields - (array) optional list of fields to delete (used when including multiple tables)
  • arrWhere - (DBWhere|array:DBWhere) optional where clauses
  • arrJoins - (array) Optional 2-dimensional array to add other flags

Returns:

Integer

Returns the number of affected rows

Examples:

This will delete the row from the members table where the id = 1:

$this->delete("members", new DBWhere('field', 1));
// DELETE FROM members WHERE id = 1

You can also use join commands to delete rows from one table that are dependent upon another table:

$this->delete("members m", ['m.*'], [], [
    'joins' => ["JOIN department d ON d.member_id = m.id]
]);
// DELETE m.* FROM members m JOIN department d ON d.member_id = m.id