... a real quick one for a dropdown search field which has to find relevant terms to autofill/autocomplete a search form:
-- where @ThisSearch is a posted (and sanitized) variable
SET @ThisSearch:="Brains";
SELECT
...
... terms are not supported; quotation marks and apostrophes may be an issue;
Full PHP:
$sanitized_search=(isset($_GET['search'])&&($sanitized_search==""))?trim(strip_tags(addslashes($_GET['search']))):"";
# ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.