= ?"; $params[] = $salaryMin; } if (!empty($salaryRange)) { switch ($salaryRange) { case 'under30': $where[] = "(j.salary_max < 30000 OR (j.salary_max IS NULL AND j.salary_min < 30000))"; break; case '30-50': $where[] = "((j.salary_min >= 30000 AND j.salary_min < 50000) OR (j.salary_max >= 30000 AND j.salary_max < 50000))"; break; case '50-80': $where[] = "((j.salary_min >= 50000 AND j.salary_min < 80000) OR (j.salary_max >= 50000 AND j.salary_max < 80000))"; break; case '80-120': $where[] = "((j.salary_min >= 80000 AND j.salary_min < 120000) OR (j.salary_max >= 80000 AND j.salary_max < 120000))"; break; case '120plus': $where[] = "(j.salary_min >= 120000 OR j.salary_max >= 120000)"; break; } } if (!empty($sector)) { $where[] = "j.job_sector = ?"; $params[] = $sector; } if (!empty($educationLevel)) { $where[] = "j.education_level = ?"; $params[] = $educationLevel; } $whereClause = implode(' AND ', $where); $orderBy = match ($sort) { 'salary_high' => 'CASE WHEN j.salary_max IS NULL THEN 1 ELSE 0 END, j.salary_max DESC', 'salary_low' => 'CASE WHEN j.salary_min IS NULL THEN 1 ELSE 0 END, j.salary_min ASC', 'oldest' => 'j.created_at ASC', default => 'j.is_featured DESC, j.created_at DESC' }; /* |-------------------------------------------------------------------------- | Count |-------------------------------------------------------------------------- */ $countSql = " SELECT COUNT(*) FROM jobs j LEFT JOIN users u ON j.employer_id = u.id WHERE $whereClause "; $countStmt = $pdo->prepare($countSql); $countStmt->execute($params); $totalJobs = (int)$countStmt->fetchColumn(); $totalPages = max(1, (int)ceil($totalJobs / $perPage)); /* |-------------------------------------------------------------------------- | Main query |-------------------------------------------------------------------------- |-------------------------------------------------------------------------- */ $listSql = " SELECT j.*, c.name AS category_name, COALESCE(l.name, 'Remote') AS location_name, COALESCE(u.company_name, 'Imported Company') AS company_name, COALESCE(u.company_logo, u.profile_image) AS company_logo, u.profile_image, ( SELECT COUNT(*) FROM applications a WHERE a.job_id = j.id ) AS application_count FROM jobs j LEFT JOIN categories c ON j.category_id = c.id LEFT JOIN locations l ON j.location_id = l.id LEFT JOIN users u ON j.employer_id = u.id WHERE $whereClause ORDER BY $orderBy LIMIT $perPage OFFSET $offset "; $stmt = $pdo->prepare($listSql); $stmt->execute($params); $jobs = $stmt->fetchAll(PDO::FETCH_ASSOC); $categories = getCategories($pdo); $countries = getCountries($pdo); require_once 'includes/header.php'; ?>

Find Your Perfect Job

jobs available

Showing 0 ? min(($offset + 1), $totalJobs) : 0; ?> - of jobs

No jobs found

Try adjusting your search criteria or browse all available jobs.

View All Jobs

...

'exp-badge-fresh', 'entry' => 'exp-badge-entry', 'mid' => 'exp-badge-mid', 'senior' => 'exp-badge-senior', 'executive' => 'exp-badge-executive', default => 'exp-badge-entry' }; $expLabel = match($expLevel) { 'fresh' => 'Fresh Graduate', 'entry' => '1-3 Years', 'mid' => '3-5 Years', 'senior' => '5+ Years', 'executive' => 'Executive', default => ucfirst($expLevel) }; ?> 'High School', 'diploma' => 'Diploma', 'bachelors' => 'Bachelor\'s', 'masters' => 'Master\'s', 'phd' => 'PhD', default => ucfirst($eduLevel) }; ?>
Expired Apply by:
View Details Apply Now Apply Now
1): ?>