<?php
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

try {
    $mysqli = new mysqli("localhost", "heemskerk_it", "35LTeG5zrP3NaHh2dgMA", "heemskerk_it");
    $mysqli->set_charset("utf8mb4");

    // Vandaag in dd-mm formaat (zoals Joomla doet)
    $vandaag = date("d-m");

    $sql = "
        SELECT c.title, c.introtext
        FROM JHPlak_content AS c
        JOIN JHPlak_fields_values AS fv 
            ON fv.item_id = c.id
        JOIN JHPlak_fields AS f 
            ON f.id = fv.field_id
        WHERE f.name = 'datum-dag-maand'
        AND fv.value = ?
        AND fv.context = 'com_content.article'
        AND c.state = 1
        ORDER BY c.created DESC
        LIMIT 10
    ";

    $stmt = $mysqli->prepare($sql);
    $stmt->bind_param("s", $vandaag);
    $stmt->execute();
    $result = $stmt->get_result();

    $data = [];
    while($row = $result->fetch_assoc()) {
        $data[] = $row;
    }

    header('Content-Type: application/json');
    echo json_encode($data, JSON_PRETTY_PRINT);

} catch (Exception $e) {
    echo "FOUT: " . $e->getMessage();
}