<?php

include "conecta_mysql.inc";
include "cabecalho.inc";

 $operacao=$_POST["operacao"];
 $nome=$_POST["nome"];
 $matricula=$_POST["matricula"];
 $turno=$_POST["turno"];
  $periodo=$_POST["periodo"];
 // echo "$
  $result=mysql_query("select * from disciplinas where turno='$turno' and periodo='$periodo'");
  $regist=mysql_fetch_array($result);

 $resultado=mysql_query("select *  from $regist[bancodado] where matricula=$matricula");
 
echo "<TABLE border=\"1\" cellpadding=\"5\" cellspacing=\"0\" align=\"center\">";
echo "<tr bgcolor=#bbff00>";
echo "<td><b>Nome</b></td>";
echo "<td><b>Matricula</b></td>";
echo "<td><b>Prova1</b></td>";
echo "<td><b>Prova2</b></td>";
echo "<td><b>Prova3</b></td>";
echo "<td><b>Media Parcial</b></td>";
echo "<td><b>Prova Final</b></td>";
echo "<td><b>Media Final</b></td>";
echo "<td><b>Nota para Final</b></td>";
echo "<td><b> Situação</b></td>";
echo "</tr>";
/*$linhas=mysql_num_rows($resultado);
echo "$linhas";*/


 $registro=mysql_fetch_array($resultado);
 echo "<tr>";
 echo "<td>";
 echo  "$registro[nome] <br>";
 echo  "</td>";
 echo "<td>";
 echo  "  $registro[matricula] <br>";
 echo "</td>";
 echo "<td>";
 echo  "  $registro[Nota1] <br>";
 echo "</td>";
 echo "<td>";
 echo  "  $registro[Nota2] <br>";
 echo "</td>";
 echo "<td>";
 echo " $registro[Nota3] <br>";
 echo "</td>";
 echo "<td>";
 echo " $registro[MediaP] <br>";
 echo "</td>";
 echo "<td>";
 echo "$registro[PFinal] <br>";
 echo "</td>";
 echo "<td>";
 echo "$registro[MediaF] <br>";
 echo "<td>";
 echo "$registro[NotaPF]<br>";
 echo "</td>";
 echo "<td>";
 echo "$registro[Situacao]<br>";
 echo "</td>";
 echo "</tr>"; 

 echo "</table><br>";
mysql_free_result($result);
mysql_free_result($resultado);
mysql_close($conexao);
echo "<p><a href=\"logout.php\">SAIR</a></p>";
?>