Based on Bootstrap + PHP +ajax DataTable plugin Usage

DataTables is a jquery form Plugin. It is a highly flexible tool that can add advanced interactivity to any HTML table.

Here is a Server-side (php) page example that I learned to write datatables, which contains the features List:

1, in the first column to add a checkbox, to achieve the full selection function; the Select box does not have the Sort button 2, Add action button 3 in the last column, hide, display the column field; field default sort 4, salary thousand points, decimal two bit format 5, content too much use .... Mouse over the text; display details 6, replace characters, male font display red, female display green 7, add hyperlink to text 8, display, hide the contents of multiple columns 9, the cell is in the row, column highlighting 10, custom search conditions "time processing, The keyword of the fuzzy query (the former is not implemented, Just show the use of the dual calendar, the latter implements the function, the former function to achieve Similar) "11, in-line editing ...

has implemented the general function, the existing problems, 1 operations inside the inline editing, open the page 242 lines, you can open the deletion logic (inline editing will have an impact); of course, to achieve the operation has edits, delete, etc., need to be edited in the integration of the downstream Operation. Do it a little bit. 2 referencing jquery-datatable bootstrap-datatable (triangular Shape) causes a different style for the sort button, and then integrates the BOOTSTRAP-DATATABLE.CSS to achieve Pagination.

Effect

For detailed study, please refer to its official website: Http://datatables.net/chinese web: http://dt.thxopen.com/

Before learning a datatable, you can refer to the common questions to deepen some understanding of the use of the Datatable. For example: $ ("#example"). dataTable ({...}) and $ ("#example"). The difference between the DataTable ({...}) and the 1.10.x and 1.9.x parameter names are not confusing when writing parameters, and are easy for others to Read.

then, Attach the code package (contains SQL file, background Script Database test, username root, password is empty):

Link: http://pan.baidu.com/s/1slOw0Cd password: 94TG

Based on Bootstrap + PHP +ajax DataTable plugin Usage