<?php
  header('Access-Control-Allow-Origin: *');
  // Variables

  // Connect to Database
  $username = "database_user";
  $password = "user_password";
  $servername = "localhost"; // if the php file and the sql server reside on the same server, it is usually localhost
  $dbname = "database_name";

  $id = $_GET['id'];
  $table = $_GET['table'];

  // Create connection
  $conn = new mysqli($servername, $username, $password, $dbname);

  // Check connection
  if ($conn->connect_error) {
      die("Connection failed: " . $conn->connect_error);
  }


  //create an array
  $emparray = array();
  while(1) {
    // Query
    $sql = "SELECT * FROM `" . $table . "` WHERE id = '" . $id . "'";

    // Result
    $result = mysqli_query($conn, $sql) or die("Error in Selecting " . mysqli_error($conn));

    $row = mysqli_fetch_assoc($result);
    $emparray[] = $row;
    if ($row["parent_id"] == NULL) {
        break;
    } else {
        $id = $row["parent_id"];
    }
  }

  echo json_encode($emparray);

  $conn->close();
?>