HTML-Code:
<?php $servername = ""; $username = ""; $password = ""; $dbname = ""; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT * FROM anfragen ORDER BY id DESC LIMIT 20"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { echo ' <tr class="unread"> <td><div class="text-center h5 text-black">' . $row["id"] . '</div></td> <td> <h6 class="mb-1">' . $row["name"] . '</h6> <p class="m-0">' . $row["bezirk"] . ' , ' . $row["help"] . '</p> </td> <td> <button class="btn btn-primary" data-toggle="modal" data-target="#exampleModal' . $row["id"] . '">Infos</button> </td> <td class="text-center"><a href="add.php" class="label theme-bg2 text-white f-18">Annehmen</a><a href="#!" class="label theme-bg text-white f-18">Löschen</a></td> </tr> <div class="modal fade" id="exampleModal' . $row["id"] . '" tabindex="1100" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <h2 class="modal-title" id="exampleModalLabel">Infos</h2> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <div class="modal-body"> <p>Name: ' . $row["name"] . '</p> <p>Kontakt: ' . $row["kontakt"] . '</p> <p>Hilfstätigkeit: ' . $row["help"] . '</p> <p>Bezirk: ' . $row["bezirk"] . '</p> <p>Info: ' . $row["info"] . '</p> <p>Eintragen am: ' . $row["reg_date"] . '</p> </div> <div class="modal-footer"> <button type="button" class="btn btn-primary" data-dismiss="modal">Verstanden</button> </div> </div> </div> </div>'; } } else { echo ' <h3 class="f-w-300 d-flex align-items-center m-b-0"><i class="fas fa-user-clock text-c-red f-30 m-r-10"></i>Keine Einträge</h3>'; } $conn->close(); ?>
Kommentar