<?php
$dblink = new mysqli("localhost", "xxx", "xxx", "xxx");
$dblink->set_charset("utf8");
$dblink->query ( "SET NAMES 'utf8'" );
$dblink->query ( "SET CHARACTER SET 'utf8'" );
$result = mysqli_query($dblink, "SELECT
a.first_name AS Vorname,
a.last_name AS Nachname,
s.translation AS STATUS,
DATE(a.DATE) AS Datum,
MAX(CASE v.applicationid WHEN 5 THEN f.VALUE ELSE '' END) AS stadt,
MAX(CASE v.applicationid WHEN 6 THEN f.VALUE ELSE '' END) AS land,
MAX(CASE v.applicationid WHEN 21 THEN f.VALUE ELSE '' END) AS turnier,
MAX(CASE v.applicationid WHEN 19 THEN f.VALUE ELSE '' END) AS gruppe
FROM
xxx_seminarman_application a
INNER JOIN xxx_seminarman_status s
ON a.STATUS = s.uid
LEFT JOIN (SELECT VALUE, applicationid FROM xxx_seminarman_fields_values WHERE applicationid IN (5,6,19,21)) f
ON a.id = f.applicationid
WHERE
s.uid = 2
GROUP BY
a.first_name,
a.last_name,
s.translation,
DATE(a.DATE)
HAVING
turnier = 'SALZBURG OPEN 2015'
ORDER BY
a.DATE");
;
$fields_num = mysqli_field_count($result, dblink);
echo '<div class="demo-container"><table class="footable">';
echo'<thead><tr class="footable-detail-show"><th class="footable-first-column footable-sortable footable-sorted" data-type="numeric">Nr <span class="footable-sort-indicator"></span></th><th class="footable-sortable">Vorname <span class="footable-sort-indicator"></span></th><th class="footable-sortable">Nachname <span class="footable-sort-indicator"></span></th><th class="footable-sortable" data-hide="phone" width="200px">Turnier <span class="footable-sort-indicator"></span></th><th class="footable-sortable" data-hide="phone" width="175px">Status <span class="footable-sort-indicator"></span></th><th class="footable-sortable" data-hide="phone, tablet">Datum <span class="footable-sort-indicator"></span></th><th class="footable-sortable" data-hide="phone, tablet" width="60px">Stadt <span class="footable-sort-indicator"></span></th><th class="footable-sortable" data-hide="phone" width="90px">Land <span class="footable-sort-indicator"></span></th><th class="footable-last-column footable-sortable" data-hide="phone" width="200px">Gruppe* <span class="footable-sort-indicator"></span></th></tr></thead>';
echo'<tbody>';
$i=0;
while($data = mysqli_fetch_assoc($result))
{
echo'<tr>';
echo '<td>'.++$i.'</td><td>'.$data['Vorname'].'</td><td>'.$data['Nachname'].'</td><td>'.$data['turnier'].'</td><td>'.$data['Status*'].'</td><td>'.$data['Datum'].'</td><td>'.$data['stadt'].'</td><td>'.$data['land'].'</td><td>'.$data['gruppe*'].'</td>';
echo'</tr>';
}
echo "</tbody></table></div></div></div>";
// Verbindung zum Datenbankserver beenden
mysqli_close($db);
?>