<?php

$host = "localhost";
$dbname = "tennis";
$username = "root";
$password = "";

//Start the Session
session_start();

$pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $username, $password);



//3. If the form is submitted or not.
//3.1 If the form is submitted
if (isset($_POST['email']) and isset($_POST['password'])){

//3.1.1 Assigning posted values to variables.
$email = $_POST['email'];
$password = $_POST['password'];

var_dump($_POST); die;


//3.1.2 Checking the values are existing in the database or not
$query = "SELECT * FROM `users` WHERE email='$email' and password='$password'";

$result = $pdo->query("SELECT * FROM users WHERE email='$email' and password='$password'")->fetch(PDO::FETCH_ASSOC);

var_dump($result); die;

$result = mysqli_query($connection, $query) or die(mysqli_error($connection));
$count = mysqli_num_rows($result);

//3.1.2 If the posted values are equal to the database values, then session will be created for the user.
if ($count == 1){
$_SESSION['username'] = $username;
}else{

//3.1.3 If the login credentials doesn't match, he will be shown with an error message.
$fmsg = "Invalid Login Credentials.";
}
}

//3.1.4 if the user is logged in Greets the user with message
if (isset($_SESSION['username'])){
$username = $_SESSION['username'];
echo "Hai " . $username . "
";
echo "This is the Members Area
";
echo "<a href='logout.php'>Logout</a>";

}else{
//3.2 When the user visits the page first time, simple login form will be displayed.

}
require('login.phtml');
die;