<?php
session_start();
if (!isset($_SESSION['loggedin'])) {
    exit("unauthorized");
}

include "../database.php";

$start_date = $_POST["start_date"];
$end_date = $_POST["end_date"];

$year = date("Y", strtotime($start_date));
$month = date("m", strtotime($end_date));

$sql = "INSERT INTO attendance VALUES(NULL, $year, $month, 'Pronto', '" . date("Y-m-d H:i:s") . "',0,'',0)";
if ($con->query($sql) === true) {
    $id = mysqli_insert_id($con);
    echo $id;
} else {
    echo "error";
}

$con->close();