Global search in website using php & mysql

I want to implement search option in page header. Results will contain all records those contain filter text.e.g. products. What is the best way to implement global search in website.

via Chebli Mohamed