Advertisement
Guest User

xd

a guest
Dec 10th, 2018
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "root";
  4. $password = "";
  5. $dbname = "przychodnia";
  6.  
  7. // Create connection
  8. $conn = new mysqli($servername, $username, $password, $dbname);
  9. // Check connection
  10. if ($conn->connect_error) {
  11. die("Błąd łączenia z bazą: " . $conn->connect_error);
  12. }
  13. /*
  14. $i=$_GET["imie"];
  15. $n=$_GET["nazwisko"];
  16. $p=$_GET["punkty"];
  17. $sql = "INSERT INTO Tabela (imie, nazwisko, punkty)
  18. VALUES ('$i', '$n', '$p')";
  19. */
  20. if ($conn->query($sql) === TRUE) {
  21. echo "Dodano nowy rekord. <br>";
  22. } else {
  23. echo "Błąd: " . $sql . "<br>" . $conn->error;
  24. }
  25.  
  26.  
  27. $sql = "SELECT id, imie, nazwisko FROM pacjenci";
  28. $result = $conn->query($sql);
  29.  
  30. if ($result->num_rows > 0) {
  31. echo "<table border=1>";
  32. // output data of each row
  33. while($row = $result->fetch_assoc()) {
  34. echo $row["imie"]. $row["nazwisko"]. $row["punkty"];
  35. }
  36. echo "</table>";
  37. } else {
  38. echo "Brak wyników";
  39. }
  40.  
  41. $conn->close();
  42. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement