<?php
            try {
                $pdo = new PDO('mysql:host=localhost:3306;dbname=JHobby', 'root', '');
                $statement = $pdo->query("SELECT UserName, Password FROM users WHERE UserName = :username ");
                $statement->bindQuery(':username', $_POST['UserName']);
                $row = $statement->fetch(PDO::FETCH_ASSOC);
                var_dump($row); die();
            } catch (\Exception $e) {
                var_dump($e); die();
            }

            if ($UserName == $_POST['UserName']){
                if ($Password == $_POST['Password']){
                    echo "Login Successful";
                    header( "refresh:3;url=index.php" );
                } else{
                    echo "Wrong User Name or Password";
                    header( "refresh:3;url=login.php" );
                }

            } else{
                echo "Wrong User Name or Password";
                header( "refresh:3;url=login.php" );
            }

            ?>