<?php 
session_start();
include_once('include/config.inc.php');
$operation=$_POST['operation'];
$emparray=array();
if($operation=="student"){
    $studentQ=mysqli_query($con,"select name from admission_enquiry_form where student_id='".$_POST['id']."'");
    $emparray[]=mysqli_fetch_array($studentQ);
    $issuedQ=mysqli_query($con,"select book.book_name,book.isbn,book.id as book_id from issue_book
        left join book on book.id=issue_book.book_id
        where issue_book.student_id='".$_POST['id']."' AND issue_book.returned=0");
    while($issuedR=mysqli_fetch_array($issuedQ)){
        $emparray[]=$issuedR;
    }
}else if($operation=="book"){
    $check = "select * from book where id='".$_POST['id']."' ";
    $result1 = mysqli_query($con, $check) or die("Error in Selecting " . mysqli_error($con));
    $emparray=mysqli_fetch_array($result1);
}
    echo json_encode($emparray);
    
    mysqli_close($con);
?>