Advertisement
Guest User

Untitled

a guest
Jul 16th, 2016
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.49 KB | None | 0 0
  1. <?php
  2.  
  3.     // Pengaturan server
  4.     $servername = "localhost";
  5.     $username = "root";
  6.     $password = "";
  7.     $dbname = "dummy_pdx";
  8.  
  9.     // Server Listener
  10.     if(isset($_GET['kunci'])){
  11.         if($_GET['kunci'] == "mapel" && isset($_GET['id_pendidikan'])){
  12.             $hasil = ambilMataPelajaran($_GET['id_pendidikan']);
  13.             echo json_encode($hasil);
  14.         }
  15.     }
  16.  
  17.     // Template fungsi untuk pengambilan data
  18.     function selectDataFromDB($query){
  19.         global $servername, $username, $password, $dbname;
  20.  
  21.         // Create connection
  22.         $conn = new mysqli($servername, $username, $password, $dbname);
  23.  
  24.         // Check connection
  25.         if ($conn->connect_error) {
  26.             die("Connection failed: " . $conn->connect_error);
  27.         }
  28.  
  29.         $result = $conn->query($query);
  30.  
  31.         $conn->close();
  32.  
  33.         if ($result->num_rows > 0)
  34.             return $result;
  35.             // output data of each row
  36.             // while($row = $result->fetch_assoc()) {
  37.             //     echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
  38.             // }
  39.         else
  40.             return null;
  41.     }
  42.  
  43.     // Fungsi spesifik untuk mengambil list mata pelajaran pada pendidikan tertentu
  44.     function ambilMataPelajaran($idPendidikan){
  45.         $sql = "SELECT * FROM Mata_Pelajaran WHERE id_mapel IN (SELECT id_mapel FROM Mapel_Spesifik WHERE id_pendidikan = '$idPendidikan');";
  46.  
  47.         $dataForm = selectDataFromDB($sql);
  48.  
  49.         if($dataForm == null){
  50.             return array();
  51.         }else{
  52.             $data = array();
  53.             while($row = $dataForm->fetch_assoc())
  54.                 array_push($data, $row);
  55.  
  56.             return $data;
  57.         }
  58.     }
  59. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement