<?php

//defined
$servername = "localhost";
$username = "root";
$password = "epicpassword";
$database = "users"
$idgen = bin2hex(mcrypt_create_iv(22, MCRYPT_DEV_URANDOM));

//sumbit data from form

$_POST["firstname"];
$_POST["lastname"];
$_POST["email"];
$_POST["username"];
$_POST["password"];
$_POST["ID"]

//creating the connection
    $conn = mysqli_connect("$servername","$usename","$password","$users");


//checking connection
    if (!$conn){
        die("connection failed" . mysqli_connect_error());
}
        echo "Connected to Database!";

//dump action
    $sql = "INSERT INTO users (firstname, lastname, email, username, password, id)
VALUES ('firstname', 'lastname', 'email', 'username', 'password', '$id',)";


//creating the connection
    $conn = mysqli_connect("$servername","$usename","$password","$users");

//checking for connection then dump.
if (mysqli_query($conn, $sql)){
    echo "Please login - redirecting";
        header(Refresh:2 url="login.html");
} else {
    echo "Error creating record";
}


//Close Connection
mysqli_close($conn);

?>