Go Back   CodingForums.com > :: Server side development > PHP

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 09-22-2011, 05:14 PM   PM User | #1
dareichmann
New Coder

 
Join Date: Jul 2011
Posts: 43
Thanks: 11
Thanked 0 Times in 0 Posts
dareichmann is an unknown quantity at this point
Question How would I build a dashboard/reporting system?

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.

Thank you!




dareichmann is offline   Reply With Quote
Old 09-22-2011, 05:51 PM   PM User | #2
mlseim
Master Coder

 
mlseim's Avatar
 
Join Date: Jun 2003
Location: Cottage Grove, Minnesota
Posts: 9,046
Thanks: 8
Thanked 1,029 Times in 1,020 Posts
mlseim has a spectacular aura aboutmlseim has a spectacular aura aboutmlseim has a spectacular aura about
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"?


.
mlseim is offline   Reply With Quote
Old 09-22-2011, 06:35 PM   PM User | #3
dareichmann
New Coder

 
Join Date: Jul 2011
Posts: 43
Thanks: 11
Thanked 0 Times in 0 Posts
dareichmann is an unknown quantity at this point
I am using MySQL. Those images are just examples of what I want. I want to create a way to display my SQL records in various reports.

Reports for Month to Date sales, Year to date, daily, selected date range, etc.
dareichmann is offline   Reply With Quote
Old 09-22-2011, 06:41 PM   PM User | #4
mlseim
Master Coder

 
mlseim's Avatar
 
Join Date: Jun 2003
Location: Cottage Grove, Minnesota
Posts: 9,046
Thanks: 8
Thanked 1,029 Times in 1,020 Posts
mlseim has a spectacular aura aboutmlseim has a spectacular aura aboutmlseim has a spectacular aura about
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.

.
mlseim is offline   Reply With Quote
Old 09-22-2011, 06:52 PM   PM User | #5
dareichmann
New Coder

 
Join Date: Jul 2011
Posts: 43
Thanks: 11
Thanked 0 Times in 0 Posts
dareichmann is an unknown quantity at this point
Yes, I actually just finished creating the table.
dareichmann is offline   Reply With Quote
Old 09-22-2011, 08:10 PM   PM User | #6
mlseim
Master Coder

 
mlseim's Avatar
 
Join Date: Jun 2003
Location: Cottage Grove, Minnesota
Posts: 9,046
Thanks: 8
Thanked 1,029 Times in 1,020 Posts
mlseim has a spectacular aura aboutmlseim has a spectacular aura aboutmlseim has a spectacular aura about
How about this ...

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.


.
mlseim is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 12:37 PM.


Advertisement
Log in to turn off these ads.