Deleting data using checkbox in PHP

Question

I'm having a problem with deleting data using checkbox. I actually, retrieve all the records that I want to show/display. But the Delete button doesn't work.

$sql="SELECT * FROM admin";
$result=mysql_query($sql);

$count=mysql_num_rows($result);

<?php
    while($rows=mysql_fetch_array($result)){

    echo "<tr>";
        echo "<td>" . "<input type='checkbox' name='check[]' value='".$rows['id']."'/>" . "</td>";
        echo "<td>" . $rows['username'] . "</td>";
        echo "<td>" . $rows['email'] . "</td>";
    echo "</tr>";
?>

<input name="delete" type="submit" id="delete" value="Delete">

Here's the IF STATEMENT to check if the delete button was active.

if($delete){
    for($i=0;$i<$count;$i++){
        $del_id = $checkbox[$i];
        $sql = "DELETE FROM admin WHERE id='$del_id'";
        $result = mysql_query($sql);
    }
    // if successful redirect to delete_multiple.php 
    if($result){
        echo "<meta http-equiv=\"refresh\" content=\"0;URL=delete_admin.php\">";
    }
}

Any help is appreciated. Thank you!

What is $count? What is $checkbox? How are you outputting the checkboxes? You'll need to show more of your code... — Reinder Wit
– Reinder Wit, Commented Apr 22, 2015 at 10:44
Hi Mr. White, I already update the my question. Sorry for giving incomplete details — user3324056
– user3324056, Commented Apr 22, 2015 at 10:48
Please post the whole code of both (the input and delete), the fault can be everywhere. — CodeFox
– CodeFox, Commented Apr 22, 2015 at 10:53

Sunil Pachlangia · Accepted Answer · 2015-04-22 10:54:18Z

1

You can IN function of MySql

if($delete){
    $checkboxIds = implode(',',$_POST['checkbox']);

    $sql = "DELETE FROM admin WHERE id IN ('".$checkboxIds."')";
    $result = mysql_query($sql);

    // if successful redirect to delete_multiple.php 
    if($result){
        echo "<meta http-equiv=\"refresh\" content=\"0;URL=delete_admin.php\">";
    }
}

answered Apr 22, 2015 at 10:54

Sunil Pachlangia

2,0613 gold badges17 silver badges26 bronze badges

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

1 Comment

Ofir Baruch Over a year ago

While that's true, I believe it's not solving the problem. It should be suggested in a comment. Good approach however ;)

Guilherme Ferreira · Accepted Answer · 2015-04-22 11:03:48Z

0

Try do it:

if(isset($_POST['delete']) { //check if you received the post

    for($i=0; $i<count($_POST['check']); $i++) { // count the elements

        $del_id = $_POST['check'][$i];

...

answered Apr 22, 2015 at 11:03

Guilherme Ferreira

1432 silver badges11 bronze badges

1 Comment

user3324056 Over a year ago

I don't know how to mark this thread as RESOLVED. Thank you so much Guilherme

Collectives™ on Stack Overflow

Deleting data using checkbox in PHP

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related