Guest User

Untitled

a guest
Dec 6th, 2018
46
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $dbname = "zadania";
  4. $username = "root";
  5. $password = "";
  6.  
  7. $connect = mysqli_connect($servername, $username, $password, $dbname);
  8.  
  9. if (!$connect) {
  10. die("Connection failed: " . mysqli_connect_error());
  11. }
  12. echo "Connected successfully <br>";
  13.  
  14. $zapytanie = "SELECT * FROM Studenci";
  15. $result = mysqli_query($connect,$zapytanie);
  16.  
  17. if (mysqli_num_rows($result) > 0) {
  18.  
  19. while($row = mysqli_fetch_assoc($result)) {
  20. echo "id: " . $row["ID_Studenta"]. " - Imie: " . $row["Imie"]. " " . $row["Nazwisko"]. "<br>";
  21. }
  22. } else {
  23. echo "0 results";
  24. }
  25.  
  26. mysqli_close($connect);
  27. ?>
Add Comment
Please, Sign In to add comment