36 lines
1.4 KiB
PHP
Executable File
36 lines
1.4 KiB
PHP
Executable File
<?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, domain_name, verified, daily_limit, sent_today, created_at FROM domains ORDER BY domain_name");
|
|
$data = $stmt->fetchAll(PDO::FETCH_ASSOC);
|
|
echo json_encode(['success' => true, 'data' => $data], JSON_PRETTY_PRINT);
|
|
break;
|
|
|
|
case 'POST':
|
|
$input = json_decode(file_get_contents('php://input'), true) ?: $_POST;
|
|
$stmt = $pdo->prepare("INSERT INTO domains (domain_name, daily_limit, verified) VALUES (?, ?, ?) ON CONFLICT (domain_name) DO UPDATE SET updated_at = NOW()");
|
|
$stmt->execute([$input['domain_name'] ?? '', $input['daily_limit'] ?? 10000, $input['verified'] ?? false]);
|
|
echo json_encode(['success' => true, 'message' => 'Domain processed']);
|
|
break;
|
|
|
|
default:
|
|
echo json_encode(['success' => false, 'error' => 'Method not supported: ' . $method]);
|
|
}
|
|
|
|
} catch(Exception $e) {
|
|
echo json_encode(['success' => false, 'error' => $e->getMessage()]);
|
|
}
|
|
?>
|