"; echo "

"; echo "
"; $menu0 = ""; $menu1 = ""; $menu2 = ""; $menu3 = ""; $menu4 = ""; $menu5 = ""; if ($_GET[page] == '0') { echo $menu0; } elseif($_GET[page] == '1') { echo $menu1; } elseif($_GET[page] == '2') { echo $menu2; } elseif($_GET[page] == '3') { echo $menu3; } elseif($_GET[page] == '4') { echo $menu4; } elseif($_GET[page] == '5') { echo $menu5; } else { echo $menu0; } echo "
"; echo "
"; if (!isset($_GET[page])) $_GET[page] = "0"; switch($_GET[page]) { case "0": $eredmeny = mysql_query("SELECT * FROM eccemundus_docs where id=1"); $sor = mysql_fetch_array($eredmeny); echo $sor[szoveg]; break; case "1": if (!isset($_GET[sub])) $_GET[sub] = "0"; switch($_GET[sub]) { case "0": $eredmeny = mysql_query("SELECT * FROM eccemundus_docs where id=2"); $sor = mysql_fetch_array($eredmeny); echo $sor[szoveg]; break; case "$_GET[sub]": $eredmeny = mysql_query("SELECT * FROM eccemundus_otherdocs where id='".$_GET['sub']."'"); $sor = mysql_fetch_array($eredmeny); //echo "".$sor['title']."

"; //echo "".$sor['szoveg'].""; echo $sor[szoveg]; break; } break; case "2": $eredmeny = mysql_query("SELECT * FROM eccemundus_docs where id=3"); $sor = mysql_fetch_array($eredmeny); echo $sor[szoveg]; echo "
"; echo ""; echo ""; echo ""; echo "
"; echo "Field of study:
Country:
Name of organisation:
"; echo "
"; echo "
"; if($_POST[search]) { if($_POST[field_of_study]!= '') { $ker1 = "field_of_study = '$_POST[field_of_study]'"; } else { $ker1 = ""; } if($_POST[country] != '') { $ker2 = "country = '$_POST[country]'"; } else { $ker2 = ""; } if($_POST[partner] != '') { $ker3 = "partner like '%$_POST[partner]%'"; } else { $ker3 = ""; } if ($ker1 != '') { $ker1 = $ker1; } if (($ker1 == '') and ($ker2 != '')) { $ker2 = $ker2; } elseif (($ker1 != '') and ($ker2 != '')) { $ker2 = " AND ".$ker2.""; } else { $ker2 = ""; } if (($ker1 == '') and ($ker2 == '') and ($ker3 != '')) { $ker3 = $ker3; } elseif (($ker1 != '') and ($ker2 != '') and ($ker3 != '')) { $ker3 = " AND ".$ker3.""; } elseif (($ker1 != '') and ($ker2 == '') and ($ker3 != '')) { $ker3 = " AND ".$ker3.""; } elseif (($ker1 == '') and ($ker2 != '') and ($ker3 != '')) { $ker3 = " AND ".$ker3.""; } else { $ker3 = ""; } /* Ebben a két táblában kell keresgélni - em_partner_country - em_field */ $leker = mysql_query("SELECT em_field.*,em_partner_country.* from em_field,em_partner_country WHERE em_field.emu_id = em_partner_country.em_id and ".$ker1." ".$ker2." ".$ker3." order by em_partner_country.em_id,em_partner_country.partner"); $vane = mysql_num_rows($leker); if ($vane=='0') { echo "
Nincs találat a megadott feltételek alapján!
"; } else { echo " "; while($xsor=mysql_fetch_array($leker)) { echo ""; } echo "
ID Name of organisation
COORDINATOR - PARTNER
Country Field of study  
".$xsor[emu_id]."".(($xsor[type] == 'c') ? "":"")."".$xsor[partner]."".$xsor[country]."".$xsor[field_of_study]."
"; } } break; case "3": $eredmeny = mysql_query("SELECT * FROM eccemundus_docs where id=4"); $sor = mysql_fetch_array($eredmeny); echo $sor[szoveg]; echo "

"; if (!isset($_GET[sub])) $_GET[sub] = "1"; switch($_GET[sub]) { case "1": break; case "2": echo "
VIENNA 2012
"; echo "
    "; $handle2 = opendir(dirname(realpath(__FILE__)).'/pic/photo/viena_2012'); while($file2 = readdir($handle2)){ if($file2 !== '.' && $file2 !== '..'){ echo "
  • "; } } echo "
"; break; case "3": echo "
BRATISLAVA 2013
"; echo ""; break; case "4": echo "
BUDAPEST 2014
"; echo "
    "; $handle2 = opendir(dirname(realpath(__FILE__)).'/pic/photo/budapest_2014'); while($file2 = readdir($handle2)){ if($file2 !== '.' && $file2 !== '..'){ echo "
  • "; } } echo "
"; break; case "5": echo "
ALMATY 2014
"; echo "
    "; $handle2 = opendir(dirname(realpath(__FILE__)).'/pic/photo/almaty_2014'); while($file2 = readdir($handle2)){ if($file2 !== '.' && $file2 !== '..'){ echo "
  • "; } } echo "
"; break; } break; case "4": $eredmeny = mysql_query("SELECT * FROM eccemundus_docs where id=5"); $sor = mysql_fetch_array($eredmeny); echo $sor[szoveg]; break; case "5": $eredmeny = mysql_query("SELECT * FROM eccemundus_docs where id=6"); $sor = mysql_fetch_array($eredmeny); echo $sor[szoveg]; break; case "6": $leker = mysql_query("select * from em_data where id = '$_POST[idje]'"); $sor = mysql_fetch_array($leker); $xleker = mysql_query("select * from em_field where emu_id = '$_POST[idje]'"); $yleker = mysql_query("select * from em_language where em_id = '$_POST[idje]'"); $zleker = mysql_query("select * from em_partner_country where em_id = '$_POST[idje]' and type = 'c'"); $zsor = mysql_fetch_array($zleker); $wleker = mysql_query("select * from em_partner_country where em_id = '$_POST[idje]' and type = 'p' order by partner"); $menny = mysql_num_rows($wleker); echo ""; $i = 1; while($wsor = mysql_fetch_array($wleker)) { echo ""; echo ""; } echo "
Title".$sor[title]."
Acronym".$sor[acronym]."
Field of study"; while($xsor = mysql_fetch_array($xleker)) { echo "- ".$xsor[field_of_study]."
"; } echo "
Duration".$sor[duration]."
Language of instruction"; while($ysor = mysql_fetch_array($yleker)) { echo "- ".$ysor[language]."
"; } echo "
Coordinator".$zsor[partner]."Country".$zsor[country]."
Partner ".$i++."".$wsor[partner]."Country".$wsor[country]."
Course description".$sor[course_description]."
Detailed information".$sor[detailed_iformation]."
"; echo "
Back
"; break; } echo "
"; echo ""; ?>