We require a script to be added to our website which allows a user to securely login and view their monthly download amount for their DSL connection.
The user's downloads history is presently being saved in a MYSQL database on a separate machine - it is being used in conjunction with Freeradius AAA.
We require that the user can login to a secure web page which then executes a script to query the MySQL database and present the download amount for the month on the web page being viewed - the user can then logout of the page and close the session.
The webpage is being hosted on an apache based Linux webserver running PHP v5.5.
All suitable solutions will be considered.