18 lines
624 B
PHP
18 lines
624 B
PHP
<?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()]);
|
|
}
|
|
?>
|