MySQL - SEARCH Form with HTML and PHP

You can create an HTML form that allows you to search records in your MySQL Tables and print the results in a web browser.

In these project we use LIKE and wildcards for the query so that users do not have to have an exact match for results to be provided.

[NN]

Wow this was clear and articulate. The only tutorial on search forms that is helping me through my class project (and I've watched many!). Thank you!

[pcprodoc]

This is exactly what I am looking to do. Thank you for pointing this webdev in the right direction. I am off to create my search page so users do not have do fetch 50+ MB files on their devices! BIG THANKS

[GV-]

This has helped greatly with a school project I was doing. Thank you

[skyfulton]

What if you had multiple search params and 1 submit button? How would you put all that in one output?

[HerDaytona]

wow, nice video... you are concise and explain well. you demonstrate well.... I don't usually comment, I am commenting for the algorithms :)

[jarrenleow]

What should I do if I want the results to appear on the same page instead of a redirect? So like a table of results appearing right below the search bar, instead of going to a .php page

[hongcai]

I was waiting for explanation to explain what if people type "female" or '17' in the search box.. video didn't go there ..

[chrisspencer]

It's not exactly clear to me does MySQL support clustering?

[paolo]

Your code is vulnerable to SQL Injection. Please don't put bad code on the internet, as people are going copy and paste it into production and make their projects vulnerable to things like data breaches.