<?php
    $sql_servername = "localhost:3306";
    $sql_username = "root";
    $sql_password = "";
    $sql_database = "3519DB";

    $usr = $_GET["usrKey"];
    $pass = $_GET["passKey"];
    $action = $_GET["actionKey"];

    // Create connection
    $conn = new mysqli($sql_servername, $sql_username, $sql_password);

    // Check connection
    if ($conn->connect_error)
    {
        echo("Connection failed: " . $conn->connect_error);
        echo "</br>";
    }
    echo "Connected successfully";
    echo "</br>";

    $sql = "CREATE DATABASE IF NOT EXISTS " . $sql_database;

        if($conn->query($sql) === TRUE)
        {
            echo "Database created or accessed succesfully";
            echo "</br>";
            if($conn -> select_db($sql_database))
            {
                echo "connected to database";
                echo "</br>";
            }
            else
            {
                echo "database connection failed " . $conn -> error;
                echo "</br>";
            }
        }
        else
        {
            echo "Error creating database: " . $conn->error;
            echo "</br>";
        }

    if($action === "'NewUser'")
    {

       // $usr = $conn -> real_escape_string($usr);
       // $pass = $conn -> real_escape_string($pass);
        echo "New User";
        echo "</br>";
        NewUser($conn,$usr,$pass);
    }

    if($action === "'FindPassword'")
    {
        echo "Find Password";
        echo "</br>";
        FindPassword($conn, $usr);
    }

    if($action === "'LogIn'")
    {
        echo "LogIn";
        echo "</br>";
        LogIn($conn,$usr,$pass);
    }

    function NewUser($conn, $usr,$pass)
    {



        #Check if table exsits
        $sql = "SELECT USERNAME FROM USERS";

        if($conn -> query($sql))
        {
            echo "Table Exists";
            echo "</br>";
        }
        else
        {
            echo ($conn -> error);
            echo "</br>";

            $sql = "CREATE TABLE USERS (
                USERNAME varchar(255),
                PASSWORD varchar(255),
                PRIMARY KEY (USERNAME)
            )";

            if($conn -> query($sql) === TRUE)
            {
                echo "Table created";
                echo "</br>";
            }
            else
            {
                echo ("table creation failed " . $conn -> error);
                echo "</br>";
            }
        }

        $sql = "INSERT INTO USERS
            (USERNAME, PASSWORD) VALUES
            ($usr, $pass)";

        if($conn -> query($sql) === TRUE)
        {
            echo "Record inserted";
            echo "</br>";
            echo "<b>User created!<b/>";

        }
        else
        {
            echo ($conn -> error);
            echo "</br>";
            echo "<b>User already exists!<b/>";
        }
    }




    function FindPassword($conn, $usr)
    {
        $sql = "SELECT * FROM USERS WHERE USERNAME = $usr";
        $result = $conn -> query($sql);

        if($result === FALSE)
        {
            echo $conn -> error;
        }

        if( $result -> num_rows > 0)
        {
            while($row = $result -> fetch_assoc())
            {
                echo "<b>Username = " . $row["USERNAME"] . ", Password = " . $row["PASSWORD"] . "<b/>";
                echo "</br>";
            }
        }
        else
        {
            echo "Username not found";
        }
    }

    function LogIn($conn,$usr,$pass)
    {
        $sql = "SELECT PASSWORD FROM USERS WHERE USERNAME = $usr";

        $result = $conn -> query($sql);

        if($result === FALSE)
        {
            echo $conn -> error;
        }

        if( $result -> num_rows > 0)
        {
            while($row = $result -> fetch_assoc())
            {
                if("'" . $row["PASSWORD"]  ."'" === $pass)
                {
                    echo "Login Sucessful";
                    echo "</br>";
                }
                else
                {
                    echo "Login Unsucessful";
                    echo "</br>";
                }
            }
        }
        else
        {
            echo "User Not Found";
            echo "</br>";
        }
    }
?>