I'm afraid I don't really understand. The draw() method tells DataTables to redraw the table based on the setting configured via the API. The pagination controls will automatically redraw the table themselves (by calling the draw() method).
Despite the fact that I have paging set to true, and as you said, the pagination part of my PHP script looks fine, the pagination doesn't work. Each time I click on a new page, it does send a request to the server, but only returns the same results from page one.
I do not have any code for a draw method, because I never saw any on the server-side processing example, so I didn't think it was essential.
Is the reason the table is not re-drawing when I click on the next page because I do not have a draw method in my code?
it does send a request to the server, but only returns the same results from page one.
Good - that's half the battle. You don't need to call draw() if it is already doing the draw for you.
I believe the issue is what I mentioned in a previous reply:
Not the page, just the data from it. It shows that draw is being returned as 0 in the JSON data which is not valid. It should always be 1 or higher.
The JSON data from the server should never have the draw parameter in it as value 0. See the server-side documentation for details about that parameter. (note this parameter has nothing to do with the draw() method - other than a similar name).
If you have the client-side sending POST requests, then yes, you would use $_POST rather than $_GET. Without a link to a test case I can't really say if that is the case or not.
Its really difficult to say what the issue is without being able to see the page. Your code above appears to be sending a POST request - your browser's network tools will tell you if that is actually the case.
Yeah, I understand. I wish I had a page to link to. It is indeed sending a post request. Like I said, if I don't replace $_GET with $_POST, it returns the first page, valid json, and a "draw" of 1. It just doesn't paginate. I'm sure the PHP needs more tweaking.
Going to mark this thread as answered. The script loads the data faster, which was the original purpose for the thread. Just have to figure out how to write the correct PHP script to paginate with MSSQL. Thanks Allan.
@Randy Cash I followed your discussion and i couldnt make my datatable paginate. Did you manage to tweak the script to paginate. Kindly share the code..
Answers
I think you mean the
draw()method - there is nodrawoption in DataTables.If you want to trigger a search after your keyup action, then yes, you need to call
draw()regardless of whether it is server-side or client-side.Allan
But is the
drawmethod necessary for the pagination to work?I'm afraid I don't really understand. The
draw()method tells DataTables to redraw the table based on the setting configured via the API. The pagination controls will automatically redraw the table themselves (by calling thedraw()method).Allan
Sorry, I'm probably not doing a very good job of explaining.
The Javascript code for my table has:
Despite the fact that I have
pagingset to true, and as you said, the pagination part of my PHP script looks fine, the pagination doesn't work. Each time I click on a new page, it does send a request to the server, but only returns the same results from page one.I do not have any code for a
drawmethod, because I never saw any on the server-side processing example, so I didn't think it was essential.Is the reason the table is not re-drawing when I click on the next page because I do not have a
drawmethod in my code?Thanks. Sorry for the confusion.
Good - that's half the battle. You don't need to call
draw()if it is already doing the draw for you.I believe the issue is what I mentioned in a previous reply:
The JSON data from the server should never have the
drawparameter in it as value 0. See the server-side documentation for details about that parameter. (note this parameter has nothing to do with thedraw()method - other than a similar name).Allan
I'll look through the server-side documentation again. I should mention that JsonLint said my JSON data was valid.
Ok, so the draw parameter needs to be sent as part of the data request, and it needs to be cast as an integer. Like this?
No - DataTables sends a draw parameter and you need to send one back.
From the manual:
Allan
Isn't this where I send the parameter back?
As I mentioned before:
Just
intvalthe$_GET['draw']parameter.Allan
Ok, changed the code as you suggested. Gave me an undefined index error for 'draw'. I changed $_GET to $_POST, like so:
Now "draw" returns a value of 1. However, the table is still only loading the first page with each network request.
Since I'm server-side processing, and have my type set to 'POST', do I need to change every instance of $_GET to $_POST in the PHP script?
Thanks.
If you have the client-side sending POST requests, then yes, you would use
$_POSTrather than$_GET. Without a link to a test case I can't really say if that is the case or not.Allan
Replaced every instance of $_GET with $_POST. Broke my PHP script. Does not like this line:
It gives me the following warning:
PHP Warning: addslashes() expects parameter 1 to be string, array given in C:\inetpub\wwwroot\script.php on line 111
Not too familiar with correct PHP syntax. Any suggestions?
Its really difficult to say what the issue is without being able to see the page. Your code above appears to be sending a POST request - your browser's network tools will tell you if that is actually the case.
Allan
Yeah, I understand. I wish I had a page to link to. It is indeed sending a post request. Like I said, if I don't replace $_GET with $_POST, it returns the first page, valid json, and a "draw" of 1. It just doesn't paginate. I'm sure the PHP needs more tweaking.
Going to mark this thread as answered. The script loads the data faster, which was the original purpose for the thread. Just have to figure out how to write the correct PHP script to paginate with MSSQL. Thanks Allan.
@Randy Cash I followed your discussion and i couldnt make my datatable paginate. Did you manage to tweak the script to paginate. Kindly share the code..