register

<!DOCTYPE HTML>
<?php
    include ('/lib/function.php');
    // Start the session
    session_start();


    // Connessione al DB
    $dbconn = pg_pconnect("host=localhost port=5432 dbname=postgres user=postgres password=Fleabasser96")
    or die('Could not connect: ' . pg_last_error());

    // User psw e nick = post
    $username = $_POST['username'];
    $password = $_POST['password'];
    $nickname = $_POST['nickname'];

    // Query per controllo esistenza e inserimento
    $sql_check_user = "SELECT email,password FROM public.utenti WHERE email='$username'";
    $sql_check_nick = "SELECT email,password FROM public.utenti WHERE nickname='$nickname'";
    $sql_insert = "INSERT INTO public.utenti VALUES('$username', '$password', '$nickname')";
    $success_user = false;
    $success_nick = false;
    // messaggio
    $error = "";

    // controllo se sono già loggato
    if (isset($_SESSION['loggedIn']) && $_SESSION['loggedIn'] == true) {
        $error = "success";
        header('Location: account.php');
    }

    // Controllo se sono stati inseriti
        // Se si controllo se esiste già il nick o la mail.
        // Se no creo account nuovo

    if (isset($_POST['username']) && isset($_POST['password']) && ISSET($_POST['nickname'])) {
        $result = pg_query($dbconn, $sql_check_user);
        while($row = pg_fetch_row($result)) {
            $success_user = true;
        }

        $result = pg_query($dbconn, $sql_check_nick);
        while($row = pg_fetch_row($result)) {
            $success_nick = true;
        }
        if($success_user == false && $success_nick == false) {
            $result = pg_query($dbconn, $sql_insert);
            $error = "Account created!";
            header('Location: index.php');
        } else if($success_user == true) {
            $error = "Already existing account associated to this email!";
        } else if($success_nick == true){
            $error = "Nickname is not aviable!";
        }
        pg_free_result($result);

        pg_close($dbconn);
    }

?>

<html>
    <head>
        <title>DoungeonAsDB : Official</title>
        <?php include ('lib/header.php'); ?>
    </head>
    <body>
        <div class="background-wrap">
            <video id="bgvideo" preload="auto" autoplay="true" loop="loop" muted="muted" poster="">
                <source src="video.mov" type="video/mp4">
            </video>
        </div>
        <div class="content">
            <div id="log">
                <form method="post" action="register.php">
                    <br><br>
                    <label for="username">Email</label><br>
                    <input class="inputborder" type="text" name="username" id="username" placeholder="Enter Email" required>
                    <br><br>
                    <label for="nickname">Nickname</label><br>
                    <input class="inputborder" type="text" name="nickname" id="nickname" placeholder="Enter NickName" required>
                    <br><br>
                    <label for="password">Password</label><br>
                    <input class="inputborder" type="password" name="password" id="password" placeholder="Enter Password" required>
                    <br>
                    <button type="submit">Register</button>
                    <br><br>
                    <?php
                    echo "<p style='color:white;'>".$error."</p>";
                    ?>
                    <div class ="register">
                        <span class="psw">Already have a DoungeonASDB account? <a href="index.php"> Log In Now. </a></span>
                    </div>
                </form>
            </div>
        </div>
    </body>
</html>