<?php

$servername = "localhost";
$username = "root";
$password = "root";
$database = "lamp2proj1";

    // Create connection
$connection = new mysqli($servername, $username, $password, $database);

if ($connection->connect_error)
{
  die("Connection failed: " . $connection->connect_error);
}

$tasks = $connection->query('SELECT * FROM task ');
?>
<table style='border:1px solid black;' border='1'>
  <tr>
    <th></th>
    <th>Description</th>
    <th>Priority</th>
    <th>Date Created</th>
    <th>Date Completed</th>
  </tr>
  <?php if($tasks)
  {
    while ($row = $tasks->fetch_array())
    {
      echo
      "<tr>
      <td><input class='taskrow' checked type='checkbox'/ value=".$row['id']."></td>
      <td>".$row['description']."</td>
      <td>".$row['priority']."</td>
      <td>".$row['dateCreated']."</td>
      <td>".$row['dateCompleted']."</td>
      <td>
        <a data-id=".$row['id']." href=\"#\">Delete</a>
      </td>
    </tr>";
  }
}
?>
</table>
<button id="deleteRows">Delete</button>

<script src="jquery.min.js"></script>
<script>

  $('[data-id]').each(function() {
    $(this).on('click', function(event) {
      event.preventDefault();
      deleteRow([$(this).data('id')]);
    });
  });

  $('#deleteRows').on('click', function(event) {
    var obj = [];
    $('.taskrow:checked').each(function() {
      obj.push(parseInt($(this).val(), 10));
    });
    deleteRow(obj);
  });

  function deleteRow(ids) {
    $.ajax({ url: 'Proj1Structure.php',
      data: {
        action: 'delete',
        data: JSON.stringify(ids)
      },
      type: 'post',
      success: function(output) {
        console.log(output);
        location.reload();
      }
    });
  }

</script>