Advertisement
Guest User

Untitled

a guest
Dec 13th, 2017
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.94 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <body>
  4.  
  5. <?php
  6. $servername = "localhost";
  7. $username = "frontend";
  8. $password = "frontend";
  9. $dbname = "info2";
  10.  
  11. // Create connection
  12. $conn = mysqli_connect($servername, $username, $password, $dbname);
  13. // Check connection
  14. if (!$conn) {
  15.     die("Connection failed: " . mysqli_connect_error());
  16. }
  17.  
  18. $sql = "SELECT DAY, MO, MC, ANO,ANC FROM OPEN";
  19. $result = mysqli_query($conn, $sql);
  20.  
  21. if (mysqli_num_rows($result) > 0) {
  22.     // output data of each row
  23.  
  24. ?>
  25. <table>
  26. <tr>
  27.   <th>Day</th>
  28.   <th>Morning</th>
  29.   <th>Afternoon</th>
  30. </tr>
  31.  
  32. <?
  33.     while($row = mysqli_fetch_assoc($result)) {
  34.  
  35.         ?>
  36.         <tr>
  37.             <td><?= $row["DAY"] ?></td>
  38.             <td><?= $row["MO"]. " - " . $row["MC"] ?></td>
  39.             <td><?=  $row["ANO"]. " - " . $row["ANC"]?></td>
  40.         </tr>
  41.         <?
  42.     }
  43. ?>
  44. </table>
  45.     <?
  46. } else {
  47.     echo "0 results";
  48. }
  49.  
  50. mysqli_close($conn);
  51. ?>
  52.  
  53. </body>
  54. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement