getMessage();
$schedule = [];
$days = ['Monday','Tuesday','Wednesday','Thursday','Friday','Saturday','Sunday'];
foreach ($days as $day) { $schedule[$day] = []; }
goto render_page;
}
// Days list
$days = ['Monday','Tuesday','Wednesday','Thursday','Friday','Saturday','Sunday'];
$schedule = [];
// Fetch schedule
foreach ($days as $day) {
$stmt = $conn->prepare("SELECT time, program_name FROM tv_schedule WHERE day = :day ORDER BY time ASC");
$stmt->execute([':day' => $day]);
$schedule[$day] = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
// ✅ Now Showing
date_default_timezone_set("Asia/Colombo");
$currentDay = date('l');
$currentTime = date('H:i:s');
$now_stmt = $conn->prepare("
SELECT * FROM tv_schedule
WHERE day = :day
AND time <= :time
ORDER BY time DESC
LIMIT 1
");
$now_stmt->execute([':day'=>$currentDay, ':time'=>$currentTime]);
$now_program = $now_stmt->fetch(PDO::FETCH_ASSOC);
render_page:
?>
TV Schedule | Swarnawahini