MySQL

If you want to want to make even some characthers searchable then use ==> WHERE id like ‘%$search%’, then your can search almost everything BUT it will open up all data inside the DB and it will be displaied when emoty search is performed. you can also use OR operator in MySQL to add some … Read more

This code is all you will need to build a simple SEARCH function using MySQL & PHP.

PS! After establishing connection to mySQL server and then performing CRUD then it would be a good practice to CLOSE the connection like this: Connect to MySQL DATABASE using PHP.