PHP MySQL Delete Data

Delete Data From a MySQL Table Using MySQLi

We can use MySQLi and PDO to delete data from a MySQL table, here we learn using MySQLi .

With the DELETE statement, you can get rid of rows from a table:

DELETE FROM table_name
WHERE some_column = some_value

In the DELETE syntax, pay attention to the WHERE clause: The WHERE clause tells the program which record or records to delete. If you leave out the WHERE clause, all records will be deleted!

Visit our SQL tutorial to learn more about SQL.

Let’s look at the table “Student”:

The following examples delete the record with id=3 in the “student” table:

Example

<?php
$servername = “localhost”;
$username = “username”;
$password = “password”;
$dbname = “school”;

// Create connection
$link = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$link) {
die(“Connection failed: ” . mysqli_connect_error());
}

// sql to delete a record
$sql = “DELETE FROM student WHERE id=3”;

if (mysqli_query($link, $sql)) {
echo “Record deleted successfully”;
} else {
echo “Error deleting record: ” . mysqli_error($link);
}

mysqli_close($link);
?>

Output