echo "You must setup your database settings. Change the defines DB_HOST, DB_NAME, DB_USER and DB_PASS\n";
exit;
}
/*
* DeleteQuery
* Desc: Delete data from the database.
* Parms:
* $tableName - database table name.
* $where - SQL Where clause to specify which row(s) to delete.
* $debug - If true then return SQL query without executing.
* Returns:
* Nothing on success.
* Error String on failure.
*/
Function DeleteQuery ($tableName, $where="", $debug=false)
{
$db = mysql_connect(DB_HOST, DB_USER, DB_PASS);
if ($db == false){
return mysql_errno().": ".mysql_error()."<br>";
}
// Delete a row from the specified table.
if (!empty($where)){
if (!strstr(strtolower($where),"where ")) $where = "where $where";
}
$query = "delete from $tableName $where";
if ($debug){
@mysql_close($db);
return $query;
}
$stmt = mysql_db_query (DB_NAME, $query, $db);
if (!$stmt){
$error = mysql_error ($db);
}
@mysql_free_result ($stmt);
@mysql_close($db);
return $error;
}
?>
PHP Code:
<?php
// Sample call to new delete function.
$error = DeleteQuery ("employee", "where name='Kris'");
if (!empty($error)){