signin.fn.php

<?php
function signin($username, $password, $email, $db){

        $username = htmlspecialchars($username);
        $password = htmlspecialchars($password);
        $email = htmlspecialchars($email);

        $request = $db->prepare("SELECT * FROM users WHERE username = :username AND email = :email");

        $request->execute(
            array(
                "username" => $username,
                "email" => $email
            )
        );


        $result = $request->fetch(PDO::FETCH_ASSOC);

        if ($result == true) {

            return false;

        } else {

            $request = $db->prepare("INSERT INTO users SET username = :username, password = :password, email = :email");

            $request->execute(
                array(
                    "username" => $username,
                    "password" => $password,
                    "email" => $email
                )
            );
            return true;
        }


}


?>