0

I'm new to jqGrid. I'm trying to implement multiple search. As far as I can see, jqGrid can generate a string that I can put in the WHERE clause of my SQL statement for the search to take place. I can see that generated string when I specify

showQuery: true

in the search options. However I don't know how can I send this string to my php script on server. Is that possible?

facha
  • 11,862
  • 14
  • 59
  • 82

1 Answers1

0

I don't recommend you to use the string which you see in case of the showQuery:true option. Instead of that you should deserialize the filters on the server side and then construct the SELECT statement in your code.

If you use ASP.NET and Entity Framework you will find the solution in the UPDATED part of the answer. If you need construct the SQL SELECT statement dynamically and you don't use .NET you should take in the consideration SQL injection problem. So you should use parameters in the SQL statements chich you will construct.

Community
  • 1
  • 1
Oleg
  • 220,925
  • 34
  • 403
  • 798