Query_Builder_Delete class
(extends Query_Builder_Where)
The Query_Builder_Delete class handles all the delete operations for the query building process. It extends the
Query_Builder_Where class, so all the methods are inherited.
Methods
table($table)
The table method sets/changes the table to delete from.
| Static |
No |
| Parameters |
| Param |
Type |
Default |
Description |
| $table |
string |
required |
the table name |
|
| Returns |
Returns the current instance. |
| Example |
// prepare an update statement
$query = DB::delete('users');
// Set the table to delete from
$query->table('admins');
// DELETE `admins` ...
|
compile(\Database_Connection$db)
The compile method returns the delete SQL query as a string.
| Static |
No |
| Parameters |
| Param |
Type |
Default |
Description |
| $db |
object |
required |
A database connection |
|
| Returns |
Returns the SQL query as a string. |
| Example |
// prepare an update statement
$query = DB::delete('users');
// Set a where statement
$query->where('looks', 'like', '%spammer%');
// Get the database connection
$connection = Database_Connection::instance();
// Get the sql query
$sql = $query->compile($connection);
// DELETE FROM `users` WHERE `looks` LIKE "%spammer%"
|
reset()
The reset method resets all values of the current instance.
| Static |
No |
| Parameters |
None
|
| Returns |
Returns the current instance. |
| Example |
// prepare an update statement
$query = DB:delete('users');
// Set a where statement
$query->where('it_look', 'ok to me');
// Reset it
$query->reset();
// Just an other where statement
$query->where('looks', 'like', '%bad mister%');
// Get the database connection
$connection = Database_Connection::instance();
// Get the sql query
$sql = $query->compile($connection);
// DELETE FROM `users` WHERE `looks` LIKE "%bad mister%"
|