prepare("SELECT pro_id, pro_name, pro_category FROM tbl_product WHERE pro_name LIKE ? LIMIT 10"); $searchTerm = "%{$q}%"; $stmt->bind_param("s", $searchTerm); $stmt->execute(); $result = $stmt->get_result(); echo "

"; while ($row = $result->fetch_assoc()) { $pro_id = htmlspecialchars($row['pro_id']); $pro_name = htmlspecialchars($row['pro_name']); $pro_category = htmlspecialchars($row['pro_category']); echo "
• $pro_name ($pro_category)
"; } echo "

"; $stmt->close(); } ?>