HTML/MySQL Graph Page Development
Budget: $10 – $200 USD
This project relies on an existing Windows Apache+PHP+mySQL database (standard WAMP installation).
The database currently has eight columns. The columns of interest here are only three (devicename, date/time, density).
What I would like done is:
1. The development of a simple HTML/PHP page that would read the last 50 entries of the mySQL database *per device* and display three simple density-to-time line charts for each of the three different devices that exist in the database.
2. The integration of a simple forecasting calculation that will display next to or below the graph indicating how many hours it would take for the density to reach a critical value (pre-set in the code or entered in the page) if the trend of the last 50 entries is negative. This can be done in any way applicable (Javascript, Python, etc), as long as the result is shown next/below the graph on the webpage. This requires the implementation of some sort of forecasting algorithm, as future values need to be forecasted for the critical time to be calculated.
An example image of how I expect the webpage to look is attached. This image is purely indicative - you can implement any type and style of graphs, as long as it does the required job.
The MySQL database exports are of course available, as is Teamviewer access to a test server.
The database currently has eight columns. The columns of interest here are only three (devicename, date/time, density).
What I would like done is:
1. The development of a simple HTML/PHP page that would read the last 50 entries of the mySQL database *per device* and display three simple density-to-time line charts for each of the three different devices that exist in the database.
2. The integration of a simple forecasting calculation that will display next to or below the graph indicating how many hours it would take for the density to reach a critical value (pre-set in the code or entered in the page) if the trend of the last 50 entries is negative. This can be done in any way applicable (Javascript, Python, etc), as long as the result is shown next/below the graph on the webpage. This requires the implementation of some sort of forecasting algorithm, as future values need to be forecasted for the critical time to be calculated.
An example image of how I expect the webpage to look is attached. This image is purely indicative - you can implement any type and style of graphs, as long as it does the required job.
The MySQL database exports are of course available, as is Teamviewer access to a test server.