Advertisement
thenvr

open

Dec 13th, 2017
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.30 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <style>
  4.  table {
  5.   display: block;
  6.   font-family: sans-serif;
  7.   font-size: 115%;
  8.   overflow: auto;
  9.   width: auto;
  10.  }
  11.   th {
  12.     background-color: white;
  13.     color: black;
  14.     font-weight: normal;
  15.     padding: 20px 30px;
  16.     text-align: center;
  17.     border: 1px solid black;
  18.   }
  19.   td {
  20.    
  21.     color: black;
  22.     padding: 20px 30px;
  23.     border: 1px solid black;
  24.   }
  25.  
  26. </style>
  27. <body>
  28.  
  29. <?php
  30. $servername = "localhost";
  31. $username = "frontend";
  32. $password = "frontend";
  33. $dbname = "info2";
  34.  
  35.  
  36. $conn = mysqli_connect($servername, $username, $password, $dbname);
  37.  
  38.  
  39.  
  40. $sql = "SELECT DAY, MO, MC, ANO,ANC FROM OPEN";
  41. $result = mysqli_query($conn, $sql);
  42.  
  43. ?>
  44. <table>
  45. <tr>
  46.   <th>Day</th>
  47.   <th>Morning</th>
  48.   <th>Afternoon</th>
  49. </tr>
  50. <?php
  51.  
  52. if (mysqli_num_rows($result) > 0) {
  53.    
  54.     while($row = mysqli_fetch_assoc($result)) {
  55. ?>
  56.     <tr>
  57.     <td><?php echo $row["DAY"] ?></td>
  58.     <td><?php echo $row["MO"]. " - " . $row["MC"] ?></td>
  59.     <td><?php echo  $row["ANO"]. " - " . $row["ANC"]?></td>
  60.     </tr>
  61. <?php
  62.         // echo "Day: " . $row["DAY"]. " - Morning: " . $row["MO"]. " - " . $row["MC"]."  -Afternoon: ". $row["ANO"]. " - " . $row["ANC"]. "<br>";
  63.     }
  64. } else {
  65.     echo "error";
  66. }
  67.  
  68. mysqli_close($conn);
  69. ?>
  70.  
  71. </table>
  72.  
  73. </body>
  74. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement