How to Delete Multiple Records from Database using PHP

-

In this article, you will learn How to Delete Multiple Records from Database using PHP.

Example:-

CREATE TABLE `users` ( `id` int(10) NOT NULL, `name` varchar(140) DEFAULT NULL, `education` varchar(120) DEFAULT NULL, `doj` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; ALTER TABLE `users` ADD PRIMARY KEY (`id`); ALTER TABLE `users` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

Fetch data from the database and create a checkbox .

<html> <head> <title>Delete Multiple Records</title> </head> <body> <form name="multipledeletion" method="post"> <div class="container"> <div class="row col-md-6 col-md-offset-2 custyle"> <h2>How to Delete Multiple Records from Database using PHP</h2> <!-- Message --> <p style="color:red; font-size:16px;"> <?php if($errmsg){ echo $errmsg; } ?> </p> <table class="table table-striped custab"> <!-- Deletion Button --> <tr> <td colspan="4"> <input type="submit" name="submit" value="Delete" class="btn btn-primary btn-md pull-left" onClick="return confirm('Are you sure you want to delete?');" ></td> </tr> <tr> <th> <!-- For Selecting All --> <li><input type="checkbox" id="select_all" /> Select all</li></th> <th>Name</th> <th>Education </th> <th>Date</th> </tr> <?php $query=mysqli_query($con,"select * from users"); $totalcnt = mysqli_num_rows($query); if ($totalcnt > 0) { while ($row=mysqli_fetch_array($query)) { ?> <tr> <td><input type="checkbox" class="checkbox" name="ids[]" value="<?php echo htmlentities($row['id']);?>"/></td> <td><?php echo htmlentities($row['name']);?></td> <td><?php echo htmlentities($row['education']);?></td> <td><?php echo htmlentities($row['doj']);?></td> </tr> <?php } } else { ?> <tr> <td colspan="4"> No Record Found</td> </tr> <?php } ?> </table> </div> </div> </form> </body> </html>

Code of Submit

if (isset($_POST["submit"])) { if (count($_POST["ids"]) > 0 ) { $all = implode(",", $_POST["ids"]); $sql =mysqli_query($con,"DELETE FROM users WHERE id in ($all)"); if ($sql) { $errmsg ="Data has been deleted successfully"; } else { $errmsg ="Error while deleting. Please Try again."; } } else { $errmsg = "You need to select atleast one checkbox to delete!"; } }

Complete Code

<?php include('dbconfig.php'); error_reporting(0); if (isset($_POST["submit"])) { if (count($_POST["ids"]) > 0 ) { // Imploding checkbox ids $all = implode(",", $_POST["ids"]); $sql =mysqli_query($con,"DELETE FROM users WHERE id in ($all)"); if ($sql) { $errmsg ="Data has been deleted successfully"; } else { $errmsg ="Error while deleting. Please Try again."; } } else { $errmsg = "You need to select atleast one checkbox to delete!"; } } ?> <!DOCTYPE html> <html> <head> <meta name="author" content="Anuj Kumar"> <title>How to Delete Multiple Records from Database using PHP</title> <link href="//netdna.bootstrapcdn.com/bootstrap/3.0.0/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css"> <script src="//netdna.bootstrapcdn.com/bootstrap/3.0.0/js/bootstrap.min.js"></script> <script src="//code.jquery.com/jquery-1.11.1.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script> <style type="text/css"> .custab{ border: 1px solid #ccc; padding: 5px; margin: 5% 0; box-shadow: 3px 3px 2px #ccc; transition: 0.5s; } .custab:hover{ box-shadow: 3px 3px 0px transparent; transition: 0.5s; } li { list-style-type: none; } </style> </head> <body> <form name="multipledeletion" method="post"> <div class="container"> <div class="row col-md-6 col-md-offset-2 custyle"> <h2>How to Delete Multiple Records from Database using PHP</h2> <!-- Message --> <p style="color:red; font-size:16px;"> <?php if($errmsg){ echo $errmsg; } ?> </p> <table class="table table-striped custab"> <!-- Deletion Button --> <tr> <td colspan="4"> <input type="submit" name="submit" value="Delete" class="btn btn-primary btn-md pull-left" onClick="return confirm('Are you sure you want to delete?');" ></td> </tr> <tr> <th> <!-- For Selecting All --> <li><input type="checkbox" id="select_all" /> Select all</li></th> <th>Name</th> <th>Education </th> <th>Date</th> </tr> <?php $query=mysqli_query($con,"select * from users"); $totalcnt = mysqli_num_rows($query); if ($totalcnt > 0) { while ($row=mysqli_fetch_array($query)) { ?> <tr> <td><input type="checkbox" class="checkbox" name="ids[]" value="<?php echo htmlentities($row['id']);?>"/></td> <td><?php echo htmlentities($row['name']);?></td> <td><?php echo htmlentities($row['education']);?></td> <td><?php echo htmlentities($row['doj']);?></td> </tr> <?php } } else { ?> <tr> <td colspan="4"> No Record Found</td> </tr> <?php } ?> </table> </div> </div> </form> <script type="text/javascript"> $(document).ready(function(){ $('#select_all').on('click',function(){ if(this.checked){ $('.checkbox').each(function(){ this.checked = true; }); }else{ $('.checkbox').each(function(){ this.checked = false; }); } }); $('.checkbox').on('click',function(){ if($('.checkbox:checked').length == $('.checkbox').length){ $('#select_all').prop('checked',true); }else{ $('#select_all').prop('checked',false); } }); }); </script> </body> </html>



 

Comments

Post a Comment

Popular posts from this blog

TOP RECRUITMENT COMPANIES IN INDIA

-
Image
Placement organization plays a vital role in matching potential candidates to employers. Today, the whole scenario of recruiting talented people has changed drastically as every company approaches placement agencies to hire candidates that would be valuable assets in the future. Every agency thoroughly checks the background details of candidates, interviews them, and trains them with professionals. Before going into detail about the top recruitment companies, we need to see the advantages of hiring through these organizations. Benefits For Recruiting Through Agencies:-  For the past, many year’s recruitment companies are taking the road map of agencies to hire the workforce, which has proven helpful as follow, 1. Quick hiring process 2. Meeting the purposes 3. Negotiate salary TOP RECRUITMENT COMPANIES IN INDIA 1. RANSSTAD INDIA Keeping the legacy of 28 years, the company has 57K+ temporary employees on-site and over 500K placement to date. The Ransstad is one of the best recruitme...
Read more

Best Indian Colleges For MBA

-
Image
  Every Master’s degree plays an important role in any student’s career. For pursuing a Master’s degree selection of the right college is a must. There are many best Indian colleges for MBA. These colleges will provide proper guidance and grooming which is the major need of every MBA student. Prestige Institute of Management And Research The organization has been Accredited Thrice Consecutively by NAAC with the most noteworthy Grade A++ now. The Institute is ISO 9001:2015 affirmed. In acknowledgment of its Performance and High principles in giving quality schooling, the Institute has been presented Autonomous Status by the University Grants Commission 2006, 2012, 2018 just as Devi Ahilya Vishwavidyalaya on the proposal of a powerful master board of trustees named by UGC to assess the Institute. This is a crucial achievement for the Institute. Eminence Institute of Management and Research is pleased to have set up AIC – Prestige Inspire Foundation under the aegis of Atal Innovation ...
Read more

Boost Your Brand New Site Up Google’s Ranking

-
Image
  The best way to rank any of your sites is through Google. There’s a no-brainer to that. Google is regarded as one of the most powerful tools to help you boost your site. If you have developed a brand new site, you should be aware of the effectiveness and importance of google. Google is the world’s biggest search engine which holds 88% of total searches and contains the world’s information, including webpages, images, videos, and much other information. Google SEO  is the most powerful tool to grow your website organically and the rest of other techniques include  Social Media Marketing , Email Marketing, Pay-Per-Click (PPC), and others. All sites want to rank up their sites on Google’s first page as most of the clicks come through the first page only; more than 75% of people don’t tend to go past Google’s first page. Step by Step Guide: Boost your Brand New Site up Google’s ranking To make your site grow, you should target to appear on google’s first page as more  ...
Read more