I want to Delete multiple Rows from a table which  populated using pagination

 

I am using following code fo select multiple rows of a table

which is

populated using Pagination

This code is working fine

2. $(document).ready(function() {
3.  
4.     $('#selectall').click(function(event) {  
5. alert("AA");//on click 
6.         if(this.checked) { // check select status
7.             $('.checkbox1').each(function() { //loop through each checkbox
8.                 this.checked = true;  //select all checkboxes with class "checkbox1"               
9.             });
10.         }else{
11.             $('.checkbox1').each(function() { //loop through each checkbox
12.                 this.checked = false; //deselect all checkboxes with class "checkbox1"                       
13.             });         
14.         }
15.     });
16.     
17. });
 

In order to delete I am not in position to write PHP code to delete the selected rows.

A person may select All or just few rows.

I believe we need to perform there are 3 tasks

When a person Click to delete "All selected "

1. Delete the rows selected (from Data base)  . I need to select the rows that  are "checked" and delete them from Database
2. Refresh The table after deleting the rows from Database

Note: After refresh,   the deleted rows will not be displayed