$row = mysqli_fetch_array($result_alumno, MYSQLI_NUM);
$value2 = $row[0];
$sql = "SELECT Nota FROM notas" . $curso . " WHERE N_Id_Escolar = '{$value2}' \n AND id_asignatura = '{$asignatura}';";
$result = mysqli_query($conn, $sql) or die("Error en el sql");
$series[$value] = array();
while ($row = mysqli_fetch_array($result, MYSQLI_NUM)) {
$series[$value][] = $row[0];
}
}
$myData = new pData();
$html = "<table border='1'>\n <tr>\n <th>Alumno</th>\n <th>Nota media</th>\n <th>Desviación estándar</th>\n <th>Mediana</th>\n <th>Nota más alta</th>\n </tr>";
foreach ($series as $key => $value) {
$myData->addPoints($value, $key);
$media = round($myData->getSerieAverage($key), 2);
$maxima = $myData->getMax($key);
$mediana = $myData->getSerieMedian($key);
$desviacion = round($myData->getStandardDeviation($key), 2);
$html .= "<tr><td>{$key}</td><td>{$media}</td>" . "<td>{$desviacion}</td><td>{$mediana}</td>" . "<td>{$maxima}</td></tr>";
}
$html .= "</table>";
echo $html;
}
?>
</div>
</div>
</div>
</div>
<!-- Pie de página -->
<div class="container-fluid bg-4 text-center" id='foot01'></div>
}
$MyData->setAxisName(0, "Temperatures");
$MyData->setAbscissaName("Samples");
/* Create the pChart object */
$myPicture = new pImage(700, 230, $MyData);
/* Turn of Antialiasing */
$myPicture->Antialias = FALSE;
/* Add a border to the picture */
$myPicture->drawRectangle(0, 0, 699, 229, array("R" => 0, "G" => 0, "B" => 0));
/* Write the chart title */
$myPicture->setFontProperties(array("FontName" => "../fonts/Forgotte.ttf", "FontSize" => 11));
$myPicture->drawText(150, 35, "Average temperature", array("FontSize" => 20, "Align" => TEXT_ALIGN_BOTTOMMIDDLE));
/* Set the default font */
$myPicture->setFontProperties(array("FontName" => "../fonts/pf_arma_five.ttf", "FontSize" => 6));
/* Define the chart area */
$myPicture->setGraphArea(60, 40, 650, 200);
/* Draw the scale */
$scaleSettings = array("XMargin" => 10, "YMargin" => 10, "Floating" => TRUE, "GridR" => 200, "GridG" => 200, "GridB" => 200, "DrawSubTicks" => TRUE, "CycleBackground" => TRUE);
$myPicture->drawScale($scaleSettings);
/* Turn on Antialiasing */
$myPicture->Antialias = TRUE;
/* Draw the line of best fit */
$myPicture->drawThreshold($MyData->getSerieMedian("Probe 1"), array("WriteCaption" => TRUE, "Caption" => "Median value"));
/* Turn on shadows */
$myPicture->setShadow(TRUE, array("X" => 1, "Y" => 1, "R" => 0, "G" => 0, "B" => 0, "Alpha" => 10));
/* Draw the line chart */
$myPicture->drawPlotChart();
/* Write the chart legend */
$myPicture->drawLegend(580, 20, array("Style" => LEGEND_NOBORDER, "Mode" => LEGEND_HORIZONTAL));
/* Render the picture (choose the best way) */
$myPicture->autoOutput("pictures/example.median.png");
