index.php

<?php require("header.php");
$per_page = 12;

if (isset($_GET['page'])) {
    $page = $_GET['page'];
} else {
    $page = 1;
}

$start_from = ($page - 1) * $per_page;
?>

<div class="col-md-8 col-sm-6 mx-auto">
    <?php
    $sql = "SELECT * FROM question ORDER BY created DESC LIMIT $start_from, $per_page";
    $result = $con->query($sql);
    if ($result->num_rows > 0) {
        while ($row = $result->fetch_assoc()) : ?>

            <a href="addAnswer.php?id=<?php echo $row['id']; ?>">
                <div class="col-lg-12 my-5">

                    <span class="bagde questionDiv"><?php echo mb_strimwidth($row["content"], 0, 200, "..."); ?></span>
                    <p class="text-left mt-2">
                        <span class="badge badge-secondary"><?php echo $row["language"]; ?> </span>
                        <span class="badge badge-secondary"><?php echo $row["category"]; ?></span>
                        <span class="badge badge-secondary"><?php echo $row["duration"]; ?></span>
                        <span class="badge badge-info"><?php echo $row["views"]; ?> views</span>
                    </p>
                    <p class="text-left">
                        <span class="badge">By <?php echo $row["username"]; ?> <?php echo time_elapsed_string($row["created"]); ?></span>
                    </p>
                </div>
            </a>

    <?php endwhile;
    }
    ?>
</div>

<?php
$query = "SELECT * FROM question";
$result = mysqli_query($con, $query);
$total_posts = mysqli_num_rows($result);
$total_pages = ceil($total_posts / $per_page);
$page_url = $_SERVER['PHP_SELF'];

if ($total_posts)
{ 
echo "<div class='text-center'><div class='pagination justify-content-center'><a href ='$page_url?page=1'>First</a>";

for ($i = 1; $i <= $total_pages; $i++) : ?>

    <a class="<?php if ($page == $i) {
                    echo 'active';
                } ?>" href="<?php echo $page_url ?>?page=<?= $i; ?>"> <?= $i; ?> </a>

<?php endfor;
echo "<a href='$page_url?page=$total_pages'>Last</a></div></div>";
} else 
{
   echo '<h1 style="height:100vh;" class="text-center mt-5 mx-auto" >No results were found</h1>';
}
?>

<?php include("footer.php"); ?>