<?php session_start();
require_once("nocache.php");
$usernamemsg = "";
$username = "";
$password = "";
$retypepassword = "";
$gname = "";
$sname = "";
$address = "";
$state = "";
$postcode = "";
$moblie = "";
$email = "";

$usernameerror = "";
$passworderror = "";
$retypepassworderror = "";
$gnameerror = "";
$snameerror = "";
$addresserror = "";
$stateerror = "";
$postcodeerror = "";
$moblieerror = "";
$emailerror = "";

if (isset($_POST["submit"])) {
  $conn = mysqli_connect("localhost", "twa132", "twa1321u", "westernhotel132");
  if ( !$conn ) {
    die("Connection failed: " . mysqli_connect_error());
  }
  //get all data into a variable
  if(isset($_POST["username"]))
    $username = $_POST["username"];

  if(isset($_POST["password"]))
    $password = $_POST["password"];

  if(isset($_POST["retypepassword"]))
    $retypepassword = $_POST["retypepassword"];

  if(isset($_POST["givenname"]))
    $gname = $_POST["givenname"];

  if(isset($_POST["familyname"]))
    $sname = $_POST["familyname"];

  if(isset($_POST["address"]))
    $address = $_POST["address"];

  if(isset($_POST["state"]))
    $state = $_POST["state"];

  if(isset($_POST["postcode"]))
    $postcode = $_POST["postcode"];

  if(isset($_POST["moblie"]))
    $moblie = $_POST["moblie"];

  if(isset($_POST["email"]))
    $email = $_POST["email"];

    if(!empty($username)) {
      if(strlen($username) < 20) {// check if username is less than 20
          $usernameerror = "";
          $sql = "SELECT username
                  FROM customers
                  WHERE customers.username = '$username'";
          $results = mysqli_query($conn, $sql)
          or die ('Problem with query' . mysqli_error($conn));

          if (mysqli_num_rows($results) != 0) //checks if username is unique
          {
            $usernamemsg = "Username is already taken. Please try again";
          }
          else {
            $usernamemsg = "";
          }

        } else {
          $usernameerror = "Maximum characters for Username is 20";
        }
    } else {
      $usernamemsg = "Please input username";
    }


    $regexpassword = "/^[\d\w]{6,20}$/";
    if(preg_match($regexpassword, $password) != 1) { //check password
      $passworderror = "Password characters should be between 6-20";
    } else {
      $passworderror = "";
    }

    if($password != $retypepassword) { //check password match with retypepassword
      $retypepassworderror = "Password does not match with previous password";
    } else {
      $retypepassworderror = "";
    }

    $regexName = "/^[a-zA-Z\-'\s]+$/";
    if(preg_match($regexName, $gname) != 1 || strlen($gname) > 20) { //check given name
      $gnameerror = "Can only contain either alphabetical letters, hyphen, apostrophe, spaces and be less than 20 characters";
    } else {
      $gnameerror = "";
    }
    if(preg_match($regexName, $sname) != 1 || strlen($sname) > 20) { //check surname
      $snameerror = "Can only contain either alphabetical letters, hyphen, apostrophe, spaces and be less than 20 characters";
    } else {
      $snameerror = "";
    }

    if(strlen($address) > 40) { //check address
      $addresserror = "Maximum characters for Address is 40";
    } else {
      $addresserror = "";
    }

    if($state == "0") { //check state
      $stateerror = "Please select a state";
    } else {
      $stateerror = "";
    }

    $regexpostcode = "/\d{4}/";
    if(preg_match($regexpostcode, $postcode) != 1) { //check postcode
      $postcodeerror = "Must be 4 digits";
    } else {
      $postcodeerror = "";
    }

    $regexmoblie = "/04[0-9]{8}/";
    if(preg_match($regexmoblie, $moblie) != 1) {//check moblie
      $moblieerror = "Must have 10 digits like (04)XXXX XXXX";
    } else {
      $moblieerror = "";
    }

    $regexemail = "/^[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,}$/i";
    if(!filter_var($email, FILTER_VALIDATE_EMAIL)) {//check email
      $emailerror = "Wrong format for email";
    } else {
      $emailerror = "";
    }

    if($usernamemsg == "" && $usernameerror == "" && $passworderror == "" &&
       $gnameerror == "" && $snameerror == "" && $addresserror == "" &&
       $stateerror == "" && $postcodeerror == "" && $moblieerror == "" &&
       $emailerror == "") { //checks all to input into server
      $sql = "INSERT INTO customers (username, password, gname, sname,
                          address, state, postcode, mobile, email)
              VALUES ('$username', '$password', '$gname', '$sname', '$address',
                      '$state', '$postcode', '$moblie', '$email')";


    if ($conn->query($sql) === TRUE) {
                echo "New record created successfully";
            } else {
                echo "Error: " . $sql . "<br>" . $conn->error;
            }
    mysqli_close($conn);
    header("location: customerlogin.php");
    }

}
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Registration Form</title>
    <link rel="stylesheet" type="text/css" href="general.css"/>
    <script src="registerscript.js" type="text/javascript"></script>
