search is not happening in server side script when i return the values
search is not happening in server side script when i return the values
SandeepMurala
Posts: 48Questions: 13Answers: 0
in DataTables
Link to test case:
Debugger code (debug.datatables.net):
Error messages shown:
Description of problem:
This discussion has been closed.
Answers
Hi,
I am working on datatable server side scrpting (server.php and ssp.class.php) ,
in server.php this is my code
Here index 1 column i am returning the value form another table ,
So when I do global search this index 1 column not happening remaining columns i am doing search .
This issue i did face earlier also but I did not know how to fix it ,So when I return any of the column that particuler column I am unable to gobal serach .
How can I fix this issue ,kindly help on it .
Thanks
Sandeep
Could any one suggest on it please ?
That looks like an extremely inefficient way of doing it I'm afraid. For every row in the table you are making a new database connection and running a query. Side from not being able to search in that column, the script will start to run really slowly.
What you need is a left join. The demo SSP script doesn't support joins, but Editor's PHP libraries do and you can use them free (i.e. without an Editor license) as described here.
If you don't want to use the Editor libraries, then you need to modify the SSP class to do a left join.
Allan
@allan ,Thank you so much for your valuable time and I realy appreciated ,
Could you explain how can I modify the SSp class to do left join .
And I don't know how to to editer libraries ,so plz expain little bit on SSP class left join.
Thanks
Sandeep.
Hi Sandeep,
This is the class in question. You would need to modify it to add left join support. I'm afraid that is not something I can offer to do at the moment.
Allan