---Overview--- So what I have a currently is rather simple PHP page which connects to the MySQL server (MariaDB) and simply runs; "SELECT FROM Firmware"
The PHP page paginates these results as the database currently stands at over 2,700 entries which simply cannot be parsed all at once due to it running into the maximum script execution time allowed by my hosting provider.
The script then checks the URL's it gets back from the database and populates them in a table (25 results per page) with a simple Tick if they're online and a Cross if they're not (using the FontAwesome library). Whilst this works, with so SO many links to check, it is impossible to notice older files that may have gone offline as the table really only is useful for the latest uploaded files.
What i would like is for some key stats to show at the top. Something like this dashboard example. https://workplace.datto.com/managerhelp/Content/Resources/Images/MSPPortal/Dashboard.png
I like the “pie charts” showing the ratio of online to offline files, along with the total online and total offline file counts.
However, if I have some files offline, id like to be able to click the pie chart and it to “filter” my table to show me the offline files so I can fix them without digging through 100 pages to see which ones are offline.
Due to the maximum PHP execution time, these 2,700+ rows cannot all be fetched and parsed at once. I would imagine the only way to do this is to load a set figure (maybe 100?) at one time and use AJAX or something to load in the remaining chunks of data. You can of course play with the number of results fetched per query and find the servers limits to ensure the page loads in a timely manner. It would be good to have some kind of indicator on the page to show me that the results are still loading.
Many times, just the most recent 25 files are enough for me to see, i add somewhere between 5 and 50 results a day. But i always want to make sure that all of the older files are offline.
---Ultimate Goals--- - One Pie chart at the top of the page showing total number of files and how many are off/online. - Table (as i currently have) showing the status of all of the files individually. - The ability to click the pie chart to filter the table to the offline files, regardless of what page in the results table the offline file is on.
---Limitations--- - Maximum PHP execution time with my host is somewhere around 60 seconds, you need to work with this in mind on a growing database with approx 500 additions per year. - Language should be mainly PHP/HTML, any additional language used should be well commented.
As for what happened last time, the developer i hired got the pie charts working, but he couldn't work around the maximum execution time of the server. All the charts showed was the status of whatever was on that current page which was totally useless.
If the entire page has to change to make this work, that is totally fine, the absolute critical thing is to be able to see the status of all files and to be able to see very quickly if any of the files are offline.