PHP Product Table from MySQL

I need a compact, well-commented PHP script that connects to my existing MySQL database, pulls the product details I specify, and renders them in a clean HTML table. The focus is strictly on data retrieval and display—no editing or admin workflow for now.

Here is what I expect:

• Connection handled with PDO or MySQLi, using prepared statements for security.
• A query that fetches the key product fields (ID, name, price, stock, plus any additional columns we agree on).
• An HTML table that prints the results, laid out clearly with basic CSS I can extend later.
• Error handling that shows friendly messages instead of raw warnings.
• A short README noting the query, where to drop my own credentials, and how to swap in different columns if needed.

If you can add lightweight pagination or column sorting without bloat, even better, but the core deliverable is a single working .php file and the accompanying SQL snippet that creates a demo table so I can test right away.

Let me know your timeframe and any clarifications you need, and we can get started.