Advertisement
amirhusin17

fetch ajax

Feb 20th, 2019
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.99 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_id = ".$_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_id'].'">'.$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_id'].'">'.$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_id'].'">'.$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_id'].'">'.$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