query($sql); if($url_exists->num_rows == 0) {//if the $url_career_field (career_field) selected is wrong then getback to the archive. http_response_code(404); include("404.php"); die(); } } if (isset($url_job_ID) and $url_job_ID != null) { $encrypted_url = $url_job_ID;//convert the job_ID to number $decrypted_url = base64_decode(str_pad(strtr($encrypted_url, '-_', '+/'), strlen($encrypted_url) % 4, '=', STR_PAD_RIGHT)); $sql = "select job_ID from job_post where job_ID = '" . $decrypted_url . "' and career_field = '" . convert($url_career_field, "url") . "'"; $url_exists = $conn->query($sql); if($url_exists->num_rows == 0) {//if the job_ID doesn't exist or doesn't matches the career_field selected then, return 404 and send 404.php http_response_code(404); include("404.php"); die(); } else {//in case job_ID exists and matches the career_feild if (isset($amp) and $amp == "amp") { include ("job.amp.php");//in case the required is the AMP version - $decrypted_url will be used to sen the ID to job.php. die(); } else { include ("job.php");//In case the required is standard NON AMP version - $decrypted_url will be used to sen the ID to job.php. die(); } } } ?> <?php echo $title; ?> jobs on Dream Career Builder." /> job posts on dreamcareerbuilder.com - the Free Job Network in Southeast Asia." /> jobs on Dream Career Builder." /> job posts on dreamcareerbuilder.com - the Free Job Network in Southeast Asia." />
<?php echo $background_alt; ?>

Archived Jobs

  • Home
    • Archive"; }elseif (isset($url_career_field) and $url_career_field != null) { //echo "
  • " . $url_career_field . "
    • "; echo "
  • Archive
    • "; echo "
  • " . convert($url_career_field, "url") . " (Archived)
    • "; } ?>
query($sql); while ($career_field = mysqli_fetch_assoc($result_career_field)){ $clean_url = convert($career_field['career_field'], "text"); echo "
" . $career_field['career_field'] . ""; $sql = "select ROUND(AVG(min_salary + max_salary)/50) * 50 as aveg from job_post where status = 'Expired' and reviewed = true and (language is null or language = 'en')and career_field = '" . $career_field['career_field'] . "'"; $aver_per_career_field = $conn->query($sql); while ($average_salary = mysqli_fetch_assoc($aver_per_career_field)){ echo "
Av. monthly salary: " . $average_salary['aveg'] . "$
"; } echo "
Numer of jobs: " . $career_field['times_repeated'] . "
"; $sql = "select country ,count(*) from job_post where status = 'Expired' and reviewed = true and (language is null or language = 'en')and career_field = '" . $career_field['career_field'] . "' group by country order by country ASC"; $countries_per_career_field = $conn->query($sql); while ($job_per_country = mysqli_fetch_assoc($countries_per_career_field)){ echo "
" . $job_per_country['country'] . ": " . $job_per_country['count(*)'] . "
"; } /* $sql = "select job_ID, job_title from job_post where status = 'Active' and reviewed = true and (language is null or language = 'en')and career_field = '" . $career_field['career_field'] . "' order by job_ID DESC"; $job_title_per_career_field = $conn->query($sql); */ /*while ($job_title = mysqli_fetch_assoc($job_title_per_career_field)){ $pre_encrypt = $job_title["job_ID"]; $encrypted_job_id = rtrim(strtr(base64_encode($pre_encrypt), '+/', '-_'), '='); //encode the ID base64 and remove html charcters echo "
" . $job_title['job_title'] . "
"; } */ echo "
"; } } else { $sql = "select job_title, job_ID, company_name, max_salary, min_salary, country from job_post where status = 'Expired' and reviewed = true and (language is null or language = 'en') and career_field ='" . convert($url_career_field, "url") . "'";//$url_career_field was prepared at the begginging of the code. $result_career_field = $conn->query($sql); while ($jobs = mysqli_fetch_assoc($result_career_field)){ $pre_encrypt = $jobs["job_ID"]; $encrypted_job_id = rtrim(strtr(base64_encode($pre_encrypt), '+/', '-_'), '='); //encode the ID base64 and remove html charcters //prepare the job_title to be suitable for browser address bar. $url_job_title = $jobs["job_title"]; echo "
" . $jobs['job_title'] . ""; $max_salary = $jobs['max_salary'];$min_salary = $jobs['min_salary']; $binder = " - "; if ($max_salary == "0"){$max_salary = "Or Above";$binder = " ";} if ($min_salary == "0"){$min_salary = "Up to";$binder = " ";} echo "
" . $jobs['country'] . "
"; echo "
At " . $jobs['company_name'] . "
"; echo "
Monthly Salart: " . $min_salary . $binder . $max_salary . "$
"; echo "
"; } } ?>