<?php
	require 'conect.php';

	$servername = "127.0.0.1";
	$usernamee = "root";
	$passwordd = "";
	$dbname = "ssrpdb";

	$conn = new mysqli($servername, $usernamee, $passwordd, $dbname);
	if(isset($_POST["login"]))
	{
	    $username = $_POST["username"];

	    $sql = "SELECT Username FROM characters WHERE Username ='$username'";
	    $result = $conn->query($sql);
		if ($result->num_rows > 0)
		{
			$sql = "SELECT * FROM characters WHERE Username ='$username'";
		    $result = $conn->query($sql);
		    if ($result->num_rows > 0)
		    {

		    	Foreach($result as $row)
		    	{
					$id = $row['ID'];
    				$_SESSION['usuarioID'] = $id;
				}
    			$_SESSION['usuarioNome'] = $username;
    			$_SESSION['usuarioPass'] = $password;


		        header('Location: ../../home.php');
		    }
		    else
		    {
		        echo "Senha incorreta";
		    }
		}
		else
		{
			echo"Não existe esse usuário no banco";
		}
	}
?>