Advertisement
Guest User

Untitled

a guest
Feb 11th, 2019
162
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. <header>
  2. <nav class ="navbar navbar-default">
  3. <div class="container-fluid">
  4. <div class = "navbar-header">
  5. <h4 style ="color : grey">[IF645] Web Programing</h4>
  6. </div>
  7. <ul class ="navbar-nav">
  8. <li class = "navbar-right active"><a href="#">Employees</a></li>
  9. </ul>
  10. </div>
  11. </nav>
  12. </header>
  13.  
  14. <?php
  15.  
  16. $host = "localhost";
  17. $username = "root";
  18. $dbname = "northwind";
  19. $password = "";
  20. $db = new mysqli($host, $username, $password, $dbname);
  21. $query = "SELECT * FROM products LIMIT 12";
  22. $result = $db->query($query);
  23.  
  24. while ($row = $result-> fetch_assoc()){
  25. echo "<tr>";
  26. echo "<td>" . $row['ProductID']. "</td>";
  27. echo "<td>" . $row['ProductName']. "</td>";
  28. echo "<td>" . $row['QuantityPerUnit']. "</td>";
  29. echo "<td>" . $row['UnitPrice']. "</td>";
  30. echo "<td>" . $row['UnitPrice']. "</td>";
  31. echo "</tr>";
  32. }
  33. mysqli_free_result($result);
  34. mysqli_close($db);
  35. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement