<?php
$migration_query = "";
/*ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);*/
if(isset($_GET['pwd']))
{
    if(base64_encode("Admin@123")==$_GET['pwd'])
    {
        include"smart/config.php";
        $main_username="";
        $main_password="";
        $main_dbname="";
        $school_code = "";
        $sel_School = mysqli_query($con,"select * from schools");
        $update_message = "";
        while($row_school = mysqli_fetch_array($sel_School)) {
            $school_code = $row_school['school_code'];
            $main_username=$row_school['db_user'];
            $main_password=$row_school['db_pwd'];
            $main_dbname=$row_school['db'];
            $con_school=mysqli_connect("localhost",$main_username,$main_password,$main_dbname);
            if($con_school) {
                $upd = mysqli_query($con_school,$migration_query);
                if($upd) {
                    $update_message .= "<p style='color:green'>". $school_code." = Migration updated.</p>";
                }
                else {
                    $update_message .= "<p style='color:red'>". $school_code." = Migration Failed.</p>";
                }
                mysqli_close($con_school);
            }
            else {
                $update_message .= "<p style='color:red'>". $school_code." = Migration Failed because unable to connect database.</p>";
            }
        }
        echo $update_message; exit;
    }
    else
    {
        echo"Access Denied"; exit;
    }
}
else
{
    echo"Access Denied"; exit;
}
?>