Cacher is the code snippet organizer for pro developers

<?php
  $query = "SELECT * FROM applicants ORDER BY submitted DESC";
  $select_applicants = mysqli_query($connection, $query);
  while($row = mysqli_fetch_assoc($select_applicants)) {
      $applicant_id = $row['id'];
      $applicant_first_name = $row['first_name'];
      $applicant_last_name = $row['last_name'];
      $applicant_email = $row['email'];
      $applicant_phone = $row['phone'];
      $applicant_portfolio = $row['portfolio'];
      $applicant_message = $row['message'];
      $applicant_resume = $row['resume'];
      $applicant_date = $row['submitted'];

      $applicant_resume_folder = substr($applicant_resume, 0, strrpos($applicant_resume, '_'));
      $applicant_resume = str_replace('_', '-', $applicant_resume);
?>

  <tr>
    <td> <?php echo $applicant_first_name . " " . $applicant_last_name; ?> </td>
    <td> <a href="/cdn-cgi/l/email-protection#95a9aae5fde5b5f0f6fdfab5b1f4e5e5f9fcf6f4fbe1caf0f8f4fcf9aeb5aaab"><?php echo $applicant_email; ?></a> </td>
    <td> <?php echo $applicant_phone; ?> </td>
    <td> <a href="http://<?php echo $applicant_portfolio; ?>" target="_blank"><?php echo $applicant_portfolio; ?></a> </td>
    <td> <?php echo $applicant_message ?> </td>
    <td> <a class="btn btn-primary" href="../includes/resume-uploads/<?php echo $applicant_resume_folder . "/" . $applicant_resume; ?>" target="_blank">View</a> </td>
    <td> <?php echo $applicant_date; ?> </td>
  </tr>

  <?php } ?>