<?php
    include("config/dbconnect.php");
    
    if(isset($_GET['SearchText']))
    {
        $SearchText=$_GET['SearchText'];
        $sel_school=mysqli_query($con,"SELECT * FROM schools WHERE IsActive=1 AND (schoolname like '%$SearchText%' OR schoolCode like '%$SearchText%')");
        $SchoolRow=[];
        $i=0;
        while($rows=mysqli_fetch_array($sel_school))
        {
            $SchoolRow[$i]["schoolname"]=$rows['schoolname'];
            $SchoolRow[$i]["schoolcode"]=$rows['schoolCode'];
            $i=$i+1;
        }
        //echo"<pre>"; print_r($SchoolRow); exit;
        echo json_encode($SchoolRow);
    }
?>