<?php
session_start();
include 'connect.php';
include("header.php");
include("footer.php");
include("nav.php");




  if (isset($_POST['submit'])) {
    // Check if the connection was successful
    if (!$conn) {
      die("Connection failed: " . mysqli_connect_error());
    }

    // Get the user input
    $f_name = mysqli_real_escape_string($conn, $_POST['f_name']);
    $l_name = mysqli_real_escape_string($conn, $_POST['l_name']);
    $nokp = mysqli_real_escape_string($conn, $_POST['nokp']);
    $emailadd = mysqli_real_escape_string($conn, $_POST['emailadd']);
    $pass = mysqli_real_escape_string($conn, $_POST['pass']);

    // Hash the password using BCrypt
    $options = [
      'cost' => 12
    ];
    $hashed_pass = password_hash($pass, PASSWORD_BCRYPT, $options);

    // Insert the user data into the tbl_user table
    $sql = "INSERT INTO tbl_user (f_name, l_name, nokp, emailadd, pass)
            VALUES ('$f_name', '$l_name', '$nokp', '$emailadd', '$hashed_pass')";

    if (mysqli_query($conn, $sql)) {
      echo "New record created successfully";
    } else {
      echo "Error: " . $sql . "<br>" . mysqli_error($conn);
    }

    // Close the database connection
    mysqli_close($conn);
  }
?>

<main>
  <head>
    <title>GVR Book Keeping Solutions - Register</title>
  </head>
  <body>
    <h1>GVR Book Keeping Solutions - Register</h1>
    <form action="register.php" method="post">
      Full Name: <input type="text" name="f_name" required><br><br>
      Last Name: <input type="text" name="l_name" required><br><br>
      Identification No: <input type="text" name="nokp" required><br><br>
      Email Address: <input type="email" name="emailadd" required><br><br>
      Password: <input type="password" name="pass" required><br><br>
      <input type="submit" name="submit" value="Submit">
    </form>
  </body>
</main>