</head>
<body>
    <?php include 'generate-nav.php' ?>
    <form action="<?php echo $_SERVER["PHP_SELF"] ?>" method="post">
        <h2>Register</h2>
                Username:
                <input class="textbox" type="text" id="username" name="username" onblur="Usernamecheck(this)" placeholder="Username" value="<?php $username ?>">
        <span class="error" id="usernamemsg"></span><?php echo $usernameerror, $usernamemsg?><br/><br/>
                Password:
                <input class="textbox" type="password" id="password" name="password" onblur="Passwordcheck(this)" placeholder="Password" value="<?php $password ?>">
        <span class="error" id="passwordmsg"></span><?php echo $passworderror?><br/><br/>
                Retype Password:
                <input class="textbox" type="password" id="retypepassword" name="retypepassword" onblur="Retypepasswordcheck(this)" placeholder="Retype Password" value="<?php $retypepassword ?>">
        <span class="error" id="retypepasswordmsg"></span><?php echo $retypepassworderror?><br/><br/>
                Given Name:
                <input class="textbox" type="text" id="givenname" name="givenname" onblur="Givennamecheck(this)" placeholder="Given Name" value="<?php $givenname ?>">
        <span class="error" id="givennamemsg"></span><?php echo $gnameerror?><br/><br/>
                Family Name:
                <input class="textbox" type="text" id="familyname" name="familyname" onblur="Familynamecheck(this)" placeholder="Family Name" value="<?php $familyname ?>">
        <span class="error" id="familynamemsg"></span><?php echo $snameerror?><br/><br/>
                Street Address:
                <input class="textbox" type="text" id="address" name="address" onblur="Addresscheck(this)" placeholder="Street Address" value="<?php $address ?>">
        <span class="error" id="streetmsg"></span><?php echo $addresserror?><br/><br/>

                <label for="state">State:</label>
                <select name="state" id="state" name="state" onblur="Statecheck(this)" value="<?php $state ?>">
          <option value="0">Select your state</option>
                    <option value="NSW">NSW</option>
                    <option value="NT">NT</option>
                    <option value="QLD">QLD</option>
                    <option value="SA">SA</option>
                    <option value="TAS">TAS</option>
                    <option value="VIC">VIC</option>
                    <option value="WA">WA</option>
        </select><span class="error" id="statemsg"></span><?php echo $stateerror?><br><br/>

                Postcode:
                <input class="textbox" type="text" id="postcode" name="postcode" onblur="Postcodecheck(this)" placeholder="Postcode" value="<?php $postcode ?>">
        <span class="error" id="postcodemsg"></span><?php echo $postcodeerror?><br/><br/>
                Mobile:
                <input class="textbox" type="text" id="moblie" name="moblie" onblur="Mobliecheck(this)" placeholder="Mobile" value="<?php $moblie ?>">
        <span class="error" id="mobliemsg"></span><?php echo $moblieerror?><br/><br/>
                E-mail:
                <input class="textbox" type="email" id="email" name="email" onblur="Emailcheck(this)" placeholder="E-mail" value="<?php $email ?>">
        <span class="error" id="emailmsg"></span><?php echo $emailerror?><br/><br/>
                Submit Here:
                <input class="submitbutton" type="submit" name="submit" id="submit" value="Submit">
    </form>
</body>
</html>