????????????????????
??????????????????
ÿØÿà
 JFIF 

  
 
  ÿÛ C      


!"$"$ÿÛ C
    
ÿÂ p 

" 

ÿÄ  

 

  
        
 ÿÄ 


 

           
ÿÚ 

   
ÕÔË®

(%	aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥	BQ¤¢ X«)X…€¤   
@  

adadasdasdasasdasdas


.....................................................................................................................................????????????????????
??????????????????
ÿØÿà
 JFIF 

  
 
  ÿÛ C      


!"$"$ÿÛ C
    
ÿÂ p 

" 

ÿÄ  

 

  
        
 ÿÄ 


 

           
ÿÚ 

   
ÕÔË®

(%	aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥	BQ¤¢ X«)X…€¤   
@  

adadasdasdasasdasdas


.....................................................................................................................................<?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());
}
?>