Anonymous
public text v1 · immutable $sql = "SELECT badge_id, badge_name_h, badge_name_v
FROM badges
WHERE (`badge_name_h` LIKE ?) OR (`badge_name_v` LIKE ?)";
$search="'%{$_GET['name']}%'";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('ss', $search, $search);