1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74
|
$Sql="select * from ResultGame"; //ResultGame = nom de ma table
$Res=mysql_query($Sql);
$Compteur=mysql_num_rows($Res);
$i=1;
$j=0;
while ($i <= $Compteur)
{
$tab_score[$j]==$Enr["ScoreG"]; //ScoreG = la colonne de la table ResultGame dont je souhaite récupérer les informations
$Enr=mysql_fetch_array($Res);
$i++;
$j++;
}
print_r($Enr); // OK, me donne la dernière ligne de ma BD avec tous les infos
print_r($tab_score); //Page blanche
print_r (computeScore($sqlGroup));
?>
<?php
function computeScore($sqlGroup)
{
$currentScore = 0;
$bestScore = -1;
$meanScore = (double) 0;
$sumScore = 0;
$nbScore = 0;
$worstScore = 101;
while ($row = mysql_fetch_assoc($sqlGroup))
{
$currentScore = $row['ScoreG'];
if($currentScore > $bestScore)
{
$bestScore = $currentScore;
}
$sumScore = $sumScore + $currentScore;
$nbScore = $nbScore + 1;
if($currentScore < $worstScore)
{
$worstScore = $currentScore;
}
}
$meanScore = round(($sumScore / $nbScore), 1);
$lstScore = array();
if($worstScore == 101)
{
$worstScore = -1;
}
if($meanScore == 0)
{
$meanScore = -1;
}
$lstScore[0] = $bestScore;
$lstScore[1] = $meanScore;
$lstScore[2] = $worstScore;
return $lstScore;
} |
Partager