type.php

<?php
// Database connection settings
$servername = "";
$username = "";
$password = "";
$dbname = ""; //Your Dbname

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$audience_type = isset($_GET['audience_type']) ? $_GET['audience_type'] : '';
$offset = isset($_GET['offset']) ? intval($_GET['offset']) : 0;
$limit = 18; // Number of podcasts per batch

// Prepared statement to fetch distinct apple_ids with limit and offset
$sql = "SELECT DISTINCT apple_id FROM your_table WHERE (audience_type = ?) LIMIT ? OFFSET ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("sii", $audience_type, $limit, $offset);
$stmt->execute();
$result = $stmt->get_result();

$apple_ids = [];
while ($row = $result->fetch_assoc()) {
    $apple_ids[] = $row['apple_id'];
}

// Function to fetch podcast data from iTunes API
function fetchPodcastData($apple_id) {
    $itunes_url = "https://itunes.apple.com/lookup?id=" . $apple_id . "&entity=podcast";
    $json_data = file_get_contents($itunes_url);
    return json_decode($json_data, true);
}

$podcasts = [];
foreach ($apple_ids as $apple_id) {
    $podcast_data = fetchPodcastData($apple_id);
    if (isset($podcast_data['results']) && count($podcast_data['results']) > 0) {
        $podcasts[] = $podcast_data['results'][0];
    }
}

// Get total number of distinct apple_ids for this audience type
$count_sql = "SELECT COUNT(DISTINCT apple_id) as total FROM your_table WHERE (audience_type = ?)";
$count_stmt = $conn->prepare($count_sql);
$count_stmt->bind_param("s", $audience_type);
$count_stmt->execute();
$count_result = $count_stmt->get_result();
$total_count = 0;
if ($count_result->num_rows > 0) {
    $row = $count_result->fetch_assoc();
    $total_count = intval($row['total']);
}

// Return podcasts and total count as JSON
echo json_encode([
    'podcasts' => $podcasts,
    'total' => $total_count
]);

$conn->close();
?>