Advertisement
Guest User

Untitled

a guest
Jun 26th, 2019
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. $servername = "localhost";
  2. $username = "root";
  3. $password = "";
  4. $dbname = "praktikum";
  5. $conn = new mysqli($servername, $username, $password, $dbname);
  6. setlocale(LC_TIME, "de_DE.utf8");
  7. $sql = "SELECT user, comment, time FROM comments ORDER BY time desc";
  8. $result = $conn->query($sql);
  9. if ($result->num_rows > 0) {
  10.  
  11. while ($row = $result->fetch_assoc()) {
  12. echo "<p><strong>Name: <a class='user'>" . $row["user"] . "</a><br>
  13. Kommentar: </strong><br>" . $row["comment"] . "<br>
  14. <strong>Zeitpunkt der Veröffentlichung:</strong> " . strftime("%A, ") . $row["time"] . "</p><br><br>";
  15. }
  16. } else {
  17. echo "0 results";
  18. }
  19. $conn->close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement