<?php
// DB credentials.
define('DB_HOST','localhost');
define('DB_USER','root');
define('DB_PASS','');
define('DB_NAME','modaldb2');
// Establish database connection.
try
{
$dbh = new PDO("mysql:host=".DB_HOST.";dbname=".DB_NAME,DB_USER, DB_PASS,array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'"));
}
catch (PDOException $e)
{
exit("Error: " . $e->getMessage());
}
?>
index.php
<?php
session_start();
error_reporting(0);
include "config.php";
if(isset($_GET['del']))
{
$id=intval($_GET['del']);
$sql="delete from products where id=:cid";
$query2= $dbh->prepare($sql);
$query2->bindParam(':cid',$id,PDO::PARAM_STR);
$query2->execute();
if($query2->execute()) {
echo "<script>alert('product Deleted');</script>" ;
echo "<script>window.location.href ='index.php'</script>";
}else{
echo "<script>alert('Failed try again later.');</script>" ;
}
}
?>
<!DOCTYPE HTML>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<title>How to delete Mysql data in php</title>
<!--Bootstrap -->
<link rel="stylesheet" href="css/bootstrap.css" type="text/css">
<link rel="stylesheet" href="css/bootstrap.min.css" type="text/css">
</head>
<body>
<div class="container">
<h3>How to delete Mysql data in php</h3>
<div class=" d-flex flex-row align-items-center justify-content-between">
<h6 class="m-0 font-weight-bold text-primary">Add product</h6>
<div class="card-tools" style="float: right;">
<button type="button" class="btn btn-sm btn-primary" data-toggle="modal" data-target="#deposit" ><i class="fas fa-plus" ></i> Add Product
</button>
</div>
</div>
<div> </div>
<div class="row ">
<table id="" class="table table-bordered">
<thead>
<tr>
<th class="text-center">No</th>
<th>Product Name</th>
<th class="text-center"> Product Category</th>
<th class="text-center">Product Price</th>
<th class="text-center">Posting Date</th>
<th class=" text-center">Action</th>
</tr>
</thead>
<tbody>
<?php
$sql="SELECT * from products ORDER BY id DESC";
$query = $dbh -> prepare($sql);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query->rowCount() > 0)
{
foreach($results as $row)
{
?>
<tr>
<td class="text-center"><?php echo htmlentities($cnt);?></td>
<td><?php echo htmlentities($row->ProductName);?></td>
<td class="text-center"><?php echo htmlentities($row->CategoryName);?></td>
<td class="text-center"><?php echo htmlentities($row->ProductPrice);?></td>
<td class="text-center"><?php echo htmlentities(date("d-m-Y", strtotime($row->PostingDate)));?></td>
<td class=" text-center">
<a href="index.php?del=<?php echo $row->id;?>" class=" btn btn-sm btn-danger" data-toggle="tooltip" data-original-title="Delete" onclick="return confirm('Do you really want to delete?');"> Delete </a>
</td>
</tr>
<?php
$cnt=$cnt+1;
}
} ?>
</tbody>
</table>
</div>
</div>
<!-- Loading Scripts -->
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.min.js"></script>
</body>
</html>
Download
