<?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>
