Bladephp: Now with 7+ codeigniter, php, and laravel project 7+ php project From $18/Year From Rs. 1000/Year

How to Delete Multiple Records From MySQL Using PHP

by
Category:php
php mysql
How to Delete Multiple Records From MySQL Using PHP

So here i will tell you how to delete bulk records from MySQL table in PHP with checkbox, you just need to select checkbox which one you want to delete and hit submit button to delete. As we know, Its very time consuming to delete records one by one. Everyone wants to delete bulk record on single event only. You may also like How to Add, Edit and Delete Records Using jQuery, Ajax, PHP and MySQL.

 PHP and HTML Code

<?php
    define('DB_SERVER', "localhost");
    define('DB_USER', "root");
    define('DB_PASS', "");
    define('DB_DATABASE', "ieltsmedidb");
    $con = mysqli_connect(DB_SERVER, DB_USER, DB_PASS, DB_DATABASE);
?>

<?php
if(isset($_POST['delete_records']) && count($_POST['no'])>0)
{
    for($i=0;$i<count($_POST['no']);$i++)
    {
        $row_no=$_POST['no'][$i];
        mysqli_query($con,"delete from medical_student where student_id = '$row_no' ");
    }
}
?>

<html>
<head>
</head>
    <body>
        <?php
        $select = mysqli_query($con, "SELECT * FROM medical_student");
        ?>
        <form method="post" action="">
            <table align="center" cellpadding="10" border="1">
                <tr>
                    <th></th>
                    <th>NAME</th>
                    <th>AGE</th>
                </tr>
                <?php
                while ($row = mysqli_fetch_assoc($select)) {
                    echo "<tr>";
                    echo "<td><input type='checkbox' name='no[]' value='" . $row['student_id'] . "'></td><td>" . $row['student_name'] . "</td><td>" . $row['email'] . "</td>";
                    echo "</tr>";
                }
                ?>
            </table>
            <input type="submit" name="delete_records" value="Delete Records">
        </form>
    </body>
</html>

0 Comments


Html code work in comment box


Related Post