php - Delete and insert Many members From many Group at once -

php - Delete and insert Many members From many Group at once -

my current code can insert multiple members single grouping , can delete multiple members single group. want insert/delete multiple members to/from multiple groups.

<?php if( isset( $_post['add_member'] ) ) { $group_id = $_post['group_id']; $count = 0; foreach ($_post['member_id'] $member) { $query="select id member_group member_id = $member , `group_id` = $group_id[0]"; if(!mysqli_num_rows(mysqli_query($connection,$query))) { $query="insert `member_group`(member_id,group_id) values($member,$group_id[0])"; mysqli_query($connection,$query) or die(mysqli_errno($connection)); } $msg = "member assigned." ; ++$count; } echo "<div class='alert alert-info'>$count $msg</div>"; } elseif( isset( $_post['remove_member'] ) ) { $member_id = $_post['member_id']; foreach ($_post['group_id'] $group) { $query="delete member_group group_id = $group" ; $rows = mysqli_query($connection,$query); if(!mysqli_affected_rows($connection)) { echo "<div class='alert alert-info'>member deleted. </div>"; } else { echo "<div class='alert alert-info'>member deleted. </div>"; } } } ?>

thanks :)

php mysql