Guest User

Untitled

a guest
Aug 16th, 2018
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.74 KB | None | 0 0
  1. How jqgrid edit operation send to the server the variables?
  2. <script type="text/javascript">
  3.  
  4. $(function(){
  5.  
  6. var mygrid = $("#list");
  7.  
  8. mygrid.jqGrid({
  9. url:'example1.php',
  10. editurl: 'edit.php',
  11. datatype: 'xml',
  12. mtype: 'GET',
  13. colNames:['Inv No','Date', 'Amount','Tax','Total','Notes'],
  14. colModel :[
  15. {name:'invid',
  16. index:'invid',
  17. width:55
  18. },
  19. {name:'invdate',
  20. index:'invdate',
  21. width:90,
  22. editable:true
  23. },
  24. {name:'amount',
  25. index:'amount',
  26. width:80,
  27. align:'right',
  28. search:true ,
  29. stype:'select',
  30. searchoptions:{value:':All;8:8.00;6:6.00'},
  31. editable:true
  32. },
  33. {name:'tax',
  34. index:'tax',
  35. width:80,
  36. align:'right',
  37. editable:true
  38. },
  39. {name:'total',
  40. index:'total',
  41. //width:80,
  42. align:'right',
  43. sortable:true,
  44. editable:true,
  45. editrules:{required:true},
  46. edittype:'select',
  47. editoptions:{value:"5:55.00;2:25.00"}
  48. },
  49. {name:'note',
  50. index:'note',
  51. width:150,
  52. search:true ,
  53. align:'center',
  54. editable:true,
  55. editrules:{required:true, edithidden:true},
  56. hidden:true,
  57. edittype:'textarea',
  58. editoptions: {rows:"12",cols:"10"}
  59. }
  60. ],
  61. pager: '#pager',
  62. emptyrecords: "Nothing to display",
  63. recordtext: '{0} - {1} of {2}',
  64. rowNum:9,
  65. rowList:[7,9,11],
  66. viewrecords: true,
  67. caption: 'My first grid',
  68. sortname: 'invid',
  69. sortorder: 'desc',
  70. loadonce : true
  71.  
  72. });
  73. //Search button
  74. $("#bsdata").click(function(){ mygrid.jqGrid('searchGrid', {sopt:['eq'],top:300,caption:"test searching"} ); });
  75. // Search toolbar.
  76. mygrid.jqGrid('filterToolbar', {stringResult: true, searchOnEnter: false, defaultSearch : "eq"});
  77. //NavBar
  78. mygrid.jqGrid('navGrid','#pager',{edit:false,add:false,del:false,search:true});
  79.  
  80. // Edit Row
  81.  
  82. $("#bedata").click(function(){
  83. var gr = mygrid.jqGrid('getGridParam','selrow');
  84. if( gr != null )
  85. mygrid.jqGrid('editGridRow',gr,{height:480,reloadAfterSubmit:false});
  86. else alert("Please Select Row");
  87. });
  88.  
  89. // Add row
  90.  
  91. $("#badata").click(function(){
  92. mygrid.jqGrid('editGridRow',"new",{height:480,reloadAfterSubmit:false});
  93. });
  94.  
  95. // Delete row
  96.  
  97. $("#bddata").click(function(){
  98. var gr = mygrid.jqGrid('getGridParam','selrow');
  99. if( gr != null )
  100. mygrid.jqGrid('delGridRow',gr,{reloadAfterSubmit:false});
  101. else
  102. alert("Please Select Row to delete!");
  103. });
  104.  
  105. });
  106.  
  107.  
  108. </script>
  109.  
  110. <?php
  111.  
  112. // connect to the database
  113. $dbhost = "localhost";
  114. $dbuser = "user";
  115. $dbpassword = "user123";
  116. $database = "test";
  117. $tablename = "invheader";
  118. $db = mysql_connect($dbhost, $dbuser, $dbpassword)
  119. or die("Connection Error: " . mysql_error());
  120.  
  121. mysql_select_db($database) or die("Error conecting to db.");
  122. //mysql_set_charset('utf8',$database);
  123. mysql_query("SET NAMES 'utf8'");
  124.  
  125.  
  126. if($_GET['oper']=='add')
  127. {
  128.  
  129. }
  130. if($_GET['oper']=='edit')
  131. {
  132. $id = mysql_real_escape_string($_GET['id']);
  133. $date = mysql_real_escape_string($_GET['invdate']);
  134. $amount = mysql_real_escape_string($_GET['amount']);
  135. $tax = mysql_real_escape_string($_GET['tax']);
  136. $total = mysql_real_escape_string($_GET['total']);
  137. $note = mysql_real_escape_string($_GET['note']);
  138.  
  139. $sql = "UPDATE ".$tablename." SET invdate = '".$date."', client_id = '5' , amount = '".$amount."', tax = '".$tax."', total = '".$total."' , ";
  140. $sql.= "note = '".$note."'";
  141. $sql.= " WHERE invid = ".$id;
  142.  
  143. echo $sql;
  144. $result=mysql_query($sql) or die(mysql_error());
  145.  
  146. mysql_close($db);
  147.  
  148.  
  149. }
  150. if($_GET['oper']=='del')
  151. {
  152.  
  153. }
  154.  
  155.  
  156.  
  157. ?>
Add Comment
Please, Sign In to add comment