Advertisement
Guest User

Untitled

a guest
Dec 3rd, 2018
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. <?php
  2. $date=date("Y-m-d");
  3. $servername="serwer1852922.home.pl";
  4. $username="28779846_fiedziuk";
  5. $password="uczenzschie";
  6. $baza="28779846_fiedziuk";
  7.  
  8. $connect= new mysqli($servername,$username,$password,$baza);
  9. $result=mysqli_query($connect,"SELECT waluty.nazwa,
  10. waluty.skrot, kursy.skup, kursy.sprzedaz
  11. from kursy
  12. inner join waluty
  13. on waluty.id_waluta=kursy.id_waluta
  14. where kursy.data='.$date'");
  15. echo "<table>";
  16. echo "<tr>";
  17. echo "<th>Nazwa</th>";
  18. echo "<th>Skrót</th>";
  19. echo "<th>Skup</th>";
  20. echo "<th>Sprzedaż</th>";
  21. echo "</tr>";
  22. while ($row=mysqli_fetch_array($result)){
  23. echo "<tr>";
  24. echo "<td>" . $row['waluty.skrot'] . "</td>";
  25. echo "</tr>";
  26. echo "$row";
  27. }
  28. echo "</table>";
  29. echo "<a>Kursy walut na dzień: </a>";
  30. echo "$date";
  31. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement