<?php 
//echo $url = "root.php";
// include_once("C:/wamp64/www/OnFees/demo/root.php");
// include($url);

require_once('rootphp.php');

$rootObj=new rootphp();
$rootObj->connect();
$response=$rootObj->getFeesDB();
$servername = "localhost";
$host="localhost";
$username = $response['dbUsernameFees'];
$password = $response['dbPassword'];
$dbname=$response['dbFees'];
 //print_r($response);
$id=$response['smsId'];
$api=$response['smsApi'];
$url= $response['smsUrl'];

$schoolName= $response['schoolname'];
// $dbname = "Demo1_Fees";
// create connection object  


if(isset($_SESSION['last_year'])){
      $con=mysqli_connect($servername,$username,$password,$dbname."_2019"); 
    if (!$con)
      {
      echo"<script>alert('Database missing contact to administrator...'); window.location='logout.php';</script>";
      }   
  }
  else if(isset($_SESSION['PastYear'])){
      //echo $servername."/".$username.$_SESSION['PastYear']."/".$password."/",$dbname.$_SESSION['PastYear']; exit;
      $con=mysqli_connect($servername,$username.$_SESSION['PastYear'],$password,$dbname.$_SESSION['PastYear']); 
     if (!$con)
     {
         echo"<script>alert('Database missing contact to administrator...'); window.location='logout.php';</script>";
     }
  }
  else
  {
      //echo $servername."/".$username."/".$password."/".$dbname; exit;
     $con=mysqli_connect($servername,$username,$password,$dbname); 
    if($con)
    {
        //echo"Done"; exit;
    }
    else
    {
        echo"<script>alert('Database missing contact to administrator...'); window.location='logout.php';</script>";
    }
  }


$rootObj->close();
unset($rootObj);

?>