<?php
include_once 'db.php';
$page = $_GET['pg'];
?>
<div class="row">
  <div class="col-sm">
  <div class="row">
    <div class="col-sm-8">
  New posts
  <button class="btn btn-primary btn-outline-primary" id="reloadmsg" value="Reload" class="">Reload</button>
  </div>
  <div class="col-sm-4">
</div>
</div>
    <hr class="my-4">
    <div id="msgs">
<script>
$("#reloadmsg").click(function () {
  $("#msgs").load(location.href+" #msgs>*","");
});
</script>
<script>
(function() {
  'use strict';
  window.addEventListener('load', function() {
    var forms = document.getElementsByClassName('needs-validation');
    var validation = Array.prototype.filter.call(forms, function(form) {
      form.addEventListener('submit', function(event) {
        if (form.checkValidity() === false) {
          event.preventDefault();
          event.stopPropagation();
        }
        form.classList.add('was-validated');
      }, false);
    });
  }, false);
})();
</script>
<?php
$query6 = sprintf("Redacted for security");
$result6 = mysqli_query($conn, $query6);
$total = mysqli_num_rows($result6);
$pages = ceil($total/20);
$targetpage = "messages.php"; //your file name
$limit = 20; //how many items to show per page
if ($page <= 0) {  $page = 1; }
if ($page >= $pages) { $page = $pages; }
$offset = $page * 20 - 20;
$prev = $page - 1;
$next = $page + 1;
$next2 = $page + 2;
$next3 = $page + 3;
$prev2 = $page - 2;
$prev3 = $page - 3;
if ($prev < 1) {$noprev = true; } else { $noprev = false;}
if ($next > $pages) {$nonext = true; } else { $nonext = false;}
$query = sprintf(Redacted for security);
$result = mysqli_query($conn, $query);
if (!$result) { echo "No results found for $search in your message history"; die(); }
while ($row = $result->fetch_assoc()) {
  $title = $row['title'];
  $time = gmdate("Y-m-d h:iA", $row['time']);
  $thread = $row['thread'];
  $sender = $row['sender'];
  $body = $row['body'];
  $type = $row['type'];
  $uni = $row['uni'];
  if ($type == "text"){
  echo "<div class=\"card\">
          <div class=\"card-body\">
            <h5 class=\"card-title\"><a href=\"Redacted for security">$title</a></h5>
            <h6 class=\"card-subtitle mb-2 text-muted\">";echo "$sender - $time </h6>
            <p class=\"card-text\">$body</p>
          </div>
        </div>";
  } elseif ($type == "image") {
  echo "<div class=\"card\">
          <div class=\"card-body\">
            <h5 class=\"card-title\"><a href=\"Redacted for security">$title</a></h5>
            <h6 class=\"card-subtitle mb-2 text-muted\">";echo "$sender - $time </h6>
            <img src=\"Redacted for security" alt=\"$title\" style=\"max-height: 200px; max-width: 600;\"\">
          </div>
        </div>";
  } elseif ($type == "video"){
  echo "<div class=\"card\">
          <div class=\"card-body\">
            <h5 class=\"card-title\"><a href=\"Redacted for security">$title</a></h5>
            <h6 class=\"card-subtitle mb-2 text-muted\">";echo "$sender - $time </h6>
            <a href=\"Redacted for security"><img src=\"Redacted for security" alt=\"$title\" style=\"max-height: 200px; max-width: 600;\"\"></a>
          </div>
        </div>";
  }
}
?>
<hr class="my-4">
<nav aria-label="Page navigation example">
  <ul class="pagination">
    <?php
    if ($noprev == true) {
    echo "<li class=\"page-item disabled\">";
    echo "<a class=\"page-link\" href=\"?pg=1$filter\">First</a>";
    echo "</li>";
    echo "<li class=\"page-item disabled\">";
    echo "<a class=\"page-link\" href=\"\">Previous</a>";
    echo "</li>";
    } else {
    echo "<a class=\"page-link\" href=\"?pg=1$filter\">First</a>";
    echo "<li class=\"page-item \"><a class=\"page-link\" href=\"?pg=$prev$filter\">Previous</a></li>";
    }
    if ($prev3 >= 1) {
    echo "<li class=\"page-item\"><a class=\"page-link\" href=\"?pg=$prev3$filter\">$prev3</a></li>";
    }
    if ($prev2 >= 1) {
    echo "<li class=\"page-item\"><a class=\"page-link\" href=\"?pg=$prev2$filter\">$prev2</a></li>";
    }
    if ($prev >= 1) {
    echo "<li class=\"page-item\"><a class=\"page-link\" href=\"?pg=$prev$filter\">$prev</a></li>";
    }
    echo "<li class=\"page-item active\"><a class=\"page-link\" href=\"?pg=$page\">$page</a></li>";
    if ($next <= $pages) {
    echo "<li class=\"page-item\"><a class=\"page-link\" href=\"?pg=$next$filter\">$next</a></li>";
    }
    if ($next2 <= $pages) {
    echo "<li class=\"page-item\"><a class=\"page-link\" href=\"?pg=$next2$filter\">$next2</a></li>";
    }
    if ($next3 <= $pages) {
    echo "<li class=\"page-item\"><a class=\"page-link\" href=\"?pg=$next3$filter\">$next3</a></li>";
    }
    if ($nonext == true) {
    echo "<li class=\"page-item disabled\">";
    echo "<a class=\"page-link\" href=\"\">Next</a>";
    echo "</li>";
    echo "<li class=\"page-item disabled\">";
    echo "<a class=\"page-link\" href=\"?pg=$pages$filter\">Last</a>";
    echo "</li>";
    } else {
    echo "<li class=\"page-item\"><a class=\"page-link\" href=\"?pg=$next$filter\">Next</a></li>";
    echo "<a class=\"page-link\" href=\"?pg=$pages$filter\">Last</a>";
    }
    ?>
  </ul>
</nav>
      </div>
    </div>
</div>