bueno ocupo html, php y mysql,
este es el codigo del "informe tipo" donde despliego los datos del alumno, (una vez seleccionado en la tabla)
Código PHP:
<?php
$hostname_connBD = "localhost";
$database_connBD = "colegio";
$username_connBD = "cahuala5";
$password_connBD = "nmaster987";
$connBD = mysql_pconnect($hostname_connBD, $username_connBD, $password_connBD) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_select_db($database_connBD, $connBD);
$query_not = "SELECT * FROM colegio.1 where al_id ='$id_del_alumno' order by no_id";
$pl = "SELECT AVG(lenguaje_y_comunicacion_1_4) FROM colegio.1 where al_id ='$id_del_alumno'";
$pi = "SELECT AVG(ingles_1_4) FROM colegio.1 where al_id ='$id_del_alumno'";
$pma = "SELECT AVG(matematica_1_4) FROM colegio.1 where al_id ='$id_del_alumno'";
$pcm = "SELECT AVG(comprencion_del_medio_1_4) FROM colegio.1 where al_id ='$id_del_alumno'";
$pt = "SELECT AVG(tecnologia_1_4) FROM colegio.1 where al_id ='$id_del_alumno'";
$pa = "SELECT AVG(arte_1_4) FROM colegio.1 where al_id ='$id_del_alumno'";
$pm = "SELECT AVG(musica_1_4) FROM colegio.1 where al_id ='$id_del_alumno'";
$ped = "SELECT AVG(ed_fisica_1_4) FROM colegio.1 where al_id ='$id_del_alumno'";
$pf = "SELECT AVG(filosofia_1_4) FROM colegio.1 where al_id ='$id_del_alumno'";
$reg = mysql_query($query_not, $connBD) or die(mysql_error());
$proml = mysql_query($pl, $connBD) or die(mysql_error());
$promi = mysql_query($pi, $connBD) or die(mysql_error());
$promma = mysql_query($pma, $connBD) or die(mysql_error());
$promcm = mysql_query($pcm, $connBD) or die(mysql_error());
$promt = mysql_query($pt, $connBD) or die(mysql_error());
$proma = mysql_query($pa, $connBD) or die(mysql_error());
$promm = mysql_query($pm, $connBD) or die(mysql_error());
$promed = mysql_query($ped, $connBD) or die(mysql_error());
$promf = mysql_query($pf, $connBD) or die(mysql_error());
$rsl = mysql_fetch_array($proml, MYSQL_NUM);
$rsi = mysql_fetch_array($promi, MYSQL_NUM);
$rsma = mysql_fetch_array($promma, MYSQL_NUM);
$rscm = mysql_fetch_array($promcm, MYSQL_NUM);
$rst = mysql_fetch_array($promt, MYSQL_NUM);
$rsa = mysql_fetch_array($proma, MYSQL_NUM);
$rsm = mysql_fetch_array($promm, MYSQL_NUM);
$rsed = mysql_fetch_array($promed, MYSQL_NUM);
$rsf= mysql_fetch_array($promf, MYSQL_NUM);
?>
<?php
while ($row_log_h = mysql_fetch_assoc($reg)) {
@$lenguaje.="<td bordercolor=\"#000000\"><div align=\"center\"><span class=\"Estilo2\">".$row_log_h['lenguaje_y_comunicacion_1_4']."</span></div></td>";
@$ingles.="<td bordercolor=\"#000000\"><div align=\"center\"><span class=\"Estilo2\">".$row_log_h['ingles_1_4']."</span></div></td>";
@$matematicas.="<td bordercolor=\"#000000\"><div align=\"center\"><span class=\"Estilo2\">".$row_log_h['matematica_1_4']."</span></div></td>";
@$comprencionm.="<td bordercolor=\"#000000\"><div align=\"center\"><span class=\"Estilo2\">".$row_log_h['comprencion_del_medio_1_4']."</span></div></td>";
@$tecnologia.="<td bordercolor=\"#000000\"><div align=\"center\"><span class=\"Estilo2\">".$row_log_h['tecnologia_1_4']."</span></div></td>";
@$arte.="<td bordercolor=\"#000000\"><div align=\"center\"><span class=\"Estilo2\">".$row_log_h['arte_1_4']."</span></div></td>";
@$musica.="<td bordercolor=\"#000000\"><div align=\"center\"><span class=\"Estilo2\">".$row_log_h['musica_1_4']."</span></div></td>";
@$edfisica.="<td bordercolor=\"#000000\"><div align=\"center\"><span class=\"Estilo2\">".$row_log_h['ed_fisica_1_4']."</span></div></td>";
@$filosofia.="<td bordercolor=\"#000000\"><div align=\"center\"><span class=\"Estilo2\">".$row_log_h['filosofia_1_4']."</span></div></td>";
}
?>
<html>
<head>
<style type="text/css">
<!--
.Estilo2 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}
.Estilo8 {font-size: 12px; font-weight: bold; font-family: Arial, Helvetica, sans-serif; }
.Estilo10 {font-size: 12px; font-family: Arial, Helvetica, sans-serif; }
.Estilo11 {font-size: 12px; font-weight: bold; font-family: Arial, Helvetica, sans-serif; color: #999999; }
.Estilo13 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold; }
-->
</style>
</head>
<body>
<div align="center">
<p>
<style type="text/css">
<!--
.Estilo3 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; }
.Estilo4 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 18px;
}
-->
</style>
</p>
<table width="492" border="0" align="left">
<tr>
<td> </td>
<td width="10"> </td>
<td width="344"> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td width="124"><span class="Estilo8">INSTITUCIÓN</span></td>
<td class="Estilo8">:</td>
<td><span class="Estilo10">Colegio Cahuala Insular</span> </td>
</tr>
<tr>
<td><strong class="Estilo8">AÑO ESCOLAR </strong></td>
<td class="Estilo8">:</td>
<td><span class="Estilo10">2005</span> </td>
</tr>
<tr>
<td><strong class="Estilo8">CURSO</strong></td>
<td class="Estilo8">:</td>
<td><?
if ($id_del_curso == "1") {
echo "<div class=\"Estilo10\">1 - A Enseñanza Básica</div>";
} elseif ($id_del_curso == "2") {
echo "<div class=\"Estilo10\">2 - A Enseñanza Básica</div>";
} elseif ($id_del_curso == "3") {
echo "<div class=\"Estilo10\">3 - A Enseñanza Básica</div>";
} elseif ($id_del_curso == "4") {
echo "<div class=\"Estilo10\">4 - A Enseñanza Básica</div>";
} else {
echo "<div class=\"Estilo10\">Desconocido</div>";
}
?></td>
</tr>
<tr>
<td><strong class="Estilo8">ALUMNO</strong></td>
<td class="Estilo8">:</td>
<td><span class="Estilo10"><? echo"$nombre_alumno";?></span></td>
</tr>
<tr>
<td><strong class="Estilo8">PROFESOR JEFE </strong></td>
<td class="Estilo8">:</td>
<td><?
if ($id_del_curso == "1") {
echo "<div class=\"Estilo10\">Claudia Mancilla Díaz</div>";
} elseif ($id_del_curso == "2") {
echo "<div class=\"Estilo10\">Claudia Mancilla Díaz</div>";
} elseif ($id_del_curso == "3") {
echo "<div class=\"Estilo10\">Florencia Campos</div>";
} elseif ($id_del_curso == "4") {
echo "<div class=\"Estilo10\">Claudia Mancilla Díaz</div>";
} else {
echo "<div class=\"Estilo10\">Desconocido</div>";
}
?></td>
</tr>
</table>
<p><img src="img/header.JPG" width="4" height="133"> </p>
<p> </p>
<p> </p>
<table width="200" border="0">
<tr>
<td><div align="center" class="Estilo11">INFORME DE NOTAS</div></td>
</tr>
<tr>
<td><div align="center" class="Estilo8">PRIMER SEMESTRE DEL 2005</div></td>
</tr>
<tr>
<td> </td>
</tr>
</table>
</div>