<?php
$timeSheet = array(
'10/20/2023 20:43',
'10/21/2023 5:53',
'10/23/2023 20:42',
'10/24/2023 6:08',
'10/24/2023 20:47',
'10/25/2023 5:57',
'10/25/2023 20:45',
'10/26/2023 6:03',
'10/26/2023 20:42',
'10/27/2023 5:59',
'10/27/2023 20:45',
'10/28/2023 5:55',
'10/30/2023 20:44',
'10/31/2023 5:55',
'10/31/2023 20:46',
'11/1/2023 5:55',
'11/1/2023 20:43',
'11/2/2023 5:59',
'11/2/2023 20:47',
'11/3/2023 5:57',
'11/3/2023 20:49',
'11/4/2023 5:57',
'11/6/2023 20:45',
'11/7/2023 5:55',
'11/7/2023 20:41',
'11/8/2023 5:55',
'11/8/2023 20:42',
'11/9/2023 5:55',
'11/9/2023 20:42',
'11/10/2023 5:55',
'11/10/2023 20:46',
'11/11/2023 5:53'
);
$query = "INSERT INTO timesheet (time_in, time_out) VALUES ";
foreach (array_chunk($timeSheet, 2) as $chunk) {
$timeIn = date('Y-m-d H:i:s', strtotime($chunk[0]));
$timeOut = date('Y-m-d H:i:s', strtotime($chunk[1]));
$query .= "('$timeIn', '$timeOut'),";
}
$query = rtrim($query, ",");
if ($mysqli->query($query) == TRUE) {
echo "Records inserted successfully";
} else {
echo "Error: " . $query . "<br>" . $mysqli->error;
}