<?php
session_start();

if(isset($_POST['email']) && empty($_POST['email']) == false){

	$email = addslashes($POST['email']);
	$senha = md5(addslashes($POST['senha']));

	$dsn = "mysql=dbname=blog;host=localhost";
	$dbuser = "root";
	$dbpass = "";

try {
	$db = new PDO($dsn, $dbuser, $dbpass);

	$sql = $db->query("SELECT * FROM users WHERE email = '$email' AND senha = '$senha'");

	if($sql->rowCount() > 0){

		$dado = $sql->fetch();

		print_r($dado);

	$_SESSION['id'] = $dado['id'];

		header("Location: index.php");
	}

} catch (PDOException $e) {
	echo "Falhou: ".$e->getMessage();
}

}

?>

<h2>Pagina de Login</h2>

<form method="POST">

	E-mail:<br>
	<input type="email" name="email"><br><br>

	Senha:<br>
	<input type="password" name="senha"><br><br>

	<input type="submit" value="Entrar">

</form>