<?php
include "WebBuilder/main.class.php";
$db = new DBMain();

$file = fopen('Employee.csv', 'r');
while (($row = fgetcsv($file)) !== false) {

    $teba_number = $row[0];
    $badge_numebr = $row[1];
    $full_name = explode(' ',$row[2]);
    $name = $full_name[0];
    $surname = $full_name[1];
    $team_number = $row[3];
    $occupation = $row[4];


    $db->insert("INSERT INTO `client_employees`( `client_employees_name`, `surname`, `clients_id`, `i_doc_passport`, `cell`, `company_number`, `occupation`, `teba_number`, `badge_number`, `team_number`) VALUES ('$name', '$surname', 5, 0, 0 , '$teba_number', '$occupation', '$teba_number', '$badge_numebr', '$team_number')");

    echo "Name: " . $row[0] . " " . $row[1] . " " . $row[2] . "<br>";
    echo "Employe ID: " . $row[3] . "<br>";
    echo "Position: " . $row[4] . "<br>";
    echo "Department: " . $row[5] . "<br>";
    echo "Phone Number: " . $row[6] . "<br>";
    echo "<br>";
}
fclose($file);
