avanti-merch-dashboard/index.php at main · abdullohmmuttaqin/avanti-merch-dashboard · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
<?php
include 'config/database.php';

$keyword = isset($_GET['search']) ? $_GET['search'] : '';

if ($keyword != '') {
    $query2 = mysqli_query($conn, "
        SELECT * FROM products
        WHERE nama_produk LIKE '%$keyword%'
        ORDER BY id DESC
    ");
} else {
    $query2 = mysqli_query($conn, "
        SELECT * FROM products
        ORDER BY id DESC
    ");
}

$latest_produk = mysqli_query($conn, "
    SELECT * FROM products
    ORDER BY id DESC
    LIMIT 4
");
?>

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>AVANTI MERCH</title>
    <link rel="stylesheet" href="assets/css/style.css">
</head>

<body>

    <!-- NAVBAR -->
    <nav class="navbar">
        <div class="logo">AVANTI MERCH</div>
        <ul>
            <li><a href="#hero">Home</a></li>
            <li><a href="#latest">Latest</a></li>
            <li><a href="#category">Category</a></li>
            <li><a href="#shop">Shop</a></li>
            <li><a href="admin/login.php">Admin</a></li>
        </ul>
    </nav>

    <!-- HERO -->
    <section class="hero" id="hero">
        <div class="overlay"></div>
        <div class="hero-text">
            <h1>Official Underground Merchandise</h1>
            <p>
                Premium punk rock apparel, hardcore essentials, limited streetwear,
                and authentic band culture accessories.
            </p>
            <a href="#shop">Explore Collection</a>
        </div>
    </section>

    <!-- FEATURE INFO -->
    <section class="feature">
        <div>Premium Fabric Quality</div>
        <div>Limited Underground Design</div>
        <div>Authentic Merchandise Culture</div>
        <div>Worldwide Shipping Ready</div>
    </section>

    <!-- LATEST -->
    <section class="section" id="latest">
        <h2>Latest Drops</h2>

        <div class="product-grid">
            <?php while ($product = mysqli_fetch_assoc($latest_produk)) : ?>
                <div class="card">
                    <div class="img-box">
                        <img src="assets/images/<?php echo $product['gambar']; ?>" alt="">
                    </div>

                    <div class="card-body">
                        <h3><?php echo $product['nama_produk']; ?></h3>

                        <p class="price">
                            Rp<?php echo number_format($product['harga'], 0, ',', '.'); ?>
                        </p>

                        <span class="tag">
                            <?php echo $product['kategori']; ?>
                        </span>

                        <a href="pages/product.php?id=<?php echo $product['id']; ?>" class="btn">
                            View Product
                        </a>
                    </div>
                </div>
            <?php endwhile; ?>
        </div>
    </section>

    <!-- CATEGORY -->
    <section class="section" id="category">
        <h2>Shop By Category</h2>
        <div class="category-grid">
            <div class="cat">Punk Rock Collection</div>
            <div class="cat">Hardcore Essentials</div>
            <div class="cat">Streetwear Limited</div>
            <div class="cat">Band Accessories</div>
        </div>
    </section>

    <!-- SHOP -->
    <section class="section" id="shop">
        <h2>All Merchandise</h2>

        <form method="GET" class="search-form">
            <input
                type="text"
                name="search"
                placeholder="Search merchandise..."
                value="<?php echo $keyword; ?>"
                class="search-input">

            <button type="submit" class="btn">
                Search
            </button>
        </form>

        <div class="product-grid">
            <?php if (mysqli_num_rows($query2) > 0) : ?>

                <?php while ($product = mysqli_fetch_assoc($query2)) : ?>
                    <div class="card">

                        <div class="img-box">
                            <img src="assets/images/<?php echo $product['gambar']; ?>" alt="">
                        </div>

                        <div class="card-body">
                            <h3><?php echo $product['nama_produk']; ?></h3>

                            <p class="price">
                                Rp<?php echo number_format($product['harga'], 0, ',', '.'); ?>
                            </p>

                            <span class="tag">
                                <?php echo $product['kategori']; ?>
                            </span>

                            <a href="pages/product.php?id=<?php echo $product['id']; ?>" class="btn">
                                Buy Now
                            </a>
                        </div>

                    </div>
                <?php endwhile; ?>

            <?php else : ?>

                <p class="empty-text">
                    No products found.
                </p>

            <?php endif; ?>
        </div>
    </section>

    <!-- ABOUT -->
    <section class="about">
        <h2>Built For Underground Culture</h2>
        <p>
            AVANTI MERCH is a premium independent merchandise platform focused on authentic
            punk rock movement, hardcore street culture, and limited apparel drops.
        </p>
    </section>

    <!-- FOOTER -->
    <footer>
        <h3>AVANTI MERCH</h3>
        <p>Premium Underground Merchandise Platform © 2026</p>
    </footer>

</body>

</html>
No products found.