Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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');
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement