DeutschEnglishEspañolItaliano

["Deutsch", "Englisch", "Spanisch", "Französisch", "Andere"], "en" => ["German", "English", "Spanish", "French", "Other"], "es" => ["Alemàn", "Inglés", "Español", "Francés", ""], "it" => "");?>set_cred($servername,$dbusername,$dbpassword);$db->db_connect();$db->select_db($dbname);$jobAdmin = new Jobs($db);$organizerAdmin = new OrganizerAdmin($db);$employerAdmin = new EmployerAdmin($db);// $lang = $_SESSION["lang"];// $query_language = array('%', $lang); /* UNTIL THERE ARE MORE JOBS IN ENGLISH THERE SHOULD BE NO DISTINCTION! */$query_language = array('%', $_SESSION['lang']);$jobCount = count($jobAdmin->getAllJobsAndCountersWithFilter($query_language, " jobs.id ", '', "", $jobAdmin::STATUS_ONLINE, $groupCopiedJobs = true ));// print_r($jobCount);// echo count($jobCount);$job_translations = getMainTranslations("jobs", $_SESSION["lang"]);$jobextra_translations = getMainTranslations("job", $_SESSION["lang"]);$jobsearch_translations = getMainTranslations("jobsearch", $_SESSION["lang"]);$odbTranslations = getMainTranslations('online-datenbank', strtoupper($_SESSION['lang']));//$resultSet = createCounter($db, "", "");// include_once("./includes/content/ODBCounts.php");function appendArrayToSearchString($array, $variableName){ $queryString = ""; if(isset($array) && is_array($array)){ foreach ($array as $item){ $queryString .= "&" . $variableName. "=$item"; } } return $queryString;}$pageNav = filter_input(INPUT_POST, 'page', FILTER_VALIDATE_INT) ?? filter_input(INPUT_GET, 'page', FILTER_VALIDATE_INT) ?? 1;$pageLength = filter_input(INPUT_POST, 'pageLength', FILTER_VALIDATE_INT) ?? 10;$queryStringHelper = '&fulltext=';$searchStringRepalced = '';//if (isset($_SESSION['in_jobsearch_flag']) && !$_SESSION['in_jobsearch_flag']) { // Flag that resets all the session variables that have been stored for the searchterm and filter //$_SESSION['in_jobsearch_flag'] = false; unset($_SESSION['jobsearchFulltext']); unset($_SESSION['jobsearchAreaFilter']); unset($_SESSION['jobsearchLandFilter']); unset($_SESSION['jobsearchPositionFilter']);//}$_SESSION['pagefrom'] = $page;if (isset($_GET['fulltext']) && $_GET['fulltext'] !== null) { $searchString = filter_input(INPUT_GET, 'fulltext'); // /[^A-Za-zäÄüÜöÖ\-\&ß0-9 ]/g,'') // $searchStringRepalced = preg_replace("/[^A-Za-zäÄüÜöÖ\-\&ß0-9\s+]/*",$searchString, ''); $searchStringRepalced = preg_replace("/[^A-Za-zäÄüÜöÖ\-&ß0-9\s+]/",'', $searchString); $queryStringHelper = "fulltext=" . $searchStringRepalced; $_SESSION['jobsearchFulltext'] = $searchStringRepalced;}else { if (isset($_SESSION['jobsearchFulltext']) && $_SESSION['jobsearchFulltext'] !== '') { $queryStringHelper = "fulltext=" . $_SESSION['jobsearchFulltext']; }}if (isset($_GET['areas']) && $_GET['areas'] !== "") { $areaIds = filter_input(INPUT_GET, 'areas', FILTER_VALIDATE_INT, FILTER_FORCE_ARRAY); $_SESSION['jobsearchAreaFilter'] = $areaIds;}else { if (isset($_SESSION['jobsearchAreaFilter']) && $_SESSION['jobsearchAreaFilter'] !== '') { $areaIds = $_SESSION['jobsearchAreaFilter']; }}if (isset($_GET['countries']) && $_GET['countries'] !== "") { $countryIds= filter_input(INPUT_GET, 'countries', FILTER_VALIDATE_INT, FILTER_FORCE_ARRAY); $_SESSION['jobsearchLandFilter'] = $countryIds;}else { if (isset($_SESSION['jobsearchLandFilter']) && $_SESSION['jobsearchLandFilter'] !== '') { $countryIds = $_SESSION['jobsearchLandFilter']; }}if (isset($_GET['positions']) && $_GET['positions'] !== "") { $positionIds = filter_input(INPUT_GET, 'positions', FILTER_VALIDATE_INT, FILTER_FORCE_ARRAY); $_SESSION['jobsearchPositionFilter'] = $positionIds;}else { if (isset($_SESSION['jobsearchPositionFilter']) && $_SESSION['jobsearchPositionFilter'] !== '') { $positionIds = $_SESSION['jobsearchPositionFilter']; }}function debugGETTERandSETTER($name, $get_key, $session_key){ echo "Printing GET Variables for " . $name . " ...
"; print_r($_GET[$get_key]); echo "
"; echo "Printing SESSION Variables for " . $name . " ...
"; print_r($_SESSION[$session_key]); echo "

";}// debugGETTERandSETTER("Areas" , 'areas' , 'jobsearchAreaFilter' );// debugGETTERandSETTER("Countries" , 'countries' , 'jobsearchLandFilter' );// debugGETTERandSETTER("Positions" , 'positions' , 'jobsearchPositionFilter' );$queryStringHelper .= appendArrayToSearchString($countryIds , "countries[]");$queryStringHelper .= appendArrayToSearchString($areaIds , "areas[]");$queryStringHelper .= appendArrayToSearchString($positionIds, "positions[]");// echo "Query String Helper: " . $queryStringHelper;// $tabCounterSet = createCounter($db, $searchString, "");$padding_string = "";if($_SESSION['lang']=='EN' || $_SESSION['lang']=='IT') { $padding_string = "style='padding: 10px 12px !important;'";}if($_SESSION['lang'] == 'ES') { $padding_string = "style='padding: 10px 9px !important;'";}$active_tab = 0;$jobdb_string = $job_translations['jobmenu_jobdatabase'];switch($page) { case 'job-datenbank': // printWelcomeMessage("JOB SUCHEN"); // include 'includes/content/components/JDB/php/jobHomepage.inc.php'; // echo "SEARCH PAGE"; $title_string = $job_translations['jobmenu_jobsearch']; $include_file = 'includes/content/components/JDB/php/jobHomepage.inc.php'; break; case 'jdbforeign': $active_tab = 1; // printWelcomeMessage("AUSLANDSJOBS"); // include 'includes/content/components/JDB/php/jdbforeign.inc.php'; $title_string = $job_translations['jobmenu_foreign']; $include_file = 'includes/content/components/JDB/php/jdbforeign.inc.php'; break; case 'jdbrecruitment': $active_tab = 2; $title_string = $job_translations['jobmenu_employersearch']; $include_file = 'includes/content/components/JDB/php/jdbrecruitment.inc.php'; break; case 'jdbserviceinfo': $active_tab = 3; $title_string = $job_translations['jobmenu_service']; $include_file = 'includes/content/components/JDB/php/jdbserviceinfo.inc.php'; break; default: // echo "DEFAULT PAGE"; printWelcomeMessage("JOB SUCHEN"); $title_string = $job_translations['jobmenu_jobsearch']; $active_tab = 0; $include_file = 'includes/content/components/JDB/php/jobHomepage.inc.php'; break;}?>