search_menu.php

<?php
include('koneksi.php');

if (isset($_POST['searchText'])) {
    $searchText = mysqli_real_escape_string($koneksi, $_POST['searchText']);

    $query = "SELECT * FROM menus WHERE name LIKE '%$searchText%' OR category LIKE '%$searchText%' OR details LIKE '%$searchText%'";
    $result = mysqli_query($koneksi, $query);

    $menuCount = 0;

    while ($row = mysqli_fetch_assoc($result)) {
        // Tampilkan hasil pencarian
        if ($menuCount % 3 == 0) {
            if ($menuCount > 0) {
                echo '</div>';
            }
            echo '<div class="row justify-content-center">';
        }

        echo "<div class='col-md-4'>
            <div class='menu-entry mb-4'>";
        if (isset($row['image'])) {
            echo "<a href='#' class='img' style='background-image: url(uploads/{$row['image']});'></a>";
        }
        echo "<div class='text text-center pt-4'>
            <h3><a href='#'>{$row['name']}</a></h3>
            <p><span>{$row['category']}</span></p>
            <p class='price'><span>{$row['price']}</span></p>
            <p>{$row['details']}</p>
            <div class='mt-2'>
                <a href='edit_menu.php?id={$row['no_menu']}' class='btn btn-primary btn-sm'>Edit</a>
                <a href='delete_menu.php?id={$row['no_menu']}' class='btn btn-danger btn-sm'>Delete</a>
            </div>
        </div>
    </div>
</div>";

        $menuCount++;
    }

    mysqli_close($koneksi);

    // Tutup shaf terakhir jika jumlah menu tidak habis dibagi 3
    if ($menuCount % 3 != 0) {
        echo '</div>';
    }
}