Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- // Pengaturan server
- $servername = "localhost";
- $username = "root";
- $password = "";
- $dbname = "dummy_pdx";
- // Server Listener
- if(isset($_GET['kunci'])){
- if($_GET['kunci'] == "mapel" && isset($_GET['id_pendidikan'])){
- $hasil = ambilMataPelajaran($_GET['id_pendidikan']);
- echo json_encode($hasil);
- }
- }
- // Template fungsi untuk pengambilan data
- function selectDataFromDB($query){
- global $servername, $username, $password, $dbname;
- // Create connection
- $conn = new mysqli($servername, $username, $password, $dbname);
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $result = $conn->query($query);
- $conn->close();
- if ($result->num_rows > 0)
- return $result;
- // output data of each row
- // while($row = $result->fetch_assoc()) {
- // echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
- // }
- else
- return null;
- }
- // Fungsi spesifik untuk mengambil list mata pelajaran pada pendidikan tertentu
- function ambilMataPelajaran($idPendidikan){
- $sql = "SELECT * FROM Mata_Pelajaran WHERE id_mapel IN (SELECT id_mapel FROM Mapel_Spesifik WHERE id_pendidikan = '$idPendidikan');";
- $dataForm = selectDataFromDB($sql);
- if($dataForm == null){
- return array();
- }else{
- $data = array();
- while($row = $dataForm->fetch_assoc())
- array_push($data, $row);
- return $data;
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement