我的搜索引擎显示没有错误，但没有显示任何结果

I want to make a search engine. I got this following code. The code is written to trim out spaces, count rows and amount of matching results and also a bit sql injection proof. All these attributes work but the search itself shows no results. Neither do I get an error report. I have been reviewing this code for some time now and I just can't find what is going wrong. I know this is mysql and deprecated but I figured it should still work. Is the reason why it's not working because Mysql is deprecated or can you find a mistake I have made? Hopefully my question is clear enough.I want to make a search engine. I got this foll