Suche zum Auslandspraktikum

 

 

Kontinent

"; $db = dbconnect(); $query2 = "SELECT distinct a.kid, a.kontinent FROM aesp_kontinent a, aesp_bewerbung b WHERE a.kid = b.kontinent ORDER BY kontinent ASC"; $result2 = $db->query ($query2) or die ("Cannot execute query"); echo "

Land

ab Jahrgang

"; $query2 = "SELECT distinct DATE_Format(zeitraum_von, '%Y') jahrgang FROM aesp_allgemein WHERE DATE_Format(zeitraum_von, '%Y') != '0000' ORDER BY jahrgang DESC "; $result2 = $db->query ($query2) or die ("Cannot execute query"); echo "

 

 

 




Es werden nur verfügbare Kontinente / Länder / Jahrgänge angezeigt!
"; break; case "auswertung": if(!isset($_POST['kontinent'])){ $kontinent=$_GET['kontinent']; }else{ $kontinent=$_POST['kontinent']; } if(!isset($_POST['land'])){ $land=$_GET['land']; }else{ $land=$_POST['land']; } if(!isset($_POST['jahrgang'])){ $jahrgang=$_GET['jahrgang']; }else{ $jahrgang=$_POST['jahrgang']; } if(isset($_GET["sort"])){ $sort = $_GET["sort"]; }else{ $sort = 'kontinent'; } if(isset($_GET["option"])){ $option = $_GET["option"]; }else{ $option = 'DESC'; } if($option == 'ASC'){ $option = 'DESC'; }else{ $option = 'ASC'; } ## Anzahl der Treffer ermitteln $db = dbconnect(); $result_anz = $db->query("SELECT count(*) anz_treffer FROM aesp_bewerbung a, aesp_allgemein b WHERE a.uid = b.uid AND a.kontinent LIKE '$kontinent' AND a.land LIKE '$land' AND DATE_Format(zeitraum_von, '%Y') >= '$jahrgang'"); $row_anz = $result_anz->fetch_array(); echo " Statistik

Suchergebnisse
Treffer: $row_anz[anz_treffer]
"; $db = dbconnect(); $query = "SELECT a.uid, a.kontinent, a.land, a.stadt, date_format(zeitraum_von, '%d.%m.%Y') datum, zeitraum_von FROM aesp_bewerbung a, aesp_allgemein b WHERE a.uid = b.uid AND a.kontinent LIKE '$kontinent' AND a.land LIKE '$land' AND DATE_Format(zeitraum_von, '%Y') >= '$jahrgang' ORDER BY $sort $option "; $result = $db->query($query) or die ("Cannot execute query"); while ($row = $result->fetch_array()){ $result_kont = $db->query("SELECT kontinent FROM aesp_kontinent WHERE kid='$row[kontinent]'"); $row_kont = $result_kont->fetch_array(); $result_land = $db->query("SELECT land FROM aesp_land WHERE lid='$row[land]'"); $row_land = $result_land->fetch_array(); echo " "; } echo"
"; if($sort == 'kontinent'){ echo "Kontinent"; }else{ echo "Kontinent"; } echo " "; if($sort == 'land'){ echo "Land"; }else{ echo "Land"; } echo " "; if($sort == 'stadt'){ echo "Stadt"; }else{ echo "Stadt"; } echo " "; if($sort == 'zeitraum_von'){ echo "Zeitraum ab"; }else{ echo "Zeitraum ab"; } echo " Link
$row_kont[kontinent] $row_land[land] $row[stadt] $row[datum] Ansehen

"; } ?>