$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");