@Barand, I can get a fetal error when I using above code.
This is my updated code:
if (isset($_POST['next-step'])) {
$restaurantId = 2;
$def_times = array('06:30:00', '10:30:00'); // default
$sql = "INSERT INTO business_hours ( restaurant_id
, day
, open_time
, close_time
)
VALUES (?,?,?,?)";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('iiss', $restaurantId, $dayNo, $openTime, $closeTime);
foreach ($_POST['openclose'] as $dayNo => $times) {
$dayNo = (int)$dayNo;
if ($times[1]==-1) { // closed
$times[1] = $times[2] = '00:00:00';
}
elseif (empty(array_filter($times))) {
$times = $def_times; // set the times to the stored defaults
}
else {
$def_times = $times; // save the times as the default times
}
$openTime = $times[1];
$closeTime = $times[2];
$stmt->execute();
if ($times[3]!='') {
$openTime = $times[3];
$closeTime = $times[4];
$stmt->execute();
}
}
}
This is the error message:
line 24 is
$times = $def_times; // set the times to the stored defaults