\n
$row[nom_carrec]
";
}
function persona($id)
{
include("conexion.php");
$genta="SELECT cognom, nom, despatx, extensio, email, emaildom FROM `personal` WHERE `id`=$id";
if ($gentb=send_sql($db,$genta)){
echo "";}
$nngent=mysql_fetch_array($gentb);
echo " $nngent[cognom], $nngent[nom].
Ext.: $nngent[extensio],
e-mail: $nngent[email] AT $nngent[emaildom]. \n
";
}
function persona_per_carrec($id)
{
include("conexion.php");
$genta="SELECT cognom, nom, despatx, extensio, email, emaildom FROM `personal` WHERE `carrec1`=$id or `carrec2`=$id or `carrec3`=$id";
if ($gentb=send_sql($db,$genta)){
echo "";}
$nngent=mysql_fetch_array($gentb);
echo " $nngent[cognom], $nngent[nom].
Ext.: $nngent[extensio],
e-mail: $nngent[email] AT $nngent[emaildom]. \n
";
}
function comissio($ncarrec)
{
include("conexion.php");
/* Comissions */
$carrec="select * from `carrec` where `actiu`=\"1\" and `com`=\"1\" and `id_carrec`=$ncarrec order by nom_carrec";
if ($res=send_sql($db,$carrec)) {
echo " "; }
$row=mysql_fetch_array($res);
// echo "\n
\n
\n
$row[nom_carrec]
";
//Titulars
$genta="SELECT cognom, nom, despatx, extensio, email, emaildom FROM `personal` WHERE (`comissio1` = $row[id_carrec] and `titular_com1`=0) or (`comissio2` = $row[id_carrec] and `titular_com2`=0) or (`comissio3` = $row[id_carrec] and `titular_com3`=0) order by cognom";
if ($gentb=send_sql($db,$genta)){
echo "";}
$ngenta=mysql_num_rows($gentb);
for ($k=0; $k < $ngenta ; $k++)
{
$nngent=mysql_fetch_array($gentb);
echo " $nngent[cognom], $nngent[nom].
Ext.: $nngent[extensio],
e-mail: $nngent[email] AT $nngent[emaildom]. \n
";
}
//Suplents
$ggenta="SELECT cognom, nom, despatx, extensio, email, emaildom FROM `personal` WHERE (`comissio1` = $row[id_carrec] and `titular_com1`=1) or (`comissio2` = $row[id_carrec] and `titular_com2`=1) or (`comissio3` = $row[id_carrec] and `titular_com3`=1) order by cognom";
if ($ggentb=send_sql($db,$ggenta)){
echo "";}
$nggenta=mysql_num_rows($ggentb);
for ($k=0; $k < $nggenta ; $k++)
{
$nnggent=mysql_fetch_array($ggentb);
echo " $nnggent[cognom], $nnggent[nom]
(suplent). Ext.: $nnggent[extensio],
e-mail: $nnggent[email] AT $nnggent[emaildom]. \n
";
}
//echo "
";
// Fi de comissions
}
// Volca les assignatures de tercer cicle del semestre $sem de l'area
// $area (es crida dins doctorat/plaestudis.php)
function kk($sem, $area)
{
include("conexion.php");
$sql = "select * from doctorat where `semestre`= $sem and `id_area`= $area and `actiu`=1";
if ($cursos=send_sql($db,$sql)) {
//echo "Consulta:
$sql"; }
echo " "; }
$cant=mysql_num_rows($cursos);
for ($i=1;$i<=$cant;$i++)
{
$row=mysql_fetch_array($cursos);
$sql="select cognom, nom from personal where `id`=$row[id_prof]";
if ($p1=send_sql($db,$sql)) {
echo " "; }
$pr1=mysql_fetch_array($p1);
//
$sql="select cognom, nom from personal where `id`=$row[id_prof2]";
if ($p2=send_sql($db,$sql)) {
echo " "; }
$pr2=mysql_fetch_array($p2);
//
$sql="select cognom, nom from personal where `id`=$row[id_prof3]";
if ($p3=send_sql($db,$sql)) {
echo " "; }
$pr3=mysql_fetch_array($p3);
//
$sql="select cognom, nom from personal where `id`=$row[id_prof4]";
if ($p4=send_sql($db,$sql)) {
echo " "; }
$pr4=mysql_fetch_array($p4);
//
$sql="select nom_area from area where `id_area`=$row[id_area]";
if ($ar=send_sql($db,$sql)) {
echo " "; }
$area=mysql_fetch_array($ar);
//echo "$pr1[cognom], $pr1[nom]
$pr2[cognom], $pr2[nom]
$pr2[cognom], $pr2[nom]
$pr2[cognom], $pr2[nom]
$area[nom_area]
";
//echo "$pr1[nom] $pr1[cognom]
$pr2[nom] $pr2[cognom]
$pr3[nom] $pr3[cognom]
$pr4[nom] $pr4[cognom]
$area[nom_area]
";
echo "
$row[nom_cat] ($row[credits] crèdits) \n
$pr1[nom] $pr1[cognom]\n $pr2[nom] $pr2[cognom]\n $pr3[nom] $pr3[cognom]\n $pr4[nom] $pr4[cognom]\n
";
echo "$row[desc_cat]\n ";
echo "
";
}
}
function kk_en($sem, $area)
{
include("conexion.php");
$sql = "select * from doctorat where `semestre`= $sem and `id_area`= $area and `actiu`=1";
if ($cursos=send_sql($db,$sql)) {
//echo "Consulta:
$sql"; }
echo " "; }
$cant=mysql_num_rows($cursos);
for ($i=1;$i<=$cant;$i++)
{
$row=mysql_fetch_array($cursos);
$sql="select cognom, nom from personal where `id`=$row[id_prof]";
if ($p1=send_sql($db,$sql)) {
echo " "; }
$pr1=mysql_fetch_array($p1);
//
$sql="select cognom, nom from personal where `id`=$row[id_prof2]";
if ($p2=send_sql($db,$sql)) {
echo " "; }
$pr2=mysql_fetch_array($p2);
//
$sql="select cognom, nom from personal where `id`=$row[id_prof3]";
if ($p3=send_sql($db,$sql)) {
echo " "; }
$pr3=mysql_fetch_array($p3);
//
$sql="select cognom, nom from personal where `id`=$row[id_prof4]";
if ($p4=send_sql($db,$sql)) {
echo " "; }
$pr4=mysql_fetch_array($p4);
//
$sql="select nom_area from area where `id_area`=$row[id_area]";
if ($ar=send_sql($db,$sql)) {
echo " "; }
$area=mysql_fetch_array($ar);
//echo "$pr1[cognom], $pr1[nom]
$pr2[cognom], $pr2[nom]
$pr2[cognom], $pr2[nom]
$pr2[cognom], $pr2[nom]
$area[nom_area]
";
//echo "$pr1[nom] $pr1[cognom]
$pr2[nom] $pr2[cognom]
$pr3[nom] $pr3[cognom]
$pr4[nom] $pr4[cognom]
$area[nom_area]
";
echo "
$row[nom_en] ($row[credits] crèdits) \n
$pr1[nom] $pr1[cognom]\n $pr2[nom] $pr2[cognom]\n $pr3[nom] $pr3[cognom]\n $pr4[nom] $pr4[cognom]\n
";
echo "$row[desc_en]\n ";
echo "
";
}
}
function kk_es($sem, $area)
{
include("conexion.php");
$sql = "select * from doctorat where `semestre`= $sem and `id_area`= $area and `actiu`=1";
if ($cursos=send_sql($db,$sql)) {
//echo "Consulta:
$sql"; }
echo " "; }
$cant=mysql_num_rows($cursos);
for ($i=1;$i<=$cant;$i++)
{
$row=mysql_fetch_array($cursos);
$sql="select cognom, nom from personal where `id`=$row[id_prof]";
if ($p1=send_sql($db,$sql)) {
echo " "; }
$pr1=mysql_fetch_array($p1);
//
$sql="select cognom, nom from personal where `id`=$row[id_prof2]";
if ($p2=send_sql($db,$sql)) {
echo " "; }
$pr2=mysql_fetch_array($p2);
//
$sql="select cognom, nom from personal where `id`=$row[id_prof3]";
if ($p3=send_sql($db,$sql)) {
echo " "; }
$pr3=mysql_fetch_array($p3);
//
$sql="select cognom, nom from personal where `id`=$row[id_prof4]";
if ($p4=send_sql($db,$sql)) {
echo " "; }
$pr4=mysql_fetch_array($p4);
//
$sql="select nom_area from area where `id_area`=$row[id_area]";
if ($ar=send_sql($db,$sql)) {
echo " "; }
$area=mysql_fetch_array($ar);
//echo "$pr1[cognom], $pr1[nom]
$pr2[cognom], $pr2[nom]
$pr2[cognom], $pr2[nom]
$pr2[cognom], $pr2[nom]
$area[nom_area]
";
//echo "$pr1[nom] $pr1[cognom]
$pr2[nom] $pr2[cognom]
$pr3[nom] $pr3[cognom]
$pr4[nom] $pr4[cognom]
$area[nom_area]
";
echo "
$row[nom_es] ($row[credits] crèdits) \n
$pr1[nom] $pr1[cognom]\n $pr2[nom] $pr2[cognom]\n $pr3[nom] $pr3[cognom]\n $pr4[nom] $pr4[cognom]\n
";
echo "$row[desc_es]\n ";
echo "
";
}
}
/* No funciona:
function elseminari($sem)
{
$persem="select nom_sem from seminari where id_sem=$sem";
$nomsem=send_sql(dpt,$persem);
$nomsemi=mysql_fetch_array($nomsem);
$nomseminari=$nomsemi[nom_sem];
return $nomseminari;
}*/
?>