Dashboard

" . $row[0] . ""; } } if ($_SERVER["REQUEST_METHOD"] == "POST") { if (empty(($_POST["username"]))) { $username_err = "Select a Username for the account."; } else { $username = trim($_POST['username']); } if (empty(($_POST["JobRole"]))) { $jobRole_err = "Select a Job role for the account."; } else { $jobRole = trim($_POST["JobRole"]); } if (empty($_POST["terminate"])) { $terminateD_err = "Select a Termination date for the account."; } else { $terminateD = trim($_POST["terminate"]); } if (empty(trim($_POST["pwd"]))) { $password_err = "Enter a password."; } else { $password_test = trim($_POST["pwd"]); if (strlen($_POST["pwd"]) < 9) { $password_err = "Password must contain at least 9 characters."; } elseif (!preg_match("#[0-9]+#", $password_test)) { $password_err = "Password must contain at least 1 number."; } elseif (!preg_match("#[a-z]+#", $password_test)) { $password_err = "Password must contain at least 1 lowercase letter."; } elseif (!preg_match("#[A-Z]+#", $password_test)) { $password_err = "Password must contain at least 1 uppercase letter."; } else { $password = trim($_POST["pwd"]); } } if (trim($_POST["pwd"]) != trim($_POST["pwdr"])) { $password_err2 = "passwords must match."; } if (empty($username_err) && empty($password_err) && empty($password_err2)) { if (empty($jobRole_err) && empty($terminateD_err)) { $sql = "INSERT INTO users (Staff_ID,PASSWORD,Terminate_On,Job_Role,Security_Level,Locked)VALUES (?,?,?,?,?,?)"; if ($stmt = mysqli_prepare($link, $sql)) { // Bind variables to the prepared statement as parameters mysqli_stmt_bind_param($stmt, "ssssii", $param_username, $param_password, $param_terminateD, $param_jobRole, $param_Security_Level, $status); $status = 0; $param_username = $username; $param_password = password_hash($password, PASSWORD_DEFAULT); $time = strtotime($terminateD); $newformat = date('Y-m-d', $time); $param_terminateD = $newformat; $param_jobRole = $jobRole; $nwarray = array('Administrator', 'Manager', 'Supervisor', 'Team Member'); $param_Security_Level = ""; for ($i = 0; $i < 4; $i++) { if ($jobRole == $nwarray[$i]) { $param_Security_Level = $i; } } if ($param_Security_Level != "") { if (mysqli_stmt_execute($stmt)) { // Redirect to login page header("location: ../"); } else { echo "Unable to execute statement"; } } else { echo "Something went wrong. Please try again later."; } } } } } ?> Dashboard

Creating account

Enter Details:

" method="post">

Username " . $username_err . "

"; ?>

Job Role " . $jobRole_err . "

"; ?>

Terminate Account Date " . $terminateD_err . "

"; ?>

Password:

X Longer than 9 characters

X contains 1 number

X contains 1 uppercase letter

X contains 1 lowercase letter

" . $password_err . "

"; ?>

Re-enter Password: " . $password_err2 . "

"; ?>