<?php
session_start();
if(!isset($_SESSION['emailadd'])){
   header("Location: index.php");
}

include 'connect.php';
include("header.php");
include("footer.php");
include("nav.php");
include 'function.php';

$emailadd = $_SESSION['emailadd'];

// Retrieve job data from the database
$query = "SELECT jobno, jobname FROM job";
$result = mysqli_query($conn, $query);

?>

<div class="container">

  <h2>Job List</h2>
  <main>
  <table>
    <thead>
      <tr>
        <th>Job No</th>
        <th>Job Name</th>
        <th>Action</th>
      </tr>
    </thead>
    <tbody>
      <?php
      while ($row = mysqli_fetch_assoc($result)) {
        echo "<tr>";
        echo "<td>{$row['jobno']}</td>";
        echo "<td>{$row['jobname']}</td>";
        echo "<td><a href='edit_job.php?jobno={$row['jobno']}'>Edit</a></td>";
        echo "</tr>";
      }
      ?>
    </tbody>
  </table>
</main>
</div>
