Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!-- Mitgliederliste -->
- <html lang="de">
- <head>
- <title>Mitglider</title>
- <link rel="stylesheet" type="text/css" href="style.css">
- </head>
- <body>
- <table>
- <tr><td>Vorname</td><td>Nachname</td><td>Rang</td><td>Geburtsdatum</td></tr>
- <?php
- $DBUser="root";
- $DBHost="localhost";
- $DBPass="asr";
- $DBName="Feuerwehr";
- $connect=mysqli_connect($DBHost,$DBUser,$DBPass,$DBName)
- or die("Verbindung zur Datenbank fehlgeschlagen");
- $sql_command="SELECT Vorname,Nachname,ID,Rang,Funktion,Geburtsdatum,Personalnummer FROM `Mitglieder`";
- $DBQuery=mysqli_query($connect,$sql_command);
- while($DBZeile=mysqli_fetch_array($DBQuery))
- {
- if(isset($DBZeile ["Vorname"]))
- {
- echo "<tr><td>". $DBZeile ["Vorname"]. "</td>";
- }
- if(isset($DBZeile ["Nachname"]))
- {
- echo "<td>" . $DBZeile ["Nachname"]. "</td>";
- }
- if(isset($DBZeile ["Rang"]))
- {
- echo "<td>" . $DBZeile ["Rang"]. "</td>";
- }
- else
- {
- echo "<td>" . " ---- " . "</td>";
- }
- // if(isset($DBZeile ["Funktion"]))
- // {
- // echo "<td>" . $DBZeile ["Funktion"]. "</td>";
- // }
- // else
- // {
- // echo "<td>" . " ---- " . "</td>";
- // }
- if(isset($DBZeile ["Geburtsdatum"]))
- {
- echo "<td>" . $DBZeile ["Geburtsdatum"]. "</td></tr>";
- }
- }
- $close=mysqli_close($connect);
- ?>
- </table>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement