php - JQGRID, How to multiselect rows in grid and post that selected data to database on click? -


how multi-select rows , send post data new datatable? have idea post not elaborate.i thinking of multiselecting rows , sending them posting them new table on database, while deleting them original table, on click of either button on navigation bar or preferably outside link(like "finished" @ bottom.enter image description here

[new edit] how code looks right now.i've got posting different databsae on click , after want selected rows deleted grid , database. i've appended delete function on success nothing delete. please suggestions?

            jquery("#minibutton").click( function(){      var selectedrows = $("#list").jqgrid('getgridparam','selarrrow'); if(selectedrows.length) { for(var i=0;i<selectedrows.length; i++) {  var selecteddatais = $("#list").jqgrid('getrowdata',selectedrows[i]);         var rows=json.stringify(selecteddatais)         var postarray = {json:rows};      $.ajax({       type: "post",       url: "jsonsend.php",    data: postarray,           datatype: "json",    success: function () {                              var errors = [];   jquery("#list").jqgrid('getgridparam','selarrrow').each(function(index, value) {     if (!jquery("#list").jqgrid('delrowdata', value)) errors.push(value);   });   if (errors.length)   {     alert('already deleted or not in list on row(s): ' + errors.join(', '));    }      }                         });           }    }  });      }); </script> 

you can enable delete button in jqgrid , pass value deldata servlet or handler.here pass value of msgid in servlet.check here:

 .navgrid('#page',{edit:false,add:false,del:true,deltext:"move  trash"},{},{},             /*delete start */{                  url: '<%=request.getcontextpath() + "/messageboxservlet?inbox=remove"%>',                  closeonescape: true,                  reloadaftersubmit: true,                  deldata: {                    msgid: function () {                         var sel_id = $('#list').jqgrid('getgridparam', 'selarrrow');                         var value ="";                         for(var a=0;a < sel_id.length;a++)                             {                                value = ('#list').jqgrid('getcell', sel_id[a], 'msgboxid');                              }                         return value;                    }                },                }           ); 

Comments

Popular posts from this blog

linux - xterm copying to CLIPBOARD using copy-selection causes automatic updating of CLIPBOARD upon mouse selection -

c++ - qgraphicsview horizontal scrolling always has a vertical delta -