<?php
require_once 'db_connect.php';

if((!isset($_POST['email']))||(!isset($_POST['password'])))
{
    header('Location: index.php');
    exit();
}
else
{
    if(empty($_POST['email']))
    {
        print_r("Enter valid e-mail");
    }
    else
    {
        if(empty($_POST['password']))
        {
            print_r("Enter valid password");
        }
         else
        {
            $dbconnect = new PDO('mysql:host=localhost;dbname=db_users',$user ,$pass);
            $received_email = $_POST['email'];
            $received_password = $_POST['password'];
            $select_user = "SELECT * FROM users WHERE email='".$received_email."' AND password='".$received_password."'";
            $statement = $dbconnect->query($select_user);
            $row_count = $statement->rowCount();
            $q = $dbconnect->query($select_user);
            $q->setFetchMode(PDO::FETCH_ASSOC);
            if($row_count != 1 )
            {
                print_r("Invalid username or password");
            }
            else
            {
                while ($row = $q->fetch()){
                    echo htmlspecialchars($row['name']).'<br>';
                    echo htmlspecialchars($row['surname']).'<br>';
                    echo htmlspecialchars($row['nickname']).'<br>';
                }
            }
    }
}
}