Advertisement
Guest User

Untitled

a guest
Mar 8th, 2019
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.67 KB | None | 0 0
  1. <div class="form-group">
  2. <label class="control-label col-sm-4" for="level">Level</label>
  3. <div class="col-sm-4">
  4. <select name="level" id="level" class="form-control">
  5. <option value="null">-- Level --</option>
  6. <option value="admin">Admin</option>
  7. <option value="staff">Staff</option>
  8. <option value="client">Client</option>
  9. </select>
  10. </div>
  11. </div>
  12. <div class="form-group">
  13. <label class="control-label col-sm-4" for="department">Department</label>
  14. <div class="col-sm-4">
  15. <select name="department" id="department" class="form-control">
  16.  
  17. </select>
  18. </div>
  19. </div>
  20. $("#level").change(function(){
  21.  
  22. // variabel dari nilai combo box provinsi
  23. var id = $("#level").val();
  24.  
  25.  
  26. // mengirim dan mengambil data
  27. $.ajax({
  28. type: "POST",
  29. dataType: "html",
  30. url: "search_level.php",
  31. data: "level="+id,
  32. success: function(msg){
  33.  
  34. // jika tidak ada data
  35. if(msg == ''){
  36. var x=document.getElementById("department")
  37. x.value=""
  38. x.disabled=true
  39. }
  40. // jika dapat mengambil data,, tampilkan di combo box kota
  41. else{
  42. var x=document.getElementById("department")
  43. x.disabled=false
  44. $("#department").html(msg);
  45. }
  46. }
  47. });
  48. });
  49.  
  50. <?php
  51.  
  52. include "../config/koneksi.php";
  53.  
  54. $name = $_POST['name'];
  55. $user = $_POST['username'];
  56. $password = md5($_POST['password']);
  57. $level = $_POST['level'];
  58. $deparment = $_POST['department'];
  59.  
  60. $status = '1';
  61. $tgl_dibuat = date("Y-m-d h:i:s");
  62.  
  63. $query = mysqli_query($con, "INSERT INTO user (nama,user,password,level,department,tgl_dibuat,status) VALUES ('$name','$user',
  64. '$password','$level','$deparment','$tgl_dibuat','$status')");
  65.  
  66. if ($query) {
  67. ?>
  68. <script language="JavaScript">
  69. alert('User Saved');
  70.  
  71. </script>
  72. <?php
  73. } else {
  74. ?>
  75. <script language="JavaScript">
  76. alert('Failed');
  77. document.location='user';
  78. </script>
  79. <?php
  80. }
  81. ?>
  82.  
  83. <?php
  84. include "../config/koneksi.php";
  85.  
  86. $id = $_POST['level'];
  87.  
  88. $query = mysqli_query($con, "SELECT * FROM department WHERE level='$id'");
  89. while($data_prov=mysqli_fetch_array($query)){
  90. ?>
  91. <option value="<?php echo $data_prov["department"] ?>"><?php echo $data_prov["department"] ?></option><br>
  92.  
  93. <?php
  94. }
  95. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement