HTML is only capable of instructing a browser on the method of presenting information. The transactions needed to store information in the database require Structured Query Language (SQL) commands ...

You will first need code for the forms, then code to make the connection to the database and write the data to MySQL and code for the reports to display static or dynamic information to site visitors.

I want to show you how to install and use DBeaver to connect to your remote MySQL server. DBeaver is available for Windows, macOS, and Linux.