
<!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="tableview.css">
    <title>view All Children's Attendees</title>
  </head>
  <body>
    <?php
    require '../includes/db.php';





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

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

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



    }

     ?>
     <div class="field">



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


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

               <tr>
                 <td><?= $Guest['CheckingName'] ?></td>
                 <td><?= $Guest['CheckingDate'] ?></td>
                 <td><?= $Guest['CheckingIn'] ?></td>
               </tr>
             </table>
           <?php endforeach; ?>
           </ul>
         <?php endif; ?>

         <?php require 'footer.php' ?>
         </div>
         </div>


  </body>
</html>
