23 lines
671 B
PHP
23 lines
671 B
PHP
<?php
|
|
global $db;
|
|
try {
|
|
$query = "SELECT id, name, adresse, email FROM betriebe ORDER BY name";
|
|
$stmt = $db->prepare($query);
|
|
$stmt->execute();
|
|
|
|
$betriebe = [];
|
|
while ($row = $stmt->fetch()) {
|
|
$betriebe[] = [
|
|
'id' => (int)$row['id'],
|
|
'name' => $row['name'],
|
|
'adresse' => $row['adresse'] ?? '',
|
|
'telefon' => '',
|
|
'email' => $row['email'] ?? ''
|
|
];
|
|
}
|
|
echo json_encode($betriebe);
|
|
} catch (Exception $e) {
|
|
error_log("Error in betriebe/get.php: " . $e->getMessage());
|
|
http_response_code(500);
|
|
echo json_encode(['message' => 'Fehler beim Laden der Betriebe']);
|
|
} |