events.list.php

<?php
require_once 'functions.php';

if ($_GET['show_all']) {
  $list = $db->query("SELECT * FROM events ORDER BY date DESC");
}
else {
  $list = $db->query("SELECT * FROM events WHERE active = 1 ORDER BY date DESC");
}

?>
<!doctype html>
<html>
<head>
<title>List of Events | <?php echo SITENAME ?></title>
<?php echo $head ?>
</head>
<body>


<?php require_once 'include.header.php'; ?>

  <a href="info/event" class="btn btn-info pull-right">Add Event</a>
  <a href="events.list.php?show_all=TRUE" class="btn btn-info">Show Archived Events</a>

  <h1>List of Events</h1>

  <table class="table table-striped">
    <tr>
      <th>Date</th>
      <th>Event</th>
      <th>Actions</th>
      <th> </th>
    </tr>
  <?php while ($row = $list->fetch()) { ?>
    <?php if ($row[active] == FALSE) { $style = ' [ARCHIVED]'; } else { $style = ''; } ?>
    <tr>
      <td><?php echo format_date("M d, Y", $row['date']) ?></td>
      <td><a href="events/dashboard/<?php echo $row['id'] ?>"><?php echo $row['name'] . $style; ?></a></td>
      <td><a href="edit/event/<?php echo $row['id'] ?>">Edit event</a></td>
      <td><a href="event.dashboard.php/?id=<?php echo $row['id'] ?>&amp;active=false">Archive event</a></td>
    </tr>
  <?php } ?>
  </table>

<?php require_once 'include.footer.php'; ?>

</body>
</html>