<?php
 include "conecta_mysql.inc";
  echo "<form action=\"bancodado.php\"  method=\"post\"><br>";
  echo "<b> Codigo:</b> <input type=\"text\" name=\"codigo\" size=\"5\"><br>";
  //echo "<b> Periodo:</b> <input type=\"text\" name=\"periodo\" size=\"6\"><br>";
  echo  "<input type=\"hidden\" name=\"operacao\" value=\"incluir\"><br>";
  echo  "<input type=\"submit\" value=\"enviar\"><br>";
  $operacao=$_POST["operacao"];
  $codigo=$_POST["codigo"];
  //$periodo=$_POST["periodo"];
 // echo "$
  $result=mysql_query("select * from disciplinas where codigo=$codigo");
  $regist=mysql_fetch_array($result);

  $sqli="create table $regist[bancodado](nome char(80) not null, matricula int(8) not null primary key, Nota1 float (3,1), Nota2 float (3,1), Nota3 float (3,1), 
MediaP float (3,1), PFinal float (3,1), MediaF float (3,1), Falta int(2), NotaPF float (3,1), Situacao char(80) not null)";
  $resi=mysql_query($sqli,$conexao); 

 echo "Tabelas inseridas com sucesso!";

mysql_close($conexao);
?>