= 1){
while($row = mysqli_fetch_assoc($result)){
// checking to see if entered ID number exist in the database
if($row['txtIDNumber'] == $id){
echo "";
$checkIdExist++; break;
}
}
// If there is no ID match the following condition will be executed
if($checkIdExist == 0){
// prepared insert sql statement to insert all the data read from the form
// 20190619 - Fixed the sql statement as it was not working because I was using the backticks signs instead of single quotes in the column names. - Banele
$insertUserStmt = "INSERT INTO `user` (`txtFirstname`, `txtLastname`, `txtIDNumber`, `txtDOB`, `txtGender`, `txtUserType`, `txtEmail`, `txtPassword`, `txtUserDateCreated`, `txtStatus`, `txtUserNote`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
$stmt = mysqli_stmt_init($conn);
if(mysqli_stmt_prepare($stmt, $insertUserStmt)){
mysqli_stmt_bind_param($stmt, "sssssssssss", $fname, $lname, $id, $dob, $gndr, $usrType, $usrEmail, $usrPassword, $dateCreated, $usrStatus, $usrNote);
mysqli_stmt_execute($stmt);
echo "";
}else{
echo "";
}
}
}else{
// prepared insert sql statement to insert all the data read from the form
// 20190619 - Fixed the sql statement as it was not working because I was using the backticks signs instead of single quotes in the column names. - Banele
$insertUserStmt = "INSERT INTO `user` (`txtFirstname`, `txtLastname`, `txtIDNumber`, `txtDOB`, `txtGender`, `txtUserType`, `txtEmail`, `txtPassword`, `txtUserDateCreated`, `txtStatus`, `txtUserNote`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
$stmt = mysqli_stmt_init($conn);
if(mysqli_stmt_prepare($stmt, $insertUserStmt)){
mysqli_stmt_bind_param($stmt, "sssssssssss", $fname, $lname, $id, $dob, $gndr, $usrType, $usrEmail, $usrPassword, $dateCreated, $usrStatus, $usrNote);
mysqli_stmt_execute($stmt);
echo "";
}else{
echo "";
}
}
}
?>
Registration form