With Beekeeper studio, create a new connection, select MySQL as the connection type and fill out the following details (Figure C): Host: The IP address or domain of your MySQL server. Port: 3306.

Create the PHP file to display the report on screen. You will need to connect to the database, then retrieve, format and display the fields if you use dynamic data in your report.