categories.php

<div class="w3-container w3-center w3-teal"><h3>Categories</div>
<?php
$sql = "SELECT * FROM category";
$result = mysqli_query($dbcon, $sql);

if ($result){
    echo "<div class='w3-container w3-border'>";
    while ($row = mysqli_fetch_assoc($result)) {
        $id = $row['id'];
        $catname = $row['catname'];
        $description = $row['description'];
        ?>

        <div class="w3-panel w3-border"><a href="cat.php?id=<?php echo $id; ?>"><?php echo $catname; ?></a><br>
            <?php echo $description; ?>
        </div>
        <?php
    }
    echo "</div>";
}else{
    echo "<div class='w3-panel w3-pale-red'>No Category found.</div>";
}