if (!is_numeric($_GET["id"])) die("");
if (!is_numeric($_GET["group"])) die("");
include("header.php");
if ($_GET["lang"] == "cz") {
?>
$id = $_GET["id"];
$result=mysqli_query($conection,"SELECT zamestnanec . * ,
titul_pred.titul_pred AS titul_pred_nazev,
titul_za.titul_za AS titul_za_nazev,
pozice.pozice AS pozice_nazev
FROM zamestnanec
LEFT JOIN titul_pred ON ( titul_pred.id = zamestnanec.titul_pred )
LEFT JOIN titul_za ON ( titul_za.id = zamestnanec.titul_za )
LEFT JOIN pozice ON ( pozice.id = zamestnanec.pozice )
WHERE zamestnanec.id = '$id'
") or die(mysqli_error());
$row=mysqli_fetch_array($result);
skupiny($row["skupina"]);
?>
";?>
Pozice:
if (count($skupina_nazev) > 1 ) echo "Skupiny:";
else echo "Skupina:";
$skupiny_print = "";
foreach ($skupina_nazev as $nazev) {
$skupiny_print = $skupiny_print." ".$nazev.",";
}
$skupiny_print = substr($skupiny_print, 0, -1);
echo $skupiny_print;
?>
Místnosti:
Telefonní čísla:
Mobil: ".$row["mobil"]."
";?>
E-mail: echo email_odkaz($row["id"]);?>
Reseacher ID: ".$row["res_id"]."
";?>
Vědecká činnost:
}
$result=mysqli_query($conection,"SELECT projekty . * ,
agentury.agentura AS agentura_nazev
FROM projekty
LEFT JOIN agentury ON ( agentury.id = projekty.agentura )
WHERE projekty.resitel = $id ORDER BY zacatek DESC") or die(mysqli_error());
if (mysqli_num_rows($result) != 0) {?>
Projekty
}
while ($row=mysqli_fetch_array($result))
{
?>
}?>
$result=mysqli_query($conection,"SELECT spoluprace.* FROM spoluprace
WHERE akad_prum = 1 AND id_zamestnance = $id ORDER BY nazev ASC") or die(mysqli_error());
if (mysqli_num_rows($result) != 0) {?>
Akademická spolupráce
}
while ($row=mysqli_fetch_array($result))
{
?>
partner:
}
$result=mysqli_query($conection,"SELECT spoluprace.* FROM spoluprace
WHERE akad_prum = 2 AND id_zamestnance = $id ORDER BY nazev ASC") or die(mysqli_error());
if (mysqli_num_rows($result) != 0) {?>
Průmyslová spolupráce
}
while ($row=mysqli_fetch_array($result))
{
?>
partner:
}?>
$rok = 0;
$i=0;
$result2=mysqli_query($conection,"SELECT * FROM publikace WHERE autor1 = $id OR autor2 = $id OR autor3 = $id OR autor4 = $id OR autor5 = $id OR autor6 = $id OR autor7 = $id OR autor8 = $id ORDER BY rok DESC, autor1 ASC") or die(mysqli_error());
if (mysqli_num_rows($result2) != 0) {?>
Publikace:
}
while ($row2=mysqli_fetch_array($result2))
{
if ($rok != $row2["rok"]) {
?>
$rok = $row2["rok"];
$i++;
}
?>
}?>
}
else {
?>
$id = $_GET["id"];
$result=mysqli_query($conection,"SELECT zamestnanec . * ,
titul_pred.titul_pred AS titul_pred_nazev,
titul_za.titul_za AS titul_za_nazev,
pozice.pozice_en AS pozice_nazev
FROM zamestnanec
LEFT JOIN titul_pred ON ( titul_pred.id = zamestnanec.titul_pred )
LEFT JOIN titul_za ON ( titul_za.id = zamestnanec.titul_za )
LEFT JOIN pozice ON ( pozice.id = zamestnanec.pozice )
WHERE zamestnanec.id = '$id'
") or die(mysqli_error());
$row=mysqli_fetch_array($result);
skupiny($row["skupina"]);
?>
";?>
Position:
if (count($skupina_nazev_en) > 1 ) echo "Groups:";
else echo "Group:";
$skupiny_print = "";
foreach ($skupina_nazev_en as $nazev) {
$skupiny_print = $skupiny_print." ".$nazev.",";
}
$skupiny_print = substr($skupiny_print, 0, -1);
echo $skupiny_print;
?>
Rooms:
Phone numbers:
Mobile: ".$row["mobil"]."
";?>
E-mail: echo email_odkaz($row["id"]);?>
Reseacher ID: ".$row["res_id"]."
";?>
Scientific interest:
}
$result=mysqli_query($conection,"SELECT projekty . * ,
agentury.agentura AS agentura_nazev
FROM projekty
LEFT JOIN agentury ON ( agentury.id = projekty.agentura )
WHERE projekty.resitel = $id ORDER BY zacatek DESC") or die(mysqli_error());
if (mysqli_num_rows($result) != 0) {?>
Projects
}
while ($row=mysqli_fetch_array($result))
{
?>
}?>
$result2=mysqli_query($conection,"SELECT * FROM publikace WHERE autor1 = $id OR autor2 = $id OR autor3 = $id OR autor4 = $id OR autor5 = $id OR autor6 = $id OR autor7 = $id OR autor8 = $id ORDER BY rok DESC, autor1 ASC") or die(mysqli_error());
if (mysqli_num_rows($result2) != 0) {?>
Publications:
}
while ($row2=mysqli_fetch_array($result2))
{
if ($rok != $row2["rok"]) {
?>
$rok = $row2["rok"];
$i++;
}
?>
}?>
}
include("footer.php");
?>