include 'pages/header/result_header.php';
}
$obj_utils = new DbUtils();
$obj_utils->connect();
$queryKey = HTTP_RESQUEST::get('query');
$course = HTTP_RESQUEST::get('course');
if ($queryKey == "general") {
$course = $obj_utils->getCourse();
}
$courseToShow = $course;
if ($queryKey == "challenge") {
$courseToShow = "ALL CHALLENGE";
}
$tool = new Tool($obj_utils);
$query = getQueryForKey($queryKey, $course);
$tabRequest = $obj_utils->executeQuery($query);
?>
<h1>Resultats <?php
echo $courseToShow;
?>
</h1>
<?php
if ($queryKey == "challenge" && $tabRequest != 0) {
$results = $tool->buildList($tabRequest);
?>
<table><tr><td>
<table class="principale">
<tr>
<th colspan="5"><h2>CHALLENGE</h2></th>
</tr>
<tr>
<table border="1">
<?php
require_once 'tools/db/DbUtils.php';
require_once 'tools/service/tools.php';
$dbUtils = new DbUtils();
$dbUtils->connect();
$tools = new Tool($dbUtils);
$tab = $dbUtils->executeQuery("select * from runnerdata order by nom, prenom");
$tabIdentique = array();
$previous = "";
$cpttab = 0;
for ($i = 0; $i < sizeof($tab); $i++) {
$current = $tab[$i]['nom'] . "_" . $tab[$i]['prenom'];
?>
<tr class="list">
<td class="listing"><?php
echo $i + 1;
?>
</td>
<td class="listing"><?php
echo $tab[$i]['nom'];
?>
</td>
<td class="listing"><?php
echo $tab[$i]['prenom'];
?>
</td>
<td class="listing"><?php
echo $tab[$i]['club'];
?>
>
<?php
echo $currentCourse;
?>
</option>
<?php
}
?>
</select>
<input type="hidden" value="changeCourse" name="actionType"/>
</form>
<br>
<?php
$query = getQueryForKey("results", $course);
$tabRunners = $obj_utils->executeQuery($query);
if ($tabRunners != 0) {
?>
<table class="principale">
<tr>
<th colspan="7"><h2>Correction des résultats de <?php
echo $course;
?>
</h2></th>
</tr>
<tr>
<th>Général</th>
<th>Formation</th>
<th>Dossard</th>
<th>Temps</th>
<th>Nouveau Temps</th>
