<?php
$host = 'mysql.hostinger.in';
$db = 'u138456024_regix';
$user = 'u138456024_regix';
$pass = '10Aadhil@';
$charset = 'utf8';
$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
$password=$_POST['password'];
$username=$_POST['username'];
$regix_id=$_POST['regix_id'];
try{
    $opt = [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES => false
];
$pdo = new PDO($dsn, $user, $pass, $opt);
$table_name=$regix_id.'_staff_list';
$stm=$pdo->prepare("select password from ? where username=?");
$stm->execute([$table_name,$username]);
$y=$stm->fetchColumn();
if(password_verfiy($password,$y))
{
    $json_array[0]["name"]=" ";
    $i=0;
    $table_name=$regix_id.'_subject_handling';
    $stmt=$pdo->prepare("select department,year,section,subject from ? where username = ?");
    $stmt->execute([$table_name,$username]);
    while($row=$stmt->fetch())
    {
        $json_array[$i]["name"]=$row['subject'];
        $json_array[$i]["department"]=$row['department'];
        $json_array[$i]["year"]=$row['year'];
        $json_array[$i]["section"]=$row['section'];
        $table_name=$regix_id.'_student_list';
        $stmt1=$pdo->prepare("select register_number,name from ? where department=? and year=? and section=?");
        $stmt1->execute([$table_name,$json_array[$i]["department"],$json_array[$i]["year"],$json_array[$i]["section"]]);
        $j=0;
        while($row1=$stmt1->fetch())
        {
            $json_array[$i]["students"][$j][0]=$row1["name"];
            $json_array[$i]["students"][$j][1]=$row1["register_number"];
            $j=$j+1;
        }
        $table_name=$regix_id+"_"+$row['department']+"_"+$row['year']+"_"+$row['section'];
        $array_of_day=["monday","tuesday","wednesday","thursday","friday"];
        $h=0;
        foreach($array_of_day as $array_list)
        {
            $query="select period from ? where ".$array_list."=?";
            $stmt2=$pdo->prepare($query);
            $stmt2->execute($table_name,$json_array[$i]["name"]);
            $j=0;
            while($row3=$stm2->fetch())
            {
                $json_array[$i]["schedule"][$h][$j]=$row3['period'];
                $j++;
            }
            $h++;
        }
        $i=$i+1;
    }
    json_encode($json_array);
}
else
{
    echo "invalid credentials";
}
    $pdo=null;
}
catch(PDOException $p)
{
    echo "error in pdo".$p->getMessage();
}
?>