If you are displaying any data in the list. And you want to add a delete button to the list and when a user clicks on the delete button then the confirmation box should open. Data or record is deleted from the database only when the end user confirms.
In this tutorial, you will learn how to create a confirmation box and functionality to delete records from a database in PHP Mysql.
PHP MySQL Delete Record with Confirmation
Steps to delete record or data from MySQL database with confirmation in PHP MySQL:
- Step 1: Create the Database and Table
- Step 2: Create a Connection File
- Step 3: Display the Records and Add Delete Links
- Step 4: Create the Delete Confirmation PHP File
- Step 5: Test the Application
Step 1: Create the Database and Table
First of all, open your phpmyadmin and execute the following query to create database and table for your php project:
CREATE DATABAE DEMO;
CREATE TABLE users (
id INT(11) PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(50),
email VARCHAR(100),
phone VARCHAR(15)
);
Step 2: Create a Connection File
Now, you need to create database connection file, which is used to connect mysql database from your php project. So, Create a file named “connection.php” and add the following code to establish a connection with your MySQL database:
<?php
$host = 'localhost'; // MySQL server hostname
$db = 'mydatabase'; // Your database name
$user = 'root'; // MySQL username
$password = ''; // MySQL password
// Establish the database connection
$conn = mysqli_connect($host, $user, $password, $db);
// Check the connection
if (!$conn) {
die('Connection failed: ' . mysqli_connect_error());
}
?>
Step 3: Display the Records and Add Delete Links
Now, create PHP file, which is used to show records and delete buttons. So, create one file named “index.php”. And add the following code to it:
<?php include 'connection.php'; ?>
<!DOCTYPE html>
<html>
<head>
<title>Users List</title>
</head>
<body>
<?php
// Retrieve all records from the database
$query = "SELECT * FROM users";
$result = mysqli_query($conn, $query);
if (mysqli_num_rows($result) > 0) {
echo '<h2>Users List</h2>';
while ($row = mysqli_fetch_assoc($result)) {
echo '<p>Name: ' . $row['name'] . '</p>';
echo '<p>Email: ' . $row['email'] . '</p>';
echo '<a href="delete.php?id=' . $row['id'] . '">Delete</a>';
echo '<hr>';
}
} else {
echo 'No records found.';
}
?>
</body>
</html>
Step 4: Create the Delete Confirmation PHP File
Create a new PHP file, let’s name it “delete.php”. This file will contain the logic to delete a record from the database.
<?php include 'connection.php'; ?>
<!DOCTYPE html>
<html>
<head>
<title>Delete Record Confirmation</title>
</head>
<body>
<?php
// Check if a record ID is provided
if (isset($_GET['id'])) {
$id = $_GET['id'];
// Retrieve the record from the database
$query = "SELECT * FROM users WHERE id = $id";
$result = mysqli_query($conn, $query);
$row = mysqli_fetch_assoc($result);
// Display the record details and confirmation form
if ($row) {
echo '<h2>Are you sure you want to delete this record?</h2>';
echo '<p>Name: ' . $row['name'] . '</p>';
echo '<p>Email: ' . $row['email'] . '</p>';
echo '<form method="post" action="delete.php">';
echo '<input type="hidden" name="id" value="' . $id . '">';
echo '<input type="submit" name="confirm" value="Yes">';
echo '<a href="index.php">No</a>';
echo '</form>';
} else {
echo 'Record not found.';
}
} else {
echo 'Invalid record ID.';
}
// Handle the delete operation
if (isset($_POST['confirm'])) {
$id = $_POST['id'];
// Delete the record from the database
$query = "DELETE FROM users WHERE id = $id";
$result = mysqli_query($conn, $query);
if ($result) {
echo 'Record deleted successfully.';
} else {
echo 'Error deleting record: ' . mysqli_error($conn);
}
}
?>
</body>
</html>
Step 5: Test the Application
That’s it! Now, when you run the “index.php” file, it will display the records from the “users” table with a “Delete” link next to each record. Clicking on the “Delete” link will prompt a confirmation dialog. If you confirm the deletion, the record will be deleted from the database.
Please make sure to replace “your_username”, “your_password”, and “your_database” with your MySQL database credentials in both PHP files.
Conclusion
That’s it; you have learned how to delete records or data from MySQL database with confirmation in php mysql.
