I will need to create a dashboard/reporting system that can show our transactions. I honestly have no clue where to start. I know the basics and can get my way around PHP, but I am far from an expert. The images I have attached is what I am looking to accomplish. The graph is not as important, but the report page is what I really need to build. Any guidance, help, tutorials would be greatly appreciated. I guess I am looking to build or find a php reporting engine that will work my database, if possible.
Are you using MySQL for a database? And are those images just an example
of what you want, or do they actually exist, but you want them in a "dashboard"?
Do you know the name of your MySQL table and the column names?
I'm not saying this will be an easy thing, and we can offer a script ... I'm
just working on giving you an idea of how to approach it. You may have
to hire a programmer (freelancer). We can offer an explanation that will
help you get a quote, or steer you ... if you choose to tackle this yourself.
Create a webpage that displays the dashboard exactly how you want,
but for all values, just hard-code some fake numbers. So in effect, you're
making a template that we can see.
Once we see the way it's supposed to look, and the features you need, we
can show you some queries, and how to loop through to display data.