jqGrid does not do all the magic for you 🙂

You should write your own server side script when search is performed.

The demos are in PHP, but you will have a idea how to do this

Regards

Tony

i am playing with jgrid now for a few days and finally i got it working and am ready to add some features, like searching for data.

i just can't get it working!

I do get the multiple searchbox, but after setting a search value, i click on OK, the grid reloads with the same data, so not with the search results.

I think i sent the request to the wrong page? But how do i set it up to another backend page?

Do i have to add 2 kind of beckend pages? One for normal results and one for search results? Because i need a where clausule in mysql when searching?

I use php end xml data.

My code:

<script type="text/javascript">
$(function(){
  $("#list").jqGrid({
    url:'jquery/jqgrid/backend_spelerslijst.php',
    datatype: 'xml',
    mtype: 'GET',
    colNames:['VIP','nick', 'rating','laatst','max_invites','Gespeeld','nieuw'],
    colModel :[
      {name:'VIPSTATUS', index:'VIPSTATUS', width:20, align:'center'},
      {name:'nick', index:'nick', width:150},
      {name:'rating', index:'rating', width:80, align:'center'},
      {name:'lastactivity', index:'lastactivity', width:150, align:'center'},
      {name:'max_invites', index:'max_invites', width:80, align:'center'},
      {name:'spellen', index:'spellen', width:65, align:'center'},
      {name:'nieuw', index:'nieuw', width:50, align:'center'}
      
    ],
    pager: '#pager',
    rowNum:25,
    rowList:[25,50,100],
    height:"100%",
    multiselect: true,
    sortname: 'playerID',
    sortorder: 'desc',
    viewrecords: true,
    caption: 'Spelerslijst',

  });
  jQuery("#list").jqGrid('navGrid','#pager',{del:false,add:false,edit:false,search:true,refresh:false },{},{},{},{multipleSearch:true});
});

</script>

Many,many thanks in advance for any help,

i got an headache of it for 2 days now:(