prepare($sql_jobs); $stmt_jobs->bind_param('ii', $start, $perPage); $stmt_jobs->execute(); $result_jobs = $stmt_jobs->get_result(); // Calculate total number of jobs $sql_count = "SELECT COUNT(*) AS total FROM jobs"; $result_count = $conn->query($sql_count); $total_jobs = $result_count->fetch_assoc()['total']; $total_pages = ceil($total_jobs / $perPage); ?>
Job Listings | Work Global Canada Inc
Work Global Canada Inc.

Welcome Candidates

Review the Positions listed below from a wide range of industry sectors from Canadian Employers. Applying to a position requires you to log in or register a profile.

12

Job Listings

num_rows > 0) { // Fetch all job details into an array $jobs = []; while ($row_jobs = $result_jobs->fetch_assoc()) { $jobs[] = $row_jobs; } // Shuffle the array to scatter the job listings shuffle($jobs); // Loop through the shuffled jobs and display them in table rows foreach ($jobs as $row_jobs) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // Construct the URL with the job's ID as a query parameter echo ""; echo ""; // Increment the counter $counter++; } } else { echo ""; } ?>
ID Post Title NOC Location Post Date View
" . $counter . "" . htmlspecialchars($row_jobs['job_title']) . "" . htmlspecialchars($row_jobs['noc_code']) . "" . htmlspecialchars($row_jobs['location']) . "" . htmlspecialchars($row_jobs['post_date']) . "Apply
No jobs found