<?php
	session_start();
	$error = '';

	if(isset($_POST['submit'])){
		if(empty($_POST['form_username']) || empty($_POST['form_password'])){
			$error = "Username or Password is invalid!";
		}else{
			// ******************* connection part *******************
			$servername = "localhost";
			$username = "one4112";
			$password = "JtQbDTAHY9aSQIUP";
			$dbname = "14112";

			$connection = new mysqli($servername, $username, $password, $dbname);

			if ($connection->connect_error){
				die("Connection failed: " . $connection->connect_error);
			}
			// **************** end of connection part ***************

			$checkUsername = $_POST['form_username'];
			$checkPassword = $_POST['form_password'];

			echo $checkUsername;
			echo "<br>";
			echo $checkPassword;

			$sql_query = "SELECT * FROM Login_Table
			              WHERE Login_Username = '$checkUsername'
						  AND Login_Password = '$checkPassword'";

			$result = $connection->query($sql_query);
			if($result->num_rows > 0){
				echo "YES";
				$_SESSION['login_user'] = $checkUsername;
				header('location: index.php');
			}else{
				echo "Incorrect username or password!";
			}
			$connection->close();
		}
	}
?>