Deleting multiple rows from mysql with checkbox

Question

I need to delete multiple rows from mysql with checkbox. Can some one please help me to identify what's wrong in my code

 <?php

    $host="localhost"; // Host name 
    $username="xxxx"; // Mysql username 
    $password="xxxx"; // Mysql password 
    $db_name="xxxx"; // Database name 
    $tbl_name="xxx"; // Table name


    // Connect to server and select database. 
    mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
    mysql_select_db("$db_name")or die("cannot select DB"); 
    // Retrieve data from database 
    $sql="SELECT * FROM $tbl_name ORDER BY id ASC";
    $result=mysql_query($sql); 
    // num rows
    $count=mysql_num_rows($result);
    // Start looping rows in mysql database. 
    while($rows=mysql_fetch_array($result)){ 
    ?> 


    <table id="rows" width="100%" border="1" bordercolor="#000" cellspacing="1"       cellpadding="3" cellwidth="100" float="left" margin-left="20px" >
    <tr>
    <td width="2%" align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox"   id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
    <td width="1%" BGCOLOR="#fff"><? echo $rows['id']; ?></td>
    <td width="22%" BGCOLOR="#fff"><? echo $rows['location']; ?></td>
    <td width="22%" BGCOLOR="#fff"><? echo $rows['type']; ?></td> 
    <td width="22%" BGCOLOR="#fff"><? echo $rows['qnty']; ?></td> 
    <td width="22%" BGCOLOR="#fff"><? echo $rows['enteredby']; ?></td>
    </tr>
    <?php
    }
    ?>

    <tr>
    <td colspan="5" align="left" bgcolor="#FFFFFF"><input name="delete" type="submit"  id="delete" value="Delete Row"></td>
    </tr>

    <?php

    // Check if delete button active, start this 
    if($delete){
    for($i=0;$i<$count;$i++){
    $del_id = $checkbox[$i];
    $sql = "DELETE FROM $tbl_name 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_multiple.php\">";
    }
    }
    mysql_close();
    ?>

    </table>

PHP Notice: Undefined variable: delete in stock_table.php on line 79 — user3419706
– user3419706, Commented Mar 14, 2014 at 12:14

Laukik Patel · Accepted Answer · 2014-03-14 12:03:58Z

2

Try with

if(!empty($checkbox)) {
   $sql = "DELETE FROM $tbl_name WHERE id IN(".implode(",", $checkbox).")";
   $result = mysql_query($sql);
}

answered Mar 14, 2014 at 12:03

Laukik Patel

7437 silver badges18 bronze badges

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

2 Comments

user3419706 Over a year ago

Now i get syntax error, unexpected '}' but if i delete it page does not load?

Laukik Patel Over a year ago

what you get in $checkbox.

Collectives™ on Stack Overflow

Deleting multiple rows from mysql with checkbox

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related