Defer Loading server-side help

Defer Loading server-side help

jermsv1jermsv1 Posts: 2Questions: 0Answers: 0
edited June 2011 in General
Hi,

I'm trying to figure out the server-side on this page for Defer Loading:
http://www.datatables.net/release-datatables/examples/server_side/defer_loading.html

I'd like to implement the exact same thing (for pagination and search), however I don't know what the server-side looks like and the exact structure it's expecting. i've tried to firebug the response back from the server, but it's not making sense to me.

There's a ton of vars passed, and it'd be great to see every a very simple server-side example of generating the json for both the pagination and search.

I know it's something like this...(pseudo json)
aaData = array of row values ["val1", "val2", "val3"]
iTotalRecords = "4000"
iTotalDisplayRecords = "4000"
sEcho = some integer ?

Also are all these GET vars auto generated by datatables?
http://www.datatables.net/release-datatables/examples/server_side/scripts/server_processing.php?sEcho=6&iColumns=5&sColumns=&iDisplayStart=0&iDisplayLength=10&sSearch=triden&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSearchable_1=true&sSearch_2=&bRegex_2=false&bSearchable_2=true&sSearch_3=&bRegex_3=false&bSearchable_3=true&sSearch_4=&bRegex_4=false&bSearchable_4=true&iSortingCols=1&iSortCol_0=0&sSortDir_0=asc&bSortable_0=true&bSortable_1=true&bSortable_2=true&bSortable_3=true&bSortable_4=true&_=1307586309300

Appreciate any help!

cheers,
christopher

Replies

  • jermsv1jermsv1 Posts: 2Questions: 0Answers: 0
    Edit: Those GET vars are auto generated.

    I guess I could figure out how to write the server-side doesn't seem that bad, just want to make sure that structure I posted is correct.
  • allanallan Posts: 63,523Questions: 1Answers: 10,473 Site admin
    There is an example return in the documentation here: http://datatables.net/usage/server-side . Also you want to make sure that iTotalRecords and iTotalDisplayRecords are integers, and not strings like you have above.

    Allan
This discussion has been closed.