jQuery Grid Plugin – jqGridFilter/Search | Help

Filter/Search

Page: 1

User

Post

22:53
29/05/2012

marcelocr2

New Member

posts 2

Print this Post

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
31/05/2012

marcelocr2

New Member

posts 2

Print this Post

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

Page: 1

You must be logged in to post	Login Register

jQuery Grid Plugin – jqGrid

Forum