Advertisement
Guest User

Untitled

a guest
Nov 14th, 2018
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. <!DOCTYPE HTML>
  2. <html lang="pl">
  3. <head>
  4. <meta charset="utf-8">
  5. </head>
  6. <body>
  7. <?php
  8. $server = 'localhost';
  9. $user = 'root';
  10. $pass = '';
  11. $db = 'szkoła';
  12.  
  13. $mysqli = new mysqli($server, $user, $pass, $db);
  14. ?>
  15. <h3>Uczeń:</h3>
  16. <?php
  17. if($wynik = $mysqli->query
  18. ("SELECT * FROM uczen OREDER BY id")){
  19.  
  20. if($wynik->num_rows > 0){
  21. echo "<table border='1' cellpadding='10'>";
  22.  
  23. echo "<tr><th>ID</th><tr><th>Imie</th><tr><th>Nazwisko</th><tr><th>Pesel</th><tr><th>Klasa</th></tr>";
  24.  
  25. while($record = $wynik->fetch_object()){
  26. echo "<tr>";
  27. echo "<td>" . $record->id. "</td>";
  28. echo "<td>" . $record->imie. "</td>";
  29. echo "<td>" . $record->nazwisko. "</td>";
  30. echo "<td>" . $record->Pesel. "</td>";
  31. echo "<td>" . $record->klasa. "</td>";
  32. echo "</tr>";
  33. }
  34. echo "</table>";
  35. } else {
  36. echo "Brak rekordów";
  37. }
  38. else {
  39. echo "Błąd:" . $mysqli->error;
  40. }
  41. $mysqli->close();
  42. ?>
  43. </body>
  44. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement