| # |
$name |
EOM;
foreach ([
'計' => 'total_count',
'男性' => 'male_count',
'女性' => 'female_count',
'勝利' => 'winner_count',
'平均スコア' => 'average_score',
'最大スコア' => 'max_score',
] as $name => $sort_key) {
if ($sort_key !== $current_sort_key)
echo "${name} | ";
else {
echo "${name} | ";
}
}
echo "
\n";
$rank = 0;
foreach ($stat as $k => $s) {
$rank ++;
$name_link = "{$s['name']}";
$average_score = floor($s['average_score']);
echo <<
$rank |
$name_link |
{$s['total_count']} |
{$s['male_count']} |
{$s['female_count']} |
{$s['winner_count']} |
$average_score |
{$s['max_score']} |
EOM;
}
echo "";
}
$db = new ScoreDB();
$time_start = microtime(true);
$sort_key_column = filter_input(INPUT_GET, 'sort_key') ?: 'total_count';
$statistics = $db->get_statistics_tables($sort_key_column);
$query_time = microtime(true) - $time_start;
?>
変愚蛮怒 人気のある種族・職業・性格
人気のある種族
人気のある職業
人気のある性格