<?php

require_once "dbconnect5.php";
require_once "queries2.php";
print_r("Hello: ");
if($link)
{
    
    $username_in = trim($_POST['username']);
    $password_in = trim($_POST['password']);
    
    echo "\npratham2";
    
    $query_login = $link->prepare($sql_login);
    $query_login->execute();
    //$query_login->nextRowset();
    echo "\npratham3";
        
        //$result_login = $query_login->fetch();
    $result_login = $query_login->fetch(PDO::FETCH_ASSOC);
    //$result_login = $query_login->fetch(PDO::PARAM_OUTPUT);
    //$result_login = $query_login->fetchAll();
       echo "result: " + $result_login;
       echo "query: " + $query_login;
        if( !empty($result_login)) 
        {
            echo "\npratham4";            
            
            $return_op['code']="200";
            $return_op['status']="1";
            $return_op['data']=$result_login;
            $return_op['message']="Login Successful...";
            echo json_encode($return_op);
       
        } 
        else {
            echo "\npratham5";
            $return_op['code']="500";
            $return_op['status']="0";
            $return_op['message']="Invalid Credentials...";
            
            echo json_encode($return_op);
        }
        
        echo "\npratham6";
        
}
else
{
    echo "\npratham7";
    $return_op['code']="500";
    $return_op['status']="0";
    $return_op['message']="Something went wrong. Please contact system administrator.";
            
    echo json_encode($return_op);
}
        

?>