<?php
  session_start();
 
class rootphp
{
    private $con;
	function __construct() {
    //   echo "object create<br>";
    }	
    public function connect()
    {
        // echo "connect<br>";
         $servername = "localhost";
 $host="localhost";



 $host="localhost";
$username = "u926327694_raghuadmin1233";                
$password = "Raghu@48221";
$dbname = "u926327694_admin_onlinefe";

// $dbname = "superadmin";

 $this->conRoot=mysqli_connect($servername,$username,$password,$dbname); 
//  print_r($this->conRoot);
    }
    public function close() {
        mysqli_close($this->conRoot);
        // echo "close<br>";
    }
    public function getRoot()
    {
     session_start();
  $link=$_SESSION["code"];
 //echo $link; exit;
return $link;
 
    }

    public function getAllData()
    {
    	$root=$this->getRoot();
    	$response=array();
    	$res=mysqli_query($this->conRoot,"SELECT * FROM `schools` WHERE `schoolCode` = '$root'")or die(mysqli_error($this->conRoot));
    	while($data=mysqli_fetch_array($res))
    	{
    		$response[]=$data;
    	}
    	return $response;
    }


    public function getFeesDB()
    {
      
        // echo "getFeesDB<br>";
         $root=$this->getRoot();
        $response=array();
        //  echo "SELECT `dbFees`,`dbUsername`,`dbPassword`,`dbStudent` FROM `schools` WHERE `schooldomain` = '$root'";
        $res=mysqli_query($this->conRoot,"SELECT `dbFees`,`dbUsernameFees`,`dbPassword`,`dbStudent` FROM `schools` WHERE `schoolCode` = '$root'")or die(mysqli_error($this->conRoot));
        
        // echo "SELECT `dbFees`,`dbUsername`,`dbPassword`,`dbStudent` FROM `schools` WHERE `schooldomain` = '$root'";
        
        while($data=mysqli_fetch_assoc($res))
        {
            // print_r($data);
             
            $response['dbUsernameFees']=$data['dbUsernameFees'];
           $response['dbPassword']=$data['dbPassword'];
           // $response['dbLibrary']=$data['dbLibrary'];
             $response['dbFees']=$data['dbFees'];
               $response['smsId']=$data['smsId'];
            $response['smsApi']=$data['smsAPI'];
             $response['smsUrl']=$data['smsURL'];
             $response['schoolname']=$data['schoolname'];
             
        }
        return $response;
    }

}



 



?>