getSQLHost(), $data->getSQLUser(), $data->getSQLPassword(), $data->getSQLDatabase()); mysqli_set_charset($conn, "utf8"); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $result = $conn->query("SELECT * FROM `feuerwehr_pi`"); if ($result->num_rows > 0) { // output data of each row while ($row = $result->fetch_assoc()) { if ($row['id'] == 1) { echo("

Feuerwehrbereitschaft

"); } if ($row['id'] == 2) { echo("

Technische Einsatzleitung

"); } if ($row['id'] == 3) { echo("

ABC-Dienst/LZG

"); } if ($row['id'] == 10) { echo("

Revier Pinneberg

"); } if ($row['id'] == 20) { echo("

Revier Elmshorn

"); } if ($row['id'] == 30) { echo("

Revier Wedel

"); } if ($row['id'] == 40) { echo("

Revier Uetersen

"); } if ($row['id'] == 60) { echo("

Revier Hörnerkirchen

"); } if ($row['id'] == 70) { echo("

Revier Quickborn

"); } if ($row['id'] == 80) { echo("

Revier Barmstedt

"); } ?>

]

query("SELECT * FROM `feuerwehr` WHERE OrtID = " . $row['id']); if ($fahrzeuge->num_rows > 0) { while ($frow = $fahrzeuge->fetch_assoc()) { ?> 0) { ?>
Fahrzeugtyp Funkrufnummer