??????????????
??????????????
<?php
include 'connection.php';

if(isset($_POST['query'])){
    $query = $_POST['query'];
    $sql = "SELECT admission_no, student_name FROM admission WHERE admission_no LIKE '%$query%' LIMIT 10";
    $res = $conn->query($sql);
    while($row = $res->fetch_assoc()){
        echo '<div class="admission_item suggestion-item" data-no="'.$row['admission_no'].'">'.$row['admission_no'].' - '.$row['student_name'].'</div>';
    }
}

if(isset($_POST['admission_no'])){
    $admission_no = $_POST['admission_no'];
    $sql = "SELECT * FROM admission WHERE admission_no = '$admission_no'";
    $res = $conn->query($sql);
    echo json_encode($res->fetch_assoc());
}
?>