delete from MySQL database using checkboxes

Question

I'm attempting to delete a row from a table with data that is generated from a MySQL table. I took a look at both of these questions: 1. How to delete rows of database results using checkbox 2.Deleting multiple rows using checkboxes, PHP and MySQL.

I need help for code delete using checkboxes..

<?php

$sql = mysqli_query($conn, "SELECT * FROM leads ORDER BY lid ASC");
if(mysqli_num_rows($sql) == 0){
   echo '<tr><td colspan="8">No Data Entry</td></tr>';
}else{
    while($row = mysqli_fetch_assoc($sql)){
        echo '<tr>
                <td> <input name"checkbox[]" value"'.$row['lid'].'" type="checkbox"></td>
                <td>'.$row['name'].'</td>
                <td>'.$row['sex'].'</td>
                <td>'.$row['phone'].'</td>
                <td>'.$row['company'].'</td>
                <td>'.$row['vehicle'].'</td>
            </tr>';
        }
    }?>

Cancel

 <?php

   $del_lid = $_POST['checkbox']; 
   if (isset($_POST['submit'])) {
     foreach($del_lid as $value){
       $sql = "DELETE FROM leads WHERE lid='".$value."'";
       $result = mysqli_query($conn, $sql);
    }
 }
?>

Any kind of help or suggestions are appreciated. thank you.... — zak
– zak, Commented Jun 23, 2017 at 8:37
thank you for response guys the true is i newbie in php coding @JYoThl i thing my problem for execute the delete statement. — zak
– zak, Commented Jun 23, 2017 at 8:46

Professor Abronsius · Accepted Answer · 2017-06-23 08:53:50Z

2

The checkboxes were missing the equals sign so effectively none of them had a value. The sql could be streamlined to use the in operator rather than a loop.

    <table>
<?php

    $sql = mysqli_query($conn, "SELECT * FROM leads ORDER BY lid ASC");
    if( mysqli_num_rows($sql) == 0 ){
        echo '<tr><td colspan="8">No Data Entry</td></tr>';
    }else{
        while($row = mysqli_fetch_assoc($sql)){
            echo '
            <tr>
                <td> <input name="checkbox[]" value="'.$row['lid'].'" type="checkbox"></td>
                <td>'.$row['name'].'</td>
                <td>'.$row['sex'].'</td>
                <td>'.$row['phone'].'</td>
                <td>'.$row['company'].'</td>
                <td>'.$row['vehicle'].'</td>
            </tr>';
        }
    }
?>
        </table>
        <input type="submit" name="delete" class="btn btn-sm btn-primary" value="delete">
        <a href="index.php" class="btn btn-sm btn-danger">Cancel</a></td>
    </form>
</div>
<?php

    $del_lid = $_POST['checkbox']; 

    if ( isset($_POST['submit'] ) ) {
        $sql='delete from `leads` where `lid` in ( ' . implode( ',', $del_lid ). ' )';
        $result = mysqli_query($conn, $sql);
    }
?>

edited Jun 23, 2017 at 8:53

answered Jun 23, 2017 at 8:43

Professor Abronsius

33.9k5 gold badges36 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

11 Comments

Adder Over a year ago

How about using SQL injection protection: $del_lid = array_map('intval',$_POST['checkbox']);

Professor Abronsius Over a year ago

True - SQL Injection is an issue - a prepared statement would be much better but the array_map function call is a good shout!

zak Over a year ago

Hello Ram i still getting an error Notice: Undefined index: checkbox in C:\xampp\htdocs\mysqlicrud\leads.php on line 49 this line => $del_lid = $_POST['checkbox'];

Adder Over a year ago

<input name"checkbox[]" is missing the equals sign after name

zak Over a year ago

thank you very much guys i got the answers i missed the if ( isset($_POST['submit'] ) ) suppose to be if ( isset($_POST['delete'] ) ) sorry my bad but thank you again for help

|

Collectives™ on Stack Overflow

delete from MySQL database using checkboxes

1 Answer 1

11 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Related