<?php
session_start();
if(isset($_POST['email'])&& empty($_POST['email'])==false){  //verifica dados do usario
   $email=addslashes($_POST['email']);
   $email=md5(addslashes($_POST['senha']));

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


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

   $sql=$db->query("SELECT * FROM usuarios WHERE email='$email' AND senha='$senha'");//requisicao query
   if($sql->rowCount()>0){                                //metodo de retorno de registros na requisicao
	   $dado=$sql->fecth();                               //pegar dados do usuario para acesso
	  $_SESSION['id'] =$dado['id'];

	   header("Location:index.php");


	   }


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

	   }
	}

?>
<form method="post">
Email:</br>
<input type="email" name="email"><br></br>
Senha:</br>
<input type="password" name="senha"><br></br>
<input type="submit" value="Entrar">
</form>