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.
[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
Post a Comment