function get_cached_sheetdb_prayer_data() {
// Check if cached data exists
$cached_data = get_transient(‘sheetdb_prayer_data’);

if ($cached_data === false) {
// Make a GET request to SheetDB.io
$response = wp_remote_get(‘https://sheetdb.io/api/v1/kxidj5fn7ffzq’);

if (is_wp_error($response)) {
return ‘<p style=”color:red;”>Error fetching prayer times.</p>’;
}

$body = wp_remote_retrieve_body($response);
$data = json_decode($body, true);

// Store data in transient for 90 minutes (5400 seconds)
set_transient(‘sheetdb_prayer_data’, $data, 5400);
} else {
$data = $cached_data;
}

return $data;
}

function display_prayer_times() {
$prayer_data = get_cached_sheetdb_prayer_data();

if (!$prayer_data) {
return ‘<p style=”color:red;”>No prayer data available.</p>’;
}

$output = ‘<div class=”prayer-table”>’;
foreach ($prayer_data as $prayer) {
$output .= ‘<div class=”prayer-row”><span>’ . esc_html($prayer[‘SALAH’]) . ‘</span> <span>’ . esc_html($prayer[‘Time’]) . ‘</span></div>’;
}
$output .= ‘</div>’;

return $output;
}

// Register the shortcode
add_shortcode(‘prayer_times’, ‘display_prayer_times’);