30) {
$foreN_err = 'Please enter a valid name.';
}
if (empty($surN) || strlen($surN) > 30) {
$surN_err = 'Please enter a valid name.';
}
//Thanks to https://www.w3schools.com/php/php_form_url_email.asp
if (empty($email) || strlen($email) > 50 || !filter_var($email, FILTER_VALIDATE_EMAIL)) {
$email_err = 'Please enter a valid email.';
}
if (empty($phoneN) || strlen($phoneN) > 11) {
$phoneN_err = 'Please enter a valid phone number';
}
if (empty($DOB)) {
$DOB_err = 'please enter a date of birth';
} else {
$arrayOfOfBirth = explode('-', $DOB);
$age = date('Y') - $arrayOfOfBirth[0];
if (date('m') < $arrayOfOfBirth[1]) {
$age = $age - 1;
}
if ($age < 16) {
$DOB_err = 'This employee is too young to work.';
} else if ($age > 80) {
$DOB_err = 'This employee is too old to work.';
}
}
if (empty($houseN) || strlen($houseN) > 5) {
$houseN_err = 'please enter a valid house number.';
}
if (empty($street) || strlen($street) > 50) {
$street_err = 'Please enter a valid street name.';
}
if (empty($city) || strlen($city) > 50) {
$city_err = 'please enter a valid city.';
}
if (empty($postC) || strlen($postC) > 8) {
$postC_err = 'please enter a valid postcode.';
}
if (empty($staffID_err) && empty($foreN_err) &&
empty($email_err) && empty($phoneN_err) && empty($DOB_err) && empty($houseN_err) &&
empty($street_err) && empty($surN_err) && empty($city_err) && empty($postC_err)) {
$sql = "INSERT INTO staff (Staff_ID, Forename, Surname, Email_Address, Phone_Number, DateOFBirth, House_Number, Street_Name, City, PostCode) VALUES (?,?,?,?,?,?,?,?,?,?)";
if ($stmt = mysqli_prepare($link, $sql)) {
mysqli_stmt_bind_param($stmt, "ssssssssss", $staffID, $foreN, $surN, $email, $phoneN, $par_DOB, $houseN, $street, $city, $postC);
$time = strtotime($DOB);
$nwFormat = date('Y-m-d', $time);
$par_DOB = $nwFormat;
if (mysqli_stmt_execute($stmt)) {
// Redirect to login page
header("location: ../Staff");
} else {
echo "Something went wrong. Please try again later.";
}
} else {
echo "Something went wrong. Please try again later.";
}
}
}
?>
Dashboard
function GenerateUsername(){
var lastName = $("#surN").val();
if(lastName=="" || lastName.length < 3){
alert("You must enter the last name for this feature, or have a last name that is at least 3 characters long.");
exit;
}
var staffStart = lastName[0]+lastName[1]+lastName[2];
var staffStart =staffStart.toUpperCase();
var datenw = "" +' . date("ym") . '
var staffFull = staffStart+datenw+getRandom(9)+getRandom(9)+getRandom(9);
document.getElementById("StaffID").value = staffFull;
}
//generates random number
function getRandom(num){
var ranNum = Math.floor(Math.random()*num);
return ranNum;
}
'
?>