Forum
Log In
Home
Topic RSS
Related Topics
22:53
29/05/2012
Offline
Hi, I am new to jqgrid and I wanty to filter/search data, but I dont know how to change de php file, I am using this in HTML file
$("#srccontents").filterGrid("list",{ gridModel:true, gridNames:true, formtype:"vertical", enableSearch: false, enableClear: false, autosearch: true });
and the query in php file is:
$SQL = "SELECT id, nombre, descripcion FROM desc_examenes ORDER BY $sidx $sord LIMIT $start , $limit";
I suppose i should include the where clause, but I dont know how to get the value the user wnats to search
Thank you
00:23
29/05/2012
Offline
Ji, I made some changes and I can search now using the navigation bar, but I want to make the search usig the filtertoolbar too.
$("#list").jqGrid('filterToolbar',{stringResult: true, searchOnEnter : false, defaultSearch: 'cn'});$("#list").jqGrid('navGrid','#pager',{edit:false,add:false,del:false});
Every time I use the filtertoolbar it doesn send any parameters to the server so the query looks like this:
SELECT id, nombre, descripcion FROM desc_examenes WHERE '' ORDER BY nombre asc
I dont know why I am not capturing the parameters with the toolbar
Thank You
Most Users Ever Online: 715
Currently Online:
163 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66
