<?php
$host='localhost';
$username='tan';
$password='1234567';
$db='feedback01';

$conn=mysqli_connect($host,$username,$password,$db);

if (!$conn)
  {
  die('Could not connect: ' . mysqli_connect_error());
  }
  $studentID=$_POST['StudentID'];

  $studentID=mysqli_real_escape_string($conn,$studentID);
  $query="SELECT * From PassportData WHERE StudentID='$studentID'";
  $result=mysqli_query($conn,$query);
  $response = array();
  if(mysqli_num_rows($result)>0)
    {
        $row = mysqli_fetch_assoc($result);
        $event = $row["Events"];
        $date = $row["Date"];
        $code = "login_success";
        array_push($response, array("code"=>$code, "Events"=>$event, "Date"=>$date));
        echo json_encode($response);
    }
    else{
        $code = "login_failed";
        $message = "not found!";
        array_push($response, array("code"=>$code, "messsage"=>$message));
        echo json_encode($response);
        }
    mysqli_close($conn);
 ?>