schedule.html

<? include INC_HEADER ?>
<?
$schedule = $db->prepare("select * from games where season = ? order by date asc");
$schedule->bindValue(1, 2015, PDO::PARAM_INT);
$schedule->execute();
?>
<header>
    <h1>Schedule</h1>
</header>
<table class="schedule">
    <tbody>
<? while ($game = $schedule->fetchObject()): ?>
        <tr>
            <td class="competition logo"><img class="logo" src="">
            <td class="date"><?= date('M d, Y',strtotime($game->date)), $game->time ? '<br>' . date('g:i A', strtotime($game->time)) : '' ?>
            <td class="logo"><?= $game->oppLogo ? '<img class="logo" src="' . $game->oppLogo . '">' : '' ?>
            <td class="opp<?= $game->away ? ' away' : '' ?>"><?= $game->opponent ?>
            <td class="result"><?= !is_null($game->novaScore) && !is_null($game->oppScore) ? ($game->novaScore > $game->oppScore ? 'W ' : ($game->novaScore < $game->oppScore ? 'L ' : 'T ')) : '', $game->novaScore, '-', $game->oppScore ?>
        </tr>
<? endwhile; ?>
<? /* 7's schedule by hand :(
        <tr>
            <td class="competition logo"></td>
            <td class="date">May 31, 2014</td>
            <td class="logo"></td>
            <td class="opp away">Monk Vaughn 7s</td>
            <td class="result">Richmond, VA</td>
        </tr>
        <tr>
            <td class="competition logo"></td>
            <td class="date">Jun 14, 2014</td>
            <td class="logo"></td>
            <td class="opp away">Ruggerama/NOVA 7s (MAC Qualifier)</td>
            <td class="result">Manasssas, VA</td>
        </tr>
        <tr>
            <td class="competition logo"></td>
            <td class="date">Jun 28, 2014</td>
            <td class="logo"></td>
            <td class="opp away">Wilmington 7s (MAC Qualifier)</td>
            <td class="result">Wilmington, DE</td>
        </tr>
        <tr>
            <td class="competition logo"></td>
            <td class="date">Jul 5, 2014</td>
            <td class="logo"></td>
            <td class="opp away">Cap Fear 7s</td>
            <td class="result">Wilmington, SC</td>
        </tr>
        <tr>
            <td class="competition logo"></td>
            <td class="date">Jul 12, 2014</td>
            <td class="logo"></td>
            <td class="opp away">Rocky George 7s (MAC Qualifier)</td>
            <td class="result">Laurel, MD</td>
        </tr>
        <tr>
            <td class="competition logo"></td>
            <td class="date">Jul 26, 2014</td>
            <td class="logo"></td>
            <td class="opp away">MAC 7s Championship</td>
            <td class="result">Laurel, MD</td>
        </tr>
        <tr>
            <td class="competition logo"></td>
            <td class="date">Aug 9-10, 2014</td>
            <td class="logo"></td>
            <td class="opp away">USA Club 7s National Championship</td>
            <td class="result">TBD</td>
        </tr>
        */ ?>
    </tbody>
</table>
<? include INC_FOOTER ?>