function cursNoteAlumnsAssignature($curs, $assign)
{
$array_notes = [];
$mysqli = new mysqli("localhost", "root", "adminuser", "ESCOLA_DB");
if ($mysqli->connect_errno) {
echo "problema al connectar MySQL: " . $mysqli->connect_error;
}
$sentencia = $mysqli->prepare("SELECT NOTA FROM NOTA WHERE CURS_ID IN (SELECT ID_CURS FROM CURS WHERE NOM_CURS = ? AND ASSIGNATURA_ID IN (SELECT ID_ASSIGNATURA FROM ASSIGNATURA WHERE NOM_ASSIGNATURA LIKE ?))");
$sentencia->bind_param("ss", $curs, $assign);
$sentencia->execute();
$sentencia->bind_result($nota);
while ($sentencia->fetch()) {
array_push($array_notes, $nota);
}
declaraGlobals($array_notes);
}
function cursNoteAlumnsAssignature($assign, $curs)
{
$array_notes = [];
$mysqli = new mysqli("localhost", "root", "adminuser", "ESCOLA_DB");
if ($mysqli->connect_errno) {
echo "problema al connectar MySQL: " . $mysqli->connect_error;
}
$porciones = explode(" ", $_POST['grafico']);
$sentencia = $mysqli->prepare("SELECT N.NOTA,\n AL.NOM_ALUMNE,\n AL.COGNOM1_ALUMNE,\n AL.COGNOM2_ALUMNE\n FROM NOTA N\n INNER JOIN ALUMNE AL\n ON N.ALUMNE_ID = AL.ID_ALUMNE\n INNER JOIN CURS C\n ON C.ID_CURS = N.CURS_ID\n INNER JOIN ASSIGNATURA ASS\n\t ON ASS.CURS_ID = N.CURS_ID\n WHERE C.NOM_CURS = ?\n AND ASS.NOM_ASSIGNATURA = ?");
$sentencia->bind_param("ss", $curs, $assign);
$sentencia->execute();
$sentencia->bind_result($nota, $nom_alumne, $cognom1_alumne, $cognom2_alumne);
while ($sentencia->fetch()) {
$array_notes[$cognom1_alumne] = $nota;
}
declaraGlobals($array_notes);
}
