JQuery dataTable Ajax paging implementation, jquerydatatable

Source: Internet
Author: User

JQuery dataTable Ajax paging implementation, jquerydatatable

The dataTables plug-in of jQuery is an excellent table plug-in that provides functions such as table sorting, browser paging, server paging, filtering, and formatting. You need to go to the dataTables website to http://www.datatables.net/download this script library.

During webpage development, we may read data from the background to create tables. When the data size is too large, the table creation time may be too long, so you need to implement the Ajax paging function. The Code is as follows:


HTML:

<table id="example" class="display" width="100%" cellspacing="0">        <thead>            <tr>                <th>First name</th>                <th>Last name</th>                <th>Position</th>                <th>Office</th>                <th>Start date</th>                <th>Salary</th>            </tr>        </thead>         <tfoot>            <tr>                <th>First name</th>                <th>Last name</th>                <th>Position</th>                <th>Office</th>                <th>Start date</th>                <th>Salary</th>            </tr>        </tfoot>    </table>


JS:

/// Pipelining function for DataTables. to be used to the 'ajax 'option of Ables // $. fn. dataTable. pipeline = function (opts) {// Configuration options var conf = $. extend ({pages: 5, // number of pages to cache url: '', // script url data: null, // function or object with parameters to send to the server // matching how 'ajax. data 'Works in DataTables method: 'get' // Ajax HTTP method}, o Pts); // Private variables for storing the cache var cacheLower =-1; var cacheUpper = null; var cachelstrequest = null; var cacheLastJson = null; return function (request, drawCallback, settings) {var ajax = false; var requestStart = request. start; var drawStart = request. start; var requestLength = request. length; var requestEnd = requestStart + requestLength; if (settings. clearCache ){// API requested that the cache be cleared ajax = true; settings. export ache = false;} else if (cacheLower <0 | requestStart <cacheLower | requestEnd> cacheUpper) {// outside cached data-need to make a request ajax = true ;} else if (JSON. stringify (request. order )! = JSON. stringify (cachelstrequest. order) | JSON. stringify (request. columns )! = JSON. stringify (cachelstrequest. columns) | JSON. stringify (request. search )! = JSON. stringify (cachelstrequest. search) {// properties changed (ordering, columns, searching) ajax = true;} // Store the request for checking next time around cachelstrequest = $. extend (true, {}, request); if (ajax) {// Need data from the server if (requestStart <cacheLower) {requestStart = requestStart-(requestLength * (conf. pages-1); if (requestStart <0) {requestStart = 0;} CacheLower = requestStart; cacheUpper = requestStart + (requestLength * conf. pages); request. start = requestStart; request. length = requestLength * conf. pages; // Provide the same 'data' options as DataTables. if ($. isFunction (conf. data) {// As a function it is executed with the data object as an arg // for manipulation. if an object is returned, it is used as the // data object to submi T var d = conf. data (request); if (d) {$. extend (request, d) ;}} else if ($. isPlainObject (conf. data) {// As an object, the data given extends the default $. extend (request, conf. data);} settings. jqXHR = $. ajax ({"type": conf. method, "url": conf. url, "data": request, "dataType": "json", "cache": false, "success": function (json) {cacheLastJson = $. extend (true, {}, json); if (cach ELower! = DrawStart) {json. data. splice (0, drawStart-cacheLower);} json. data. splice (requestLength, json. data. length); drawCallback (json) ;}}) ;}else {json =$. extend (true, {}, cacheLastJson); json. draw = request. draw; // Update the echo for each response json. data. splice (0, requestStart-cacheLower); json. data. splice (requestLength, json. data. length); drawCallback (json) ;}}; // Register an API method that will empty the pipelined data, forcing an Ajax // fetch on the next draw (I. e. 'table. clearPipeline (). draw () ') $. fn. dataTable. api. register ('clearpipeline () ', function () {return this. iterator ('table', function (settings) {settings. export ache = true ;}); // DataTables initialisation // $ (document ). ready (function () {$ ('# example '). dataTable ({"processing": true, "serverSide": true, "ajax": $. fn. dataTable. pipeline ({url: '', // processing URL in the background, for example," scripts/server_processing.php "pages: 5 // pre-read 5 pages })});});


Response data:

{  "draw": 2,  "recordsTotal": 57,  "recordsFiltered": 57,  "data": [    [      "Tiger",      "Nixon",      "System Architect",      "Edinburgh",      "25th Apr 11",      "$320,800"    ],    [      "Timothy",      "Mooney",      "Office Manager",      "London",      "11th Dec 08",      "$136,200"    ],    [      "Unity",      "Butler",      "Marketing Designer",      "San Francisco",      "9th Dec 09",      "$85,675"    ],    [      "Vivian",      "Harrell",      "Financial Controller",      "San Francisco",      "14th Feb 09",      "$452,500"    ],    [      "Yuri",      "Berry",      "Chief Marketing Officer (CMO)",      "New York",      "25th Jun 09",      "$675,000"    ],    [      "Zenaida",      "Frank",      "Software Engineer",      "New York",      "4th Jan 10",      "$125,250"    ],    [      "Zorita",      "Serrano",      "Software Engineer",      "San Francisco",      "1st Jun 12",      "$115,000"    ]  ]}



Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.