LOGIN

<?php


    $user = $_POST['user'];
    $senha =  $_POST['senha'];


    $servername = "pousada.uapi.edu.br";
    $username = "phpaIHC20152";
    $password = "isuahv62@SU";
    $dbname = "pedroalb_ihc20152";



    // Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);

    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }


    $sql = "SELECT * FROM Users WHERE user ='".$user."' AND senha ='".$senha."'";
    $result = $conn->query($sql);

    while($row = $result->fetch_assoc()){
        session_start();
        $_SESSION['login'] = $login;
        $_SESSION['senha'] = $senha;
        $_SESSION['uid'] = $row['Id'];
        $_SESSION['img'] = $row['Img_Prof'];
        $_SESSION['nome'] = $row['Nome'];
        $_SESSION['descri'] = $row['Descri'];
        header('location:browse.php');
    }
?>