I have a LAMP server where users log in and upload/download video files.
I would like to generate some simple php pages to aggregate usage data.
These would be pages for me not end-user pages.
Here are some example stats I would like to see -
Number of users currently logged in.
Number of users logged in today,
Number of users logged in this week.
Number of uploads today
Number of downloads today
Number of uploads this week
Number of downloads this week
etc. etc. etc.
I know how to manually code (i.e. hack my way through it) a php page to generate this information. I have the correct fields already available in MySQL and I know how to do the sql queries to get the final data results.
Can someone recommend a simple framework that would help me build these kinds of data aggregate pages more quickly and efficiently?
Is CakePHP good for this?