Advertisement
Guest User

Untitled

a guest
Oct 30th, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.99 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <title></title>
  5. <style type="text/css">
  6. .dbsuccess{
  7. color: green;
  8. font-weight: bold;
  9. }
  10. .dbfail{
  11. color: red;
  12. font-weight: bold;
  13. }
  14. </style>
  15. </head>
  16. <body>
  17. <?php
  18.  
  19. $server = "localhost";
  20. $user = "root";
  21. $password = "";
  22. $dbname = "habryka";
  23.  
  24. $mysqli = new mysqli($server, $user, $password, $dbname);
  25.  
  26. if(!$mysqli->connect_error){
  27.  
  28.  
  29. $query = "SELECT * FROM `users`";
  30.  
  31. $result = $mysqli->query($query);
  32.  
  33. if($result){
  34. echo "<ol>";
  35. while($row = $result->fetch_assoc()){
  36. echo "<li>Halo, tutaj ".$row["imie"]." mam ".$row["wiek"]." lat i lubie ".$row['lubie'].".</br></li>";
  37.  
  38.  
  39. }
  40. echo "</ol>";
  41.  
  42. }
  43. die ("</br><span class='dbsuccess'>Nawiązano połączenie z bazą danych ".$dbname."</span></br>". $mysqli->connect_error);
  44. $mysqli->close();
  45. }else{
  46. die ("<span class='dbfail'>Błąd połączenia z bazą danych</span> ". $mysqli->connect_error);
  47. }
  48.  
  49. ?>
  50. </body>
  51. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement