<?php
require_once 'db/config.php';
header('Content-Type: application/json');

try {
    $pdo = db();
    $lab_tests = $pdo->query("SELECT test_id, test_name FROM lab_tests ORDER BY test_name ASC")->fetchAll(PDO::FETCH_ASSOC);
    $imaging_tests = $pdo->query("SELECT test_id, test_name FROM imaging_tests ORDER BY test_name ASC")->fetchAll(PDO::FETCH_ASSOC);

    echo json_encode([
        'success' => true,
        'lab_tests' => $lab_tests,
        'imaging_tests' => $imaging_tests
    ]);
} catch (PDOException $e) {
    echo json_encode(['success' => false, 'message' => 'Database error: ' . $e->getMessage()]);
}
?>