Multiple CheckBox delete

Question

I am having a hard time on creating a multiple checkbox ajax delete. I am an ajax noob.

    $sql = 'SELECT * FROM users';
$qry = mysql_query($sql);
$html = '';
$html .='<center>';
$html .= '<a href="" id="a-add">+ Add New User</a>';
$html .= ' || <a href="" id="a-delete"> Delete User</a>';
$html .= '<div id="div-data">';
$html .= '<table border="1" width="300px">';
$html .= '<tr>';    
$html .= '<th width="5px"><input type="checkbox" id="cb-checkall"></th>';   //all
$html .= '<th> Users</th>';         
//$html .= '<th>Delete</th>';
while($row = mysql_fetch_array($qry)) {
    $html .= '<tr align="center">';     
    $html .= '<td><input type="checkbox" name="checkall" class="checkall" value="'.$row['uid'].'"/></td>';   
    $html .= '<td>'.$row['fname'].'</td>';
    $html .= '</tr>';           
}
$html .= '</table>';
$html .= '</div>';
echo $html;

delete.php (with the use of implode)

    $deleteid = implode(",",$_POST['checkall']);
$fname = mysql_escape_string($_POST['firstname']);
$sql = "DELETE from  `bpo`.`users` (`uid` ,`fname`)
        WHERE UID IN (".$deleteid.")";

My data doesnt go to delete.php. idk why. I need help on deleting the checked rows when I push delete button and automatically reflects to my database. The change have to appear on screen without refreshing (AJAX) and with the use of implode. Thank you.

You cant have multiple checkboxes with the same name

Dinistro
– Dinistro

2014-04-25 12:00:15 +00:00
Commented Apr 25, 2014 at 12:00 — Dinistro
– Dinistro, Commented Apr 25, 2014 at 12:00

Halcyon · Accepted Answer · 2014-04-25 11:59:06Z

1

In your form change name="checkall" to name="checkall[]" to allow for multiple values.

Keep in mind that if no options are checked $_POST['checkall'] will be undefined which will generate an Undefined index notice. Use isset or array_key_exists.

If $deleteid is empty (like array()) you query will be malformed, ie.

DELETE from  `bpo`.`users` (`uid` ,`fname`) WHERE UID IN ()
                                       // unexpected ) -- ^

This will give you an SQL error. IN clause may not be empty.

answered Apr 25, 2014 at 11:59

Halcyon

57.7k10 gold badges93 silver badges131 bronze badges

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

Collectives™ on Stack Overflow

Multiple CheckBox delete

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related