Playlist

} $wpdb->query('DELETE FROM playlist WHERE onair_time < NOW() - INTERVAL 7 DAY'); $playlist = $wpdb->get_results('SELECT * FROM playlist WHERE onair_time > NOW() - INTERVAL 24 HOUR ORDER BY onair_time DESC'); $days = ['Pondělí', 'Úterý', 'Středa', 'Čtvrtek', 'Pátek', 'Sobota', 'Neděle']; echo ''; foreach ($playlist as $record) { $day_name = $days[date('N', strtotime($record->onair_time))-1]; if (strlen($record->cover)<10) $record->cover='/wp-content/uploads/2021/03/rn_logo_200.png'; if ($record->year == 0) $record->year = ''; echo ''; } echo '

ČAS	OBAL	INTERPRET	SKLADBA	ROK
den - '.$day_name.' datum - '.date('j.n. Y', strtotime($record->onair_time)).' čas - '.date('G:i', strtotime($record->onair_time)).'		'.$record->artist.'	'.$record->title.'	'.$record->year.'

';