category.php

<?php
session_start();

if (! isset($_SESSION['logged_in'])) {
    $nav = 'includes/nav.php';
} else {
    $nav = 'includes/navconnected.php';
    $idsess = $_SESSION['id'];
}

if (! isset($_GET['id'])) {
    header('Location: index');
}

$id_category = $_GET['id'];
require 'includes/header.php';
require $nav;
?>
<div class="container-fluid product-page">
	<div class="container current-page">
		<nav>
			<div class="nav-wrapper">
				<div class="col s12">
					<a href="index" class="breadcrumb">Home</a> <a
						href="category.php?id=<?= $id_category; ?>" class="breadcrumb">Category</a>
				</div>
			</div>
		</nav>
	</div>
</div>

<div class="container-fluid category-page">
	<div class="row">

		<div class="col s12 m2 center-align cat">
			<div class="collection card">
        <?php
        
        include 'db.php';
        
        // get categories
        $querycategory = "SELECT id, name FROM category";
        $total = $connection->query($querycategory);
        if ($total->num_rows > 0) {
            // output data of each row
            while ($rowcategory = $total->fetch_assoc()) {
                $id_categorydb = $rowcategory['id'];
                $name_category = $rowcategory['name'];
                ?>
         <a href="category.php?id=<?= $id_categorydb; ?>"
					class='collection-item <?php if($id_categorydb == $id_category) {echo"active";} ?>'><?= $name_category; ?></a>
       <?php }} ?>
       </div>
		</div>

		<div class="col s12 m10 ">
			<div class="container content">
				<div class="center-align">
					<button class="button-rounded btn-large waves-effect waves-light">Products</button>
				</div>
				<div class="row">
          <?php
        // get products
        
        // pages links
        $page = isset($_GET['page']) ? (int) $_GET['page'] : 1;
        $perpage = isset($_GET['per-page']) && $_GET['per-page'] <= 16 ? (int) $_GET['per-page'] : 16;
        
        $start = ($page > 1) ? ($page * $perpage) - $perpage : 0;
        
        $queryproduct = "SELECT SQL_CALC_FOUND_ROWS id, name, price, id_picture, thumbnail FROM product WHERE id_category = '{$id_category}' ORDER BY id DESC LIMIT {$start}, 16";
        $result = $connection->query($queryproduct);
        
        // pages
        $total = $connection->query("SELECT FOUND_ROWS() as total")->fetch_assoc()['total'];
        $pages = ceil($total / $perpage);
        
        if ($result->num_rows > 0) {
            // output data of each row
            while ($rowproduct = $result->fetch_assoc()) {
                $id_product = $rowproduct['id'];
                $name_product = $rowproduct['name'];
                $price_product = $rowproduct['price'];
                $id_pic = $rowproduct['id_picture'];
                $thumbnail_product = $rowproduct['thumbnail'];
                
                ?>

                <div class="col s12 m4">
						<div class="card hoverable animated slideInUp wow">
							<div class="card-image">
								<a href="product.php?id=<?= $id_product; ?>"> <img
									src="products/<?= $thumbnail_product; ?>"></a> <span
									class="card-title grey-text"><?= $name_product; ?></span> <a
									href="product.php?id=<?= $id_product; ?>"
									class="btn-floating halfway-fab waves-effect waves-light right"><i
									class="material-icons">add</i></a>
							</div>
							<div class="card-action">
								<div class="container-fluid">
									<h5 class="white-text"><?= $price_product; ?> $</h5>
								</div>
							</div>
						</div>
					</div>
              <?php }} ?>

              </div>
				<div class="center-align animated slideInUp wow">
					<ul class="pagination <?php if($total<15){echo "hide";} ?>">
						<li class="<?php if($page == 1){echo 'hide';} ?>"><a
							href="?page=<?php echo $page-1; ?>&per-page=15"><i
								class="material-icons">chevron_left</i></a></li>
                  <?php for ($x=1; $x <= $pages; $x++) : $y = $x;?>


                      <li
							class="waves-effect pagina  <?php if($page === $x){echo 'active';} elseif($page <  ($x +1) OR $page > ($x +1)){echo'hide';} ?>"><a
							href="?page=<?php echo $x; ?>&per-page=15"><?php echo $x; ?></a></li>



                  <?php endfor; ?>
                  <li class="<?php if($page == $y){echo 'hide';} ?>"><a
							href="?page=<?php echo $page+1; ?>&per-page=15"><i
								class="material-icons">chevron_right</i></a></li>
					</ul>
				</div>
			</div>
		</div>

	</div>
</div>

<?php
require 'includes/secondfooter.php';
require 'includes/footer.php';
?>