<?php
try {
    global $DBSettings;
    $options = [
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
        PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci"
    ];
    $dsn = "odbc:DRIVER={$DBSettings['driver']};SERVER={$DBSettings['server']};DATABASE={$DBSettings['game_db']};charset=utf8mb4";
    $pdo = new PDO($dsn, $DBSettings['uid'], $DBSettings['pass'], $options);

    $haber_secenek = isset($_POST['haber_secenek']) ? (int)$_POST['haber_secenek'] : 1;

    $stmt = $pdo->prepare("SELECT haber_basligi, haber_icerigi, haber_tarihi
                           FROM _panelhaber
                           WHERE haber_secenek = :haber_secenek
                           ORDER BY haber_tarihi DESC");
    $stmt->bindParam(':haber_secenek', $haber_secenek, PDO::PARAM_INT);
    $stmt->execute();

    $haberler = $stmt->fetchAll();

    if ($haberler) {
        header('Content-Type: application/json; charset=utf-8');
        echo json_encode($haberler, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES);
    } else {
        echo json_encode(['error' => "Haber bulunamadı."], JSON_UNESCAPED_UNICODE);
    }
} catch (PDOException $e) {
    echo json_encode(['error' => "Bağlantı hatası: " . $e->getMessage()], JSON_UNESCAPED_UNICODE);
}