Delete Data in SQL Database using PHP

In my last three posts i covers the topics that how to create connection insert data and then if we want to update that data so then how to update data in in sql database table using php.

For step by step learning see my privies posts on database and php.

---

Create-table-in-sql Database

Create-primary-key-in-sql-table

Create-connection-with-sql-database-in-PHP

Insert-data-in-sql-database-using-php

Up-Date-data-in-sql-database-using-php

---

Today in this post we delete a record from login table we take a form inputs from user where he gave us the name and password of the user which he want to delete.

---

<?php

include "conn.php";

$user = $_POST['user'];

$pass = $_POST['password'];

$sql = "DELETE from login 

        where user='".$user."' and PASSWORD='".$pass."' ";

if ($conn->query($sql) === TRUE) {

    echo "Record Deleted successfully";

} else {

    echo "Error: " . $sql . "<br>" . $conn->error;

}

$conn->close();

?>