objSQL Helper Method: Delete
The obj_delete() helper method executes a delete statement with minimal SQL markup and is called from the objSQL class.
- The $table name is the only required argument.
- The optional $where argument allows you to limit which rows are deleted and only requires the column and its value. You can use any of the normal operators used in SQL statements:
- "location IN ('Athens','London')"
- "location='Valdosta' AND dept='IT'"
- "salary BETWEEN 20000 AND 40000"
- obj_delete() will delete all records from a database table if used without a where clause and steps should be taken in any script or program to utilize a confirmation before executing this method unless the intention is to delete all records.
Returns: Result resource/object or false on failure.
<?php
//usage: $dbh->obj_delete( $table, $where )
try
{
$rs = $dbh->obj_delete( "mytable", "dept='IT'" );
if ( $dbh->obj_error() )
throw new Exception( $dbh->obj_error_message() );
echo $rs->obj_affected_rows();
}
catch ( Exception $e )
{
//log error and/or redirect user to error page
}
?>