Quick actions

cmd+k|ctrl+k

Navigation

Languages

library-searcing

Snippet info

Language

Php

Visibility

public

Author

sutrisnob33

Created

2025-05-04T01:22:34.505785Z

Updated

2025-05-04T01:22:34.505785Z

<?php
    if (isset($_POST["search"])) {
        $search = htmlspecialchars($_POST["searchPost"]);
        
        $queryBook = mysqli_query($conn, "SELECT * FROM books 
                                        WHERE judul LIKE '%$search%' 
                                        OR kategori LIKE '%$search%'");
    
        while ($book = mysqli_fetch_assoc($queryBook)) {
            $books[] = $book;
        }
    }else {
        while($book = mysqli_fetch_assoc($queryBook)){
            $books[] = $book;
        }
    }
?>

    <form action="" method="POST">
        <div class="row mt-5">
            <div class="col-lg-6 col-sm-10">
            <input type="text" class="form-control" name="searchPost">

            </div>
            <div class="col-4">
            <button type="submit" name="search" class="btn btn-success">Search</button>

            </div>
        </div>
    </form>
INFO