PHP/MySQL Database/Database Delete
Delete data from database by ID
<source lang="html4strict">
<html> <body> <?php $cnx = mysql_connect("mysql153.secureserver.net","wbex","password"); mysql_select_db("wbex"); $id = "1"; $ok1 = @mysql_query("DELETE FROM Employee WHERE ID="$id""); if ($ok1) {
echo("Author deleted successfully!
");} else {
echo("Error deleting author from database!
".
"Error: " . mysql_error() . "
} ?> </body> </html>
</source>
Delete data from database table
<source lang="html4strict">
<?php
mysql_connect("mysql153.secureserver.net","wbex","password");
mysql_select_db("wbex");
$rowID = "001";
$query = "DELETE FROM Employee WHERE ID="$rowID"";
$result = mysql_query($query);
if ((mysql_affected_rows() == 0) || mysql_affected_rows() == -1) {
echo "There was a problem deleting some of the selected items.
";exit; }
?>
</source>
