Serverside datasource.php file does not seem to be $_GET-ing sSearch variables...

Serverside datasource.php file does not seem to be $_GET-ing sSearch variables...

ColinKColinK Posts: 1Questions: 1Answers: 0
edited August 2014 in Free community support

Serverside datasource.php file does not seem to be $_GET-ing sSearch variables, such that my SQL Statments never get a filer... its just always "SELECT * FROM viewDataView". The JSON data returned is valid, but the gets for the filters in the serverside file (e.g., $_GET['sSearch'], $_GET['iSortCol_0'], $_GET[ 'bSortable_X'] etc) are ALL null.

Anybody seen this before?

When I pass the parameters manually file via the URL like http://serverpath.../datasource.php?sSearch=findme, data is returned, and in the correct JSON format, but when I perform the same search for findme on the datatables page, it processes and refreshes the same rows, as though the parameters are not getting sent to the datasource.php file by the datatables API.

My datasource.php is a copy of this with my db information (including index column)
http://www.datatables.net/development/server-side/php_mssql_odbc

Feels like I'm very close to making this work, but now I'm suddenly stuck! Any help would be appreciated.

script implementation:
"< script >$(document).ready(function() {
$("#table_id").dataTable( {
scrollY:'500px',
paging:false,
processing: true,
serverSide: true,
ajax: 'datasource.php'
} );} );< / script>"

This discussion has been closed.