I am updating my quadcopter website and improving my search system. Currently the user is only able to search by quadcopter model. I am now slightly improving this so the user can search for the brand or the model.
I would like the user to be able to type the brand and model into the search field, and allow for both words to be checked between either record in the DB.
Basically, lets say the brand of the quadcopter is "DJI" and the model is "Phantom", in my database one would be stored under the 'column' brand and the other under 'model'. I would like the user to be able to type in 'dji phantom' and have the model show up.
If this is not possible then is there a way to make the result show even if it is not exact? With my search field currently you can search for the quadcopter as long as it contains a full part of the string. For example, 'plant' will show "DJI Phantom" so will 'anton'
Here is my query:
$search = $_GET['search'];
$search_list = mysqli_query($conn,"SELECT * FROM quads WHERE model LIKE '%$search%' OR brand LIKE '%$search%'");
PS (I know it is vulnerable to injection; this is something I'm fixing this week, thank you).