submit.php

<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);

require_once "db-inc.php";

if ($_SERVER['REQUEST_METHOD'] === 'POST') {

    if (isset($_POST['form_type']) && $_POST['form_type'] === 'employee') {

        $employeeNumber = intval($_POST['employeeNumber']);
        $firstName = mysqli_real_escape_string($conn, $_POST['firstName']);
        $lastName = mysqli_real_escape_string($conn, $_POST['lastName']);
        $email = mysqli_real_escape_string($conn, $_POST['email']);
        $departmentCode = mysqli_real_escape_string($conn, $_POST['departmentCode']);
        $jobTitle = mysqli_real_escape_string($conn, $_POST['jobTitle']);
        $salary = intval($_POST['salary']);

        $sql = "INSERT INTO employees (employeeNumber, firstName, lastName, email, departmentCode, jobTitle, salary)
                VALUES ($employeeNumber, '$firstName', '$lastName', '$email', '$departmentCode', '$jobTitle', $salary)";

        if (mysqli_query($conn, $sql)) {
            header("Location: index.php?success=employee");
            exit;
        } else {
            echo "Error inserting employee: " . mysqli_error($conn);
        }

    } elseif (isset($_POST['form_type']) && $_POST['form_type'] === 'interview') {

        $departmentCode = mysqli_real_escape_string($conn, $_POST['departmentCode']);
        $role = mysqli_real_escape_string($conn, $_POST['role']);
        $status = mysqli_real_escape_string($conn, $_POST['status']);

        $sql = "INSERT INTO interviews (departmentCode, role, status)
                VALUES ('$departmentCode', '$role', '$status')";

        if (mysqli_query($conn, $sql)) {
            header("Location: index.php?success=interview");
            exit;
        } else {
            echo "Error inserting interview: " . mysqli_error($conn);
        }
    }
}

mysqli_close($conn);
?>