<?php
session_start();
$user="root";
$pass="";
$host="localhost";
$dbnamne="neardeal";

$username = $_REQUEST['username'];
$password = $_REQUEST['password'];

//create connection
$conn = new mysqli($host, $user, $pass, $dbnamne);

//check connection
if($conn->connect_error){
    die("connection failed" .$com->connect_error);
}

$sql = "SELECT * FROM user WHERE username='{$username}' AND password='{$password}' LIMIT 1";

$result = $conn->query($sql);
$user = array();

while($row =$result->fetch_assoc()){
    $user = $row;
}

if(!empty($user)) {
    $_SESSION['user_id'] = $user['id'];

    echo json_encode(array(
        'success' => true,
        'user' => $user
    ));
}
else {
    echo json_encode(array(
        'success' => false,
        /** return empty user to prevent error when java converting to user object*/
        'user' => array(
            'id'=>0,
            'username'=>'',
            'password'=>''
        )
    ));
}