<?php
session_start();
header('Access-Control-Allow-Origin: *');

//Conexão MYSQLI - LOGIN GLOBAL
$mysqli = new mysqli('localhost', 'login', 'senha', 'bancodedados');

?>

<?php
include 'conn-login.php';

header('Content-Type: application/json');

if($_SERVER['REQUEST_METHOD'] == 'POST'){

    $email_l = $_POST['email'];
    $senha_l = md5($_POST['senha']);

    $sql = "SELECT u.id, u.id_farmacia, u.usuario, u.email, u.senha, u.accesskey, f.db_database, f.db_username, f.db_password FROM usuarios u INNER JOIN farmacias f ON u.id_farmacia = f.id WHERE (email =? AND senha =?) LIMIT 1";
    $stmt = $mysqli->prepare($sql);
    $stmt->bind_param('ss', $email_l, $senha_l);
    $stmt->execute();
    $stmt->bind_result($id, $id_farmacia, $usuario, $email, $senha, $accesskey, $database, $dbuser, $dbpass);
    $stmt->store_result();

    if($stmt->num_rows <= 0){

        $var = Array(
            'status' => 'ERRO',
            'msg' => 'Usuário não cadastrado e/ou senha incorreta!'
        );

    } else {

        while ($ln = $stmt->fetch()){

            $_SESSION['database'] = $database;
            $_SESSION['dbuser'] = $dbuser;
            $_SESSION['dbpass'] = $dbpass;

            $var = Array(
                'status' => 'OK',
                'accesskey' => $accesskey
            );
        };

    }
}
echo json_encode($var);
exit;
$stmt->close();

?>

<?
if((!isset ($_SESSION['dbuser']) == true) and (!isset ($_SESSION['dbpass']) == true))
{
    unset($_SESSION['database']);
    unset($_SESSION['dbuser']);
    unset($_SESSION['dbpass']);
    echo("<script type='text/javascript'> alert('Sem sessões definidas =/'); location.href='index.html';</script>");
    header('location: login.html');
}
//Conexão MYSQLI
$db = $_SESSION['database'];
$dbuser = $_SESSION['dbuser'];
$dbpass = $_SESSION['dbpass'];

$mysqli = new mysqli('localhost', $dbuser, $dbpass, $db);

$mysqli->query("SET NAMES 'utf8'");
$mysqli->query('SET character_set_connection=utf8');
$mysqli->query('SET character_set_client=utf8');
$mysqli->query('SET character_set_results=utf8');

//Data Padrão do Brasil (GMT -3)
date_default_timezone_set('America/Sao_Paulo');

?>