<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "personal";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

//Назначение переменных и получение данных из формы

    $shift = $_POST['shift'];
    $fullname = $_POST['fullname'];
    $position = $_POST['position'];
    $age = $_POST['age'];
    $school = $_POST['school'];
    $w_age = $_POST['w_age'];
    $p_age = $_POST['p_age'];
    $class = $_POST['class'];
    $level = $_POST['level'];
    $access = implode(", ", $_POST['access']); //Перевод значений массива в переменные
    $prolong = $_POST['prolong'];
    $course = $_POST['course'];
    $loc_course = $_POST['loc_course'];
    $courseen = $_POST['courseen'];
    $loc_courseen = $_POST['loc_courseen'];
    $english = $_POST['english'];
    $check_prakt = $_POST['check_prakt'];
    $check_theory = $_POST['check_theory'];
    $ozpvlp = $_POST['ozpvlp'];


//Создание ассоциированного массива для передачи данных из переменных выше

 $data = array(
        'fullname' => "$fullname",
        'position' => "$position",
        'age' => "$age",
        'school' => "$school",
        'w_age' => "$w_age",
        'p_age' => "$p_age",
        'class' => "$class",
        'level' => "$level",
        'prolong' => "$prolong",
        'course' => "$course",
        'loc_course' => "$loc_course",
        'courseen' => "$courseen",
        'loc_courseen' => "$loc_courseen",
        'english' => "$english",
        'check_prakt' => "$check_prakt",
        'check_theory' => "$check_theory",
        'ozpvlp' => "$ozpvlp",
        'access' => "$access",
    );

$sql = "INSERT INTO $shift (fullname, position, age, school, w_age, p_age, class, level, access, prolong, course, loc_course, courseen, loc_courseen, english, check_prakt, check_theory, ozpvlp)
VALUES ('$fullname', '$position', '$age', '$school', '$w_age', '$p_age', '$class', '$level', '$access', '$prolong', '$course', '$loc_course', '$courseen', '$loc_courseen', '$english', '$check_prakt', '$check_theory', '$ozpvlp')
ON DUPLICATE KEY UPDATE fullname = VALUES (fullname),
position = VALUES (position),
age = VALUES (age),
school = VALUES (school),
w_age = VALUES (w_age),
p_age = VALUES (p_age),
class = VALUES (class),
level = VALUES (level),
access = VALUES (access),
prolong = VALUES (prolong),
course = VALUES (course),
loc_course = VALUES (loc_course),
courseen = VALUES (courseen),
loc_courseen = VALUES (loc_courseen),
english = VALUES (english),
check_prakt = VALUES (check_prakt),
check_theory = VALUES (check_theory),
ozpvlp = VALUES (ozpvlp)";

if ($conn->query($sql) === TRUE) {
    echo "Запись создана успешно";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();
?>