<?php
     								if (isset($_POST['loginBtn']))
     								{
     									$username = $_POST['username'];
     									$password = $_POST['password'];
     									$errors = array();
     									if (empty($username) || empty($password))
     									{
     										$errors[] = 'Please fill in all fields';
     									}

     									if (empty($errors))
     									{
     										$SQLCheckLogin = $odb -> prepare("SELECT COUNT(*) FROM `accounts` WHERE `Username` = :username AND `Key` = :password");
     										$SQLCheckLogin -> execute(array(':username' => $username, ':password' => $password));
     										$countLogin = $SQLCheckLogin -> fetchColumn(0);
     										if ($countLogin == 1)
     										{
     											$SQLGetInfo = $odb -> prepare("SELECT `Username`, `id` FROM `accounts` WHERE `username` = :username AND `Key` = :password");
     											$SQLGetInfo -> execute(array(':username' => $username, ':password' => $password));
     											$userInfo = $SQLGetInfo -> fetch(PDO::FETCH_ASSOC);
     												$_SESSION['Username'] = $userInfo['Username'];
                           									 $_SESSION['id'] = $userInfo['id'];
     												echo 'Successful Login.';
     											}
     										}
     										else
     										{
     											echo 'Error: Login Failed.';
     										}
     									}

     								}
     							?>