1#@!#!123s

: / proc / self / root / home / markniuj / bazmeasar.com / favorite /

Filename : favorite_categories.php

back

<?php
include "../config.php";

// Query to retrieve your 6 favorite categories
$favorite_categories_query = "SELECT catname FROM categories WHERE is_favorite = 1 LIMIT 3";
$favorite_categories_result = $conn->query($favorite_categories_query);
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>My Favorite Categories</title>
    <!-- Include any necessary styles or libraries -->
</head>
<body>
    <h1>My Favorite Categories</h1>
    <ul>
        <?php
        if ($favorite_categories_result->num_rows > 0) {
            while ($category_row = $favorite_categories_result->fetch_assoc()) {
                $catname = $category_row['catname'];
                echo "<li>$catname</li>";
            }
        } else {
            echo "<p>No favorite categories found.</p>";
        }
        ?>
    </ul>
</body>
</html>