This process involves connecting to the database, querying it for data and presenting the data in HTML, often by using a server side scripting language such as PHP.

Use a DSN-less connection (i.e. with no data source defined on the server) to connect the program to your database for simplicity. You will need to use HTML to format the data.