MYSQL & Php Search "no results found" everytime ??

[Maggiemma]

Hello all,
I am trying to do a custom search on my website using MYSQL and PHP. I'm new at both. I've successfully created my MySQL database, added a few items to my table and I've also tested that my resultstext.php page can connect to the database by doing a test. I've watched a ton of tutorials and have created some script, but every time it displays "Successful Connection" "no results found for " my search word that I know I input into MySQL database".

Can anyone please help me figure out what's wrong with the code, so it will find and display my search? I've uploaded my code in a basic text file. I've changed the actual passwords and other sensitive info, but I know the real ones work. I've tried for weeks, but I just don't know coding very well as I'm new at it.

Thanks so much! --Maggie