Delete multiple rows using checkbox from mysql table using PHP

Question

I wanted a row or multiple rows to be deleted when they are selected via check boxes. But it doesn't seem to delete anything even if I select.

Here's what I come up with:

<?php
$con=mysqli_connect("localhost","root","","annualdb");
// Check connection
if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$result = mysqli_query($con,"SELECT * FROM asean_japan WHERE agency='Air'");

if(isset($_POST['delete'])) {
  $checkbox = $_POST['checkbox'];

  for($i=0;$i<count((array)$checkbox);$i++) {
    $del_id = $checkbox[$i];
    $sql = "DELETE FROM asean_japan WHERE id='$del_id'";
    $result = mysqli_query($con,$sql);
  }
// if successful, refresh same page 
if($result) {
  echo "<meta http-equiv=\"refresh\" content=\"0;URL=index.php\">";
}
}
?>
<table class='page'>
  <tr>
    <th>Select</th>
    <th>Agency</th>
    <th>FileName</th>
    <th>FileType</th>
    <th>Date Received</th>
    <th>Action</th>
  </tr>
<?php
while($row = mysqli_fetch_array($result))
{
  ?>
  <tr>
    <td align='center' bgcolor='#FFFFFF'><input name='checkbox[]' type='checkbox' value='<?php echo $row['id']; ?>'></td>
    <td><?php echo $row['agency']; ?></td>
    <td><?php echo $row['filename']; ?></td>
    <td><?php echo $row['filetype']; ?></td>
    <td><?php echo $row['date']; ?></td>
    <td><a target='_blank' href='../annual/indicators/" <?php echo $row['filename']; ?>"'>OPEN</a></td>
  </tr>
</table>

<?php
}
?>
<tr>
  <td colspan="4" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" value="Delete"></td>
</tr>
<?php
mysqli_close($con);
?>

Is there a problem with my checkbox or the input=delete maybe?

Did you do Debugging? i.e Are you getting anything in $_POST['checkbox']? Is your $del_id getting specific selected checkbox value? whenever you ask a question please do debug so the actual problem will uncover — M.Hemant
– M.Hemant, Commented Apr 3, 2019 at 3:04
Yes I tried debugging, no error appears. But no results as well. it does not delete anything — Justin Saints
– Justin Saints, Commented Apr 3, 2019 at 3:20

Pardeep K · Accepted Answer · 2019-04-03 05:00:07Z

1

first you need to close table tag outside the while loop and then you need to check onclick your data post or not to target url click here this will help you

answered Apr 3, 2019 at 5:00

Pardeep K

507 bronze badges

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

Comments

Abhay · Accepted Answer · 2019-04-03 07:45:42Z

0

    foreach($_POST['checkbox'] as $key =>$val) {
        if($val!='') {
             $sql = "DELETE FROM asean_japan WHERE id='$val'";
             $result = mysqli_query($con,$sql);  
        }
    }

edited Apr 3, 2019 at 7:45

Abhay

3,4092 gold badges21 silver badges30 bronze badges

answered Apr 3, 2019 at 3:04

karthik

1

4 Comments

karthik Over a year ago

i think you missed the form tag

Justin Saints Over a year ago

new to php but I understand this code deletes row when checkbox are not empty or checked right? But still it doesn't do anything. Can't figure out why

karthik Over a year ago

<form name="test" id="test" method="post"><table>.......</table>SUBMIT BUTTON</form>

Nico Haase Over a year ago

Please add some explanation to your code such that others can learn from it. Additionally, have a look at SQL injections - your code is highly vulnerable and should not be used in production!

Collectives™ on Stack Overflow

Delete multiple rows using checkbox from mysql table using PHP

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related