Delete Data From Database Using Php/Mysql

Recent Posts

---

-> Installation of wamp server

->Wordpress Installation

-> Draggable Element

-> Leap Year Calculater

-> Age Calculator

Deleting data from database using php/MySql

In last tutorial we have seen about how to Fetch data from database using php and mysql. now we are going to discuss about how to Delete data from database using php/mysql.
Basically DELETE keyword is used to delete 1 or more than one records from the database.
we can delete entire database or a particular database by using where class. it,s necessary to use where clause to delete particular record.
if we want to delete particular record we use where clause :
Delete * from database wher name='name'.
if we want to delete table we need to use the below query :
Delete * from database.
.

Delete.php

---

<?php
/*
Database Connection
*/
$link = mysqli_connect("localhost", "demo1", "demo123", "demo");
// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
// Attempt delete query execution
$sql = "DELETE * FROM user WHERE first_name='venky'";
if(mysqli_query($link, $sql)){
echo "Records were deleted successfully.";
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
// Close connection
mysqli_close($link);
?>