if (!is_numeric($_GET["group"])) die("");
include("header.php");
if ($_GET["lang"] == "cz") {
?>
$result=mysqli_query($conection,"SELECT skupiny . *
FROM skupiny
WHERE id = ".mysqli_real_escape_string($conection, $_GET["group"])) or die(mysqli_error());
$row=mysqli_fetch_array($result);
$result2=mysqli_query($conection,"SELECT zamestnanec . * ,
titul_pred.titul_pred AS titul_pred_nazev,
titul_za.titul_za AS titul_za_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 )
WHERE zamestnanec.id = $row[vedouci] AND pozice = 2 ORDER BY prijmeni") or die(mysqli_error());
if (mysqli_num_rows($result2) == 0) {
}
else {?>
Vedoucí
Jméno |
Místnost |
Telefonní číslo |
Email |
";
}
?>
@$result2=mysqli_query($conection,"SELECT zamestnanec . * ,
titul_pred.titul_pred AS titul_pred_nazev,
titul_za.titul_za AS titul_za_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 )
WHERE skupina LIKE '%*".mysqli_real_escape_string($conection, $_GET["group"])."*%' AND (pozice = 3 OR pozice = 2) AND zamestnanec.id <> $row[vedouci] ORDER BY prijmeni") or die(mysqli_error());
if (mysqli_num_rows($result2) == 0) {
}
else {?>
Vědečtí pracovníci
Jméno |
Místnost |
Telefonní číslo |
Email |
";
}
?>
@$result2=mysqli_query($conection,"SELECT zamestnanec . * ,
titul_pred.titul_pred AS titul_pred_nazev,
titul_za.titul_za AS titul_za_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 )
WHERE skupina LIKE '%*".mysqli_real_escape_string($conection, $_GET["group"])."*%' AND pozice = 4 ORDER BY prijmeni") or die(mysqli_error());
if (mysqli_num_rows($result2) == 0) {
}
else {?>
Techničtí pracovníci
Jméno |
Místnost |
Telefonní číslo |
Email |
";
}
?>
@$result2=mysqli_query($conection,"SELECT zamestnanec . * ,
titul_pred.titul_pred AS titul_pred_nazev,
titul_za.titul_za AS titul_za_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 )
WHERE skupina LIKE '%*".mysqli_real_escape_string($conection, $_GET["group"])."*%' AND pozice = 1 ORDER BY prijmeni") or die(mysqli_error());
if (mysqli_num_rows($result2) == 0) {
}
else {?>
Doktorandi
Jméno |
Místnost |
Telefonní číslo |
Email |
";
}
?>
@$result2=mysqli_query($conection,"SELECT zamestnanec . * ,
titul_pred.titul_pred AS titul_pred_nazev,
titul_za.titul_za AS titul_za_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 )
WHERE skupina LIKE '%*".mysqli_real_escape_string($conection, $_GET["group"])."*%' AND pozice = 5 ORDER BY prijmeni") or die(mysqli_error());
if (mysqli_num_rows($result2) == 0) {
}
else {?>
Diplomanti
Jméno |
Místnost |
Telefonní číslo |
Email |
";
}
?>
@$result2=mysqli_query($conection,"SELECT zamestnanec . * ,
titul_pred.titul_pred AS titul_pred_nazev,
titul_za.titul_za AS titul_za_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 )
WHERE skupina LIKE '%*".mysqli_real_escape_string($conection, $_GET["group"])."*%' AND (pozice = 19) AND zamestnanec.id <> $row[vedouci] ORDER BY prijmeni") or die(mysqli_error());
if (mysqli_num_rows($result2) == 0) {
}
else {?>
Studenti
Jméno |
Místnost |
Telefonní číslo |
Email |
";
}
?>
@$result2=mysqli_query($conection,"SELECT zamestnanec . * ,
titul_pred.titul_pred AS titul_pred_nazev,
titul_za.titul_za AS titul_za_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 )
WHERE skupina LIKE '%*".mysqli_real_escape_string($conection, $_GET["group"])."*%' AND (pozice = 25) AND zamestnanec.id <> $row[vedouci] ORDER BY prijmeni") or die(mysqli_error());
if (mysqli_num_rows($result2) == 0) {
}
else {?>
Spolupracovníci
Jméno |
Místnost |
Telefonní číslo |
Email |
";
}
?>
}
else {
?>
$result=mysqli_query($conection,"SELECT skupiny . *
FROM skupiny
WHERE id = ".mysqli_real_escape_string($conection, $_GET["group"])) or die(mysqli_error());
$row=mysqli_fetch_array($result);
@$result2=mysqli_query($conection,"SELECT zamestnanec . * ,
titul_pred.titul_pred AS titul_pred_nazev,
titul_za.titul_za AS titul_za_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 )
WHERE zamestnanec.id = $row[vedouci] AND pozice = 2 ORDER BY prijmeni") or die(mysqli_error());
if (mysqli_num_rows($result2) == 0) {
}
else {?>
Head
Name |
Room |
Phone number |
Email |
";
}
?>
@$result2=mysqli_query($conection,"SELECT zamestnanec . * ,
titul_pred.titul_pred AS titul_pred_nazev,
titul_za.titul_za AS titul_za_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 )
WHERE skupina LIKE '%*".mysqli_real_escape_string($conection, $_GET["group"])."*%' AND (pozice = 3 OR pozice = 2) AND zamestnanec.id <> $row[vedouci] ORDER BY prijmeni") or die(mysqli_error());
if (mysqli_num_rows($result2) == 0) {
}
else {?>
Scientific Staff
Name |
Room |
Phone number |
Email |
";
}
?>
@$result2=mysqli_query($conection,"SELECT zamestnanec . * ,
titul_pred.titul_pred AS titul_pred_nazev,
titul_za.titul_za AS titul_za_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 )
WHERE skupina LIKE '%*".mysqli_real_escape_string($conection, $_GET["group"])."*%' AND pozice = 4 ORDER BY prijmeni") or die(mysqli_error());
if (mysqli_num_rows($result2) == 0) {
}
else {?>
Technicians
Name |
Room |
Phone number |
Email |
";
}
?>
@$result2=mysqli_query($conection,"SELECT zamestnanec . * ,
titul_pred.titul_pred AS titul_pred_nazev,
titul_za.titul_za AS titul_za_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 )
WHERE skupina LIKE '%*".mysqli_real_escape_string($conection, $_GET["group"])."*%' AND pozice = 1 ORDER BY prijmeni") or die(mysqli_error());
if (mysqli_num_rows($result2) == 0) {
}
else {?>
PhD Students
Name |
Room |
Phone number |
Email |
";
}
?>
@$result2=mysqli_query($conection,"SELECT zamestnanec . * ,
titul_pred.titul_pred AS titul_pred_nazev,
titul_za.titul_za AS titul_za_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 )
WHERE skupina LIKE '%*".mysqli_real_escape_string($conection, $_GET["group"])."*%' AND pozice = 5 ORDER BY prijmeni") or die(mysqli_error());
if (mysqli_num_rows($result2) == 0) {
}
else {?>
Diploma Students
Name |
Room |
Phone number |
Email |
";
}
?>
@$result2=mysqli_query($conection,"SELECT zamestnanec . * ,
titul_pred.titul_pred AS titul_pred_nazev,
titul_za.titul_za AS titul_za_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 )
WHERE skupina LIKE '%*".mysqli_real_escape_string($conection, $_GET["group"])."*%' AND pozice = 19 ORDER BY prijmeni") or die(mysqli_error());
if (mysqli_num_rows($result2) == 0) {
}
else {?>
Students
Name |
Room |
Phone number |
Email |
";
}
?>
@$result2=mysqli_query($conection,"SELECT zamestnanec . * ,
titul_pred.titul_pred AS titul_pred_nazev,
titul_za.titul_za AS titul_za_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 )
WHERE skupina LIKE '%*".mysqli_real_escape_string($conection, $_GET["group"])."*%' AND pozice = 25 ORDER BY prijmeni") or die(mysqli_error());
if (mysqli_num_rows($result2) == 0) {
}
else {?>
Co-workers
Name |
Room |
Phone number |
Email |
";
}
?>
}
include("footer.php");
?>