29 lines
929 B
PHP
29 lines
929 B
PHP
<?php
|
|
header('Content-Type: application/json');
|
|
|
|
if (php_sapi_name() === 'cli') {
|
|
$method = 'GET';
|
|
} else {
|
|
$method = $_SERVER['REQUEST_METHOD'] ?? 'GET';
|
|
}
|
|
|
|
try {
|
|
$pdo = new PDO("pgsql:host=localhost;dbname=adx_system", "admin", "admin123");
|
|
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
|
|
|
switch($method) {
|
|
case 'GET':
|
|
$stmt = $pdo->query("SELECT id, recipient_email, bounce_type, bounce_code, received_at, processed FROM bounce_log ORDER BY received_at DESC LIMIT 100");
|
|
$data = $stmt->fetchAll(PDO::FETCH_ASSOC);
|
|
echo json_encode(['success' => true, 'data' => $data], JSON_PRETTY_PRINT);
|
|
break;
|
|
|
|
default:
|
|
echo json_encode(['success' => false, 'error' => 'Method not supported: ' . $method]);
|
|
}
|
|
|
|
} catch(Exception $e) {
|
|
echo json_encode(['success' => false, 'error' => $e->getMessage()]);
|
|
}
|
|
?>
|