<?php
/*
* Author: Sarah Hall
* Date Created: 12/08/2015
* Summary: Created for On The Bit Sim game members, in php and mysql for leaderboards
*/
include_once 'functions.php';
$name = trim(filter_input(INPUT_GET, "name", FILTER_SANITIZE_STRING));
$results = showPerHorse($name, $dbh);
function showName($arr)
{
return $arr['showName'];
}
$shows = array_map('showName', $results);
$points = points($results);
echo '<h1>' . $name . '</h1>';
echo "<div id='stats'>\n<b>Total Points: </b> {$points}<br/>\n</div>\n<div id='results'>";
foreach ($shows as $show) {
echo "<h3>{$show}</h3>\n\t\t<table>\n\t\t<thead>\n\t\t<tr>\n\t\t<th>Class Name</th>\n\t\t<th>Place</th>\n\t\t</tr>\n\t\t</thead>\n\t\t<tbody>";
foreach ($results as $result) {
if ($result['showName'] == $show) {
echo "\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td>{$result['className']}</td>\n\t\t\t\t\t\t\t<td>{$result['place']}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t";
}
}
echo "</tbody></table>";
}
echo "\n\n</div>";
echo '
<table class="footable" data-page-size="25" data-filter="#filter">
<thead>
<tr colspan="2">
<input id="filter" type="text" placeholder="Search" style="margin-right:10px;"/>
</tr>
<tr>
<th>Horse Name</th>
<th data-type="numeric" data-sort-initial="descending">Points</th>
</tr>
</thead>
<tbody>';
foreach ($horses as $horse) {
echo '<tr>
<td><a href="display.php?name=' . $horse[horseName] . ' " >' . $horse[horseName] . '</a></td>
<td>' . points(showPerHorse($horse['horseName'], $dbh)) . '</td>
</tr>';
}
echo '
</tbody>
<tfoot class="hide-if-no-paging">
<tr>
<td colspan="5">
<div class="pagination pagination-centered"></div>
</td>
</tr>
</tfoot>
</table>';
?>
<!-- Scripts --->
<script type="text/javascript">
