prepare("SELECT * FROM jobs WHERE id = ? AND employer_id = ?"); $stmt->execute([$editId, $userId]); $job = $stmt->fetch(); if (!$job) { flash('error', 'Job not found.'); header('Location: manage-jobs.php'); exit; } $pageTitle = 'Edit Job'; } if ($_SERVER['REQUEST_METHOD'] === 'POST') { $title = trim($_POST['title'] ?? ''); $description = trim($_POST['description'] ?? ''); $requirements = trim($_POST['requirements'] ?? ''); $benefits = trim($_POST['benefits'] ?? ''); $categoryId = intval($_POST['category_id'] ?? 0); $locationId = intval($_POST['location_id'] ?? 0); $jobType = $_POST['job_type'] ?? 'full-time'; $experienceLevel = $_POST['experience_level'] ?? 'entry'; $educationLevel = $_POST['education_level'] ?? 'any'; $competitiveSalary = isset($_POST['competitive_salary']); $salaryMin = $competitiveSalary ? null : (intval($_POST['salary_min'] ?? 0) ?: null); $salaryMax = $competitiveSalary ? null : (intval($_POST['salary_max'] ?? 0) ?: null); $salaryCurrency = $_POST['salary_currency'] ?? 'USD'; $salaryType = $_POST['salary_type'] ?? 'yearly'; $deadline = $_POST['application_deadline'] ?? null; $isOverseas = isset($_POST['is_overseas']) ? 1 : 0; if (empty($title) || empty($description) || empty($categoryId) || empty($locationId)) { $error = 'Please fill in all required fields.'; } else { try { if ($editId && $job) { $stmt = $pdo->prepare(" UPDATE jobs SET title = ?, description = ?, requirements = ?, benefits = ?, category_id = ?, location_id = ?, job_type = ?, experience_level = ?, salary_min = ?, salary_max = ?, salary_currency = ?, salary_period = ?, application_deadline = ?, is_overseas = ?, education_level = ?, status = 'pending', updated_at = CURRENT_TIMESTAMP WHERE id = ? AND employer_id = ? "); $stmt->execute([$title, $description, $requirements, $benefits, $categoryId, $locationId, $jobType, $experienceLevel, $salaryMin, $salaryMax, $salaryCurrency, $salaryType, $deadline ?: null, $isOverseas, $educationLevel, $editId, $userId]); flash('success', 'Job updated successfully! It will be reviewed by admin.'); header('Location: manage-jobs.php'); exit; } else { $stmt = $pdo->prepare(" INSERT INTO jobs (employer_id, title, slug, description, requirements, benefits, category_id, location_id, job_type, experience_level, salary_min, salary_max, salary_currency, salary_period, application_deadline, is_overseas, education_level, status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'pending') "); $slug = generateSlug($title) . '-' . time(); $stmt->execute([$userId, $title, $slug, $description, $requirements, $benefits, $categoryId, $locationId, $jobType, $experienceLevel, $salaryMin, $salaryMax, $salaryCurrency, $salaryType, $deadline ?: null, $isOverseas, $educationLevel]); flash('success', 'Job posted successfully! It will be reviewed by admin before going live.'); header('Location: manage-jobs.php'); exit; } } catch (PDOException $e) { $error = 'Failed to save job: ' . $e->getMessage(); } } } require_once '../includes/dashboard-header.php'; ?>

Walk-in Interview

Check this if candidates can walk-in for interviews without prior appointment. This will add a prominent badge to attract more applicants.

🌍 International Position

Check this if the job is based outside your home country (e.g., UAE, Saudi Arabia, Qatar, Singapore, etc.). This will highlight your job in the Overseas Jobs section.

Salary Information

Cancel