Advertisement
amirhusin17

fetch ajax updated

Feb 21st, 2019
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.98 KB | None | 0 0
  1. <?php
  2.  
  3. include ("../connection.php");
  4. //fetch.php
  5. if(isset($_POST["tahun_id"]) && !empty($_POST["tahun_id"])){
  6. $query = $con->query("SELECT * FROM bulan WHERE tahun = ".$_POST['tahun_id']);
  7. $rowCount = $query->num_rows;
  8. if($rowCount > 0){
  9. echo '<option value="">-- Select Month --</option>';
  10. while($row = $query->fetch_assoc()){
  11. echo '<option value="'.$row['bulan'].'">'.$row['bulan'].'</option>';
  12. }
  13. }else{
  14. echo '<option value="">-- Select Month --</option>';
  15. }
  16. }
  17. if(isset($_POST["bulan_id"]) && !empty($_POST["bulan_id"])){
  18. $query = $con->query("SELECT * FROM blok WHERE bulan = ".$_POST['bulan_id']);
  19. $rowCount = $query->num_rows;
  20. if($rowCount > 0){
  21. echo '<option value="">-- Select Block --</option>';
  22. while($row = $query->fetch_assoc()){
  23. echo '<option value="'.$row['blok'].'">'.$row['blok'].'</option>';
  24. }
  25. }else{
  26. echo '<option value="">-- Select Block --</option>';
  27. }
  28. }
  29. if(isset($_POST["block_id"]) && !empty($_POST["block_id"])){
  30. $query = $con->query("SELECT * FROM tingkat WHERE blok = ".$_POST['block_id']);
  31. $rowCount = $query->num_rows;
  32. if($rowCount > 0){
  33. echo '<option value="">-- Select Level --</option>';
  34. while($row = $query->fetch_assoc()){
  35. echo '<option value="'.$row['tingkat'].'">'.$row['tingkat'].'</option>';
  36. }
  37. }else{
  38. echo '<option value="">-- Select Level --</option>';
  39. }
  40. }
  41. if(isset($_POST["level_id"]) && !empty($_POST["level_id"])){
  42. $query = $con->query("SELECT * FROM unit WHERE tingkat = ".$_POST['level_id']);
  43. $rowCount = $query->num_rows;
  44. if($rowCount > 0){
  45. echo '<option value="">-- Select Unit --</option>';
  46. while($row = $query->fetch_assoc()){
  47. echo '<option value="'.$row['unit'].'">'.$row['unit'].'</option>';
  48. }
  49. }else{
  50. echo '<option value="">-- Select Unit --</option>';
  51. }
  52. }
  53. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement