<?php
$DB_host = "localhost";
$DB_user = "u194461326_madonna";
$DB_pass = "PMadonna@2024";
$DB_name = "u194461326_madonna";


	try
	{
		$DBcon = new PDO("mysql:host={$DB_host};dbname={$DB_name}",$DB_user,$DB_pass);	
		$DBcon->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	}
	catch(PDOException $e)
	{
		echo "ERROR : ".$e->getMessage();
	}

 $term=$_GET["term"];
 $stmt = $DBcon->prepare("SELECT * FROM students where studentname like '%".$term."%' order by studentname");
$stmt->execute();
 $json=array();
 
    while($row=$stmt->FETCH(PDO::FETCH_ASSOC))
	{
         $json[]=array(
                    'value'=> $row["regno"],
					
                    'label'=>$row["studentname"]." - ".$row["regno"]
                        );
    }
 
 echo json_encode($json);
 
?>