Advertisement
Guest User

Untitled

a guest
Sep 11th, 2016
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. <html>
  2. <head>
  3. <meta charset="utf-8">
  4. <title>Zadanie domowe</title>
  5. </head>
  6. <body>
  7. <?php
  8. $user = 'root';
  9. $password = '';
  10. $database = 'cwphp';
  11.  
  12. $con = mysql_connect('localhost', $user, $password);
  13. @mysql_select_db($database) or die("Nie udało się wybrać bazy danych");
  14.  
  15. $query = 'SELECT * FROM ksiazkatelefoniczna';
  16. $wynik = mysql_query($query) or die("Błąd zapytania");
  17.  
  18. if(mysql_num_rows($wynik) > 0){
  19. echo "Są dane w tabeli";
  20.  
  21. echo "<table cellpadding=\"4\" border=1>"
  22. while($r = mysql_fetch_assoc($wynik)) {
  23. echo "<tr>";
  24. echo "<td>".$r['nr']."</td>";
  25. echo "<td>".$r['imie']."</td>";
  26. echo "<td>".$r['nazwisko']."</td>";
  27. echo "<td>".$r['telefon']."</td>";
  28. echo "</tr>";
  29. }
  30. echo "</table>";
  31. }
  32. mysql_free_result($wynik);
  33.  
  34. mysql_close($con);
  35. ?>
  36. </body>
  37. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement