Guest User

Untitled

a guest
May 23rd, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.86 KB | None | 0 0
  1. []Admin
  2. []Users
  3.  
  4. <input id='module_permission[]' onclick="selectall()" type='checkbox' value='".$key."' name='module_permission[]' $val_checked ><b>".$val."</b><br> ";
  5.  
  6. <input type='checkbox' id='sub_module_permission[$l][]' name='sub_module_permission[$l][]' value='".$key1 ."' onclick="selectParent($l);" $val_checked>".$val1."<br> ";
  7.  
  8. $module_id=$_post[module_permission]
  9. foreach($module_id as $key=>$value){
  10. $sql2 = "INSERT INTO user_permissions(permission_id, employee_cd,module_id) values
  11. (PERMISSION_ID_seq.nextval,'$employee_cd','$value')";
  12. $this->db->db_query($sql2);
  13. }
  14.  
  15. $sub_module_id =$_POST['sub_module_permission'];
  16. print_r($sub_module_id);
  17.  
  18. foreach($sub_module_id as $sub_key=>$sub_value)
  19. {
  20. echo $sub_value[1];
  21.  
  22. $sql4 = "INSERT INTO user_permissions(permission_id, employee_cd,module_id) values
  23. (PERMISSION_ID_seq.nextval,'$employee_cd','$sub_value')";
  24.  
  25. if(!$result=$mysqli->query($query))
  26. throw new Exception($query. " " .$mysqli->error);
  27.  
  28. $sub_module_id =$_POST['sub_module_permission']; //a 2d array
  29. print_r($sub_module_id);
  30. foreach($sub_module_id as $sub_key=>$sub_value){
  31. echo $sub_value[1];
  32. $sql4 = "INSERT INTO user_permissions(permission_id, employee_cd,module_id)
  33. values(PERMISSION_ID_seq.nextval,'$employee_cd','$sub_value')";
  34. }
  35.  
  36. $sub_module_id =$_POST['sub_module_permission']; //a 2d array
  37. print_r($sub_module_id);
  38. foreach($sub_module_id as $sub_key=>$sub_value_arr){ //values are an array not a scalar
  39. echo $sub_value_arr[1];
  40. $sub_value= $sub_value_arr[1]; //get scalar for SQL
  41. $sql4 = "INSERT INTO user_permissions(permission_id, employee_cd,module_id)
  42. values(PERMISSION_ID_seq.nextval,'$employee_cd','$sub_value')";
  43. }
Add Comment
Please, Sign In to add comment