| Server IP : 79.136.114.73 / Your IP : 216.73.216.25 Web Server : Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.29 OpenSSL/1.0.1f System : Linux b8009 3.13.0-170-generic #220-Ubuntu SMP Thu May 9 12:40:49 UTC 2019 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/appsrv.astacus.se/maif/folkhalsan/results/ |
Upload File : |
<?php
$servername = "localhost"; // Ändra vid behov
$username = "root"; // Din MySQL-användare
$password = "root123"; // Lösenord för MySQL
$dbname = "Maif"; // Namn på databasen
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Anslutningen misslyckades: " . $conn->connect_error);
}
$sql = "SELECT * FROM MaifFormularA ORDER BY team";
$result = $conn->query($sql);
function getRatingText($value) {
switch ((int)$value) {
case 4: return "Jättebra";
case 3: return "OK";
case 2: return "Inte helt OK";
case 1: return "Dåligt";
default: return "N/A";
}
}
function calculateAverage($values) {
return count($values) > 0 ? round(array_sum($values) / count($values), 2) : 0;
}
if ($result->num_rows > 0) {
$currentTeam = "";
$ratings = [];
$totalAverages = [];
echo "<meta charset='UTF-8'><style>
table { border-collapse: collapse; width: 100%; margin-bottom: 30px; }
th, td { padding: 8px; text-align: left; border: 1px solid #ddd; }
th { background-color: #f2f2f2; }
tr:hover { background-color: #f1f1f1; }
.overall-average { font-weight: bold; background: #f2f2f2; text-align: right; padding: 10px; margin-bottom: 30px; }
</style>";
while ($row = $result->fetch_assoc()) {
if ($currentTeam !== $row['team']) {
// Stäng föregående lag
if ($currentTeam !== "") {
echo "<tr style='font-weight: bold;'>";
$teamTotal = 0; $numCols = 0;
foreach ($ratings as $values) {
$avg = calculateAverage($values);
echo "<td>$avg</td>";
$teamTotal += $avg; $numCols++;
}
echo "<td></td></tr></table>";
$overallTeamAverage = $numCols > 0 ? round($teamTotal/$numCols, 2) : 0;
echo "<div class='overall-average'>Totalt medelbetyg för " . htmlspecialchars($currentTeam) . ": $overallTeamAverage</div>";
$totalAverages[] = $overallTeamAverage;
}
// Nytt lag
$currentTeam = $row['team'];
$ratings = [
'training_feeling' => [],
'at_training_feeling' => [],
'competition_feeling' => [],
'learn_new_things' => [],
'fun_exercises' => [],
'feel_safe_with_coach' => [],
'speak_freely_to_coach' => [],
'coach_listens' => [],
'coach_knowledge' => [],
'coach_explains' => [],
'coach_help' => [],
'coach_praise' => [],
'coach_encourage' => [],
'friends_at_training' => [],
'feel_safe_in_group' => [],
'speak_freely_in_group' => [],
'friends_listen' => [],
'group_is_nice' => []
];
echo "<h2>Lag: " . htmlspecialchars($currentTeam) . "</h2>";
echo "<table><tr>
<th>Hur mår du?</th>
<th>Stämningen i laget</th>
<th>Träningsupplägget</th>
<th>Lär sig nya saker</th>
<th>Roliga övningar</th>
<th>Trygg med ledare</th>
<th>Vågar prata med ledare</th>
<th>Ledarna lyssnar</th>
<th>Ledarnas kunskap</th>
<th>Ledarna förklarar</th>
<th>Får hjälp av ledare</th>
<th>Ledarna ger beröm</th>
<th>Ledarna uppmuntrar</th>
<th>Vänner på träningen</th>
<th>Trygg i gruppen</th>
<th>Vågar prata i gruppen</th>
<th>Vänner lyssnar</th>
<th>Alla är trevliga</th>
<th>Kommentarer</th>
</tr>";
}
foreach ($ratings as $key => &$values) {
if (isset($row[$key]) && is_numeric($row[$key])) {
$values[] = (int)$row[$key];
}
}
unset($values);
echo "<tr>";
foreach ($ratings as $key => $values) {
echo "<td>" . getRatingText($row[$key]) . "</td>";
}
echo "<td>" . htmlspecialchars($row['comments']) . "</td></tr>";
}
// Sista laget
echo "<tr style='font-weight: bold;'>";
$teamTotal = 0; $numCols = 0;
foreach ($ratings as $values) {
$avg = calculateAverage($values);
echo "<td>$avg</td>";
$teamTotal += $avg; $numCols++;
}
echo "<td></td></tr></table>";
$overallTeamAverage = $numCols > 0 ? round($teamTotal/$numCols, 2) : 0;
echo "<div class='overall-average'>Totalt medelbetyg för " . htmlspecialchars($currentTeam) . ": $overallTeamAverage</div>";
$totalAverages[] = $overallTeamAverage;
// Alla lag tillsammans
$overallTotalAverage = count($totalAverages) > 0 ? round(array_sum($totalAverages)/count($totalAverages), 2) : 0;
echo "<div class='overall-average'>Total medelbetyg för alla lag: $overallTotalAverage</div>";
} else {
echo "Inga svar har registrerats ännu.";
}
$conn->close();
?>