OmarElGabry / miniPHP

      * @return integer number of comments

      *

      */

    public static function countComments($postId){

        $database = Database::openConnection();

        $database->prepare("SELECT COUNT(*) AS count FROM comments WHERE post_id = :post_id");

        $database->bindValue(":post_id", $postId);

        $database->execute();

        return (int)$database->fetchAssociative()["count"];

    }

}

     * @param  string   $userIp

     * @return bool

     */

    private function isIpBlocked($userIp){

        $database = Database::openConnection();

        $database->prepare("SELECT ip FROM blocked_ips WHERE ip = :ip LIMIT 1");

        $database->bindValue(":ip", $userIp);

        $database->execute();

        return $database->countRows() >= 1;

    }

    /**

     * Adds a new record(if not exists) to ip_failed_logins table,

     * @return boolean

     *

     */

    private function isEmailExists($email){

        // email is already unique in the database,

        // So, we can't have more than 2 users with the same emails

        $database = Database::openConnection();

        $database->prepare("SELECT * FROM users WHERE email = :email AND is_email_activated = 1 LIMIT 1");

        $database->bindValue(':email', $email);

        $database->execute();

        return $database->countRows() === 1;

    }

    /**

     * Insert or Update(if already exists)

     * @return string

     *

     */

    private static function updateSessionId($userId, $sessionId = null){

        $database = Database::openConnection();

        $database->prepare("UPDATE users SET session_id = :session_id WHERE id = :id");

        $database->bindValue(":session_id", $sessionId);

        $database->bindValue(":id", $userId);

        $database->execute();

    }

    /**

     * Remove the session