<?php
require_once "connection.php";
//print_r($_POST);
//exit();
if (isset($_POST['firstname']) && isset($_POST['lastname']) && isset($_POST['email']) && isset($_POST['username']) && isset($_POST['password']) && isset($_POST['confirmpassword'])) {
    $firstname = $_POST['firstname'];
    $lastname = $_POST['lastname'];
    $email = $_POST['email'];
    $username = $_POST['username'];
    $password = $_POST['password'];
    $confirmpassword = $_POST['confirmpassword'];

    $sql = "SELECT email FROM users WHERE email='$email'";
    $resultset = mysqli_query($conn, $sql) or die("database error:" . mysqli_error($conn));
    $row = mysqli_fetch_assoc($resultset);
    if (!$row['email']) {
        $sql = "INSERT INTO users(`firstname`, `lastname`, `email`,`username`,`password`,`confirmpassword`) VALUES ('$firstname', '$lastname', '$email','$username','$password','$confirmpassword')";
        mysqli_query($conn, $sql) or die("database error:" . mysqli_error($conn) . "qqq" . $sql);
        echo "registered";
    } else {
        echo "1";
    }
} else {
    echo 'Invalid Request';
}