I know this is an old post and I have 0 rep. So here is my CRITICAL comment on using the $type = "$type%": When using like in mysql queries you need to escape the $type first, otherwise foul people can insert the special match patterns (+%_) themselves, use addcslashes() so line should be

$type = addcslashes($type, '+%_') . '%'

then your code won't do unexpected things like return the entire database when someone types %a into the search box which in example code would become %a% and using code above \%a% and probable have no match. See https://www.php.net/manual/en/function.addcslashes.php and https://mariadb.com/kb/en/like/