Button-Triggered MySQL Results Page -- 2

I need a small, self-contained code snippet that adds a button labeled “Search” to my existing web page. When a user clicks this button it must:

• run a SELECT statement against my MySQL database (I will give you the exact query)
• open a new HTML page and show only the specific columns I indicate, formatted in an easy-to-read table

Please keep the logic clean (PHP + MySQLi or PDO is fine), comment your code so I can adjust the query later, and separate the front-end markup from the database call. A short README explaining where to drop each file will be helpful.

Query should pass user input/filter values from the current page.
Ex select * from table where name = ( value gotten from field in page)

Result should navigate in the same tab.