
<!DOCTYPE html>
<html lang="en" dir="ltr">
  <head>
    <meta charset="utf-8">
    <link rel="stylesheet" href="main1.css">
    <link rel="stylesheet" href="/css/master.css">
    <link rel="stylesheet" href="form.css">
     <link rel="stylesheet" href="jquery.css">
    <link rel="stylesheet" href="../tableview.css">
    <title>View Current Guest for Today</title>
  </head>
  <body>
    <?php
    
    require "database.php";





    // echo "Haha.. Connected successfully";
    $sql = "SELECT * FROM guest 
    WHERE GuestDate = CURDATE() " ;

    $results = mysqli_query($conn, $sql);

    if ($results === false) {
      // code...
      echo mysqli_error($conn);
    } else {
      // code...
      $viewGuests= mysqli_fetch_all($results, MYSQLI_ASSOC);



    }

     ?>
     <div class="field">



      
      <h2><center>Current Guest(s) for today only</center></h2>

           <?php if (empty($viewGuests)):?>
             <p>No Guest found</p>
           <?php else: ?>
           <ul>
             <?php foreach ($viewGuests as $Guest):  ?>
            <div class="field">


             <table id="Guests">
               <tr>
                 <th>Name</th>
                 <th> Date</th>
                 <th> Time</th>
               </tr>

               <tr>
                 <td><?= $Guest['GuestFirstName'] ?></td>
                 <td><?= $Guest['GuestLastName'] ?></td>
                 
               </tr>
             </table>
           <?php endforeach; ?>
           </ul>
         <?php endif; ?>

        
         </div>
         </div>


  </body>
</html>
