<?php

$FuserName = $_POST["userName"];
$Fpassword = $_POST["password"];
$username = 'ADMIN';
$pass = 'ADMIN';
$db = "pym";

$link = mysqli_connect("localhost", $username, $pass);
if (!$link) {
    die("Could not connect: " . mysqli_connect_error());
}
echo "Connected successfully";

$db_selected = mysqli_select_db($link, "pym");
if (!$db_selected) {
    die ("Can't use pym : " . mysqli_connect_error());
}
echo "<br>Selected successfully";
$user = mysqli_fetch_array(mysqli_query($link, "SELECT * FROM `users` WHERE `UserName` = '$FuserName'"));
if($user == 0)
{
    die("Wrong username or password. please <a href='login.html'>try again</a>");
}
if($user['UserPassword'] != $Fpassword)
{
    die("Wrong usernmae or password. please <a href='login.html'>try again</a>");
}

echo "Logged in successfully<br>";
mysqli_close($link);
echo "<a href = 'mainConnectedPage.html'>CLICK HERE TO CONTINUE</a>"

?>