Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    New Coder
    Join Date
    Jul 2011
    Posts
    43
    Thanks
    11
    Thanked 0 Times in 0 Posts

    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!





  • #2
    Master Coder
    Join Date
    Jun 2003
    Location
    Cottage Grove, Minnesota
    Posts
    9,502
    Thanks
    8
    Thanked 1,089 Times in 1,080 Posts
    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"?


    .

  • #3
    New Coder
    Join Date
    Jul 2011
    Posts
    43
    Thanks
    11
    Thanked 0 Times in 0 Posts
    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.

  • #4
    Master Coder
    Join Date
    Jun 2003
    Location
    Cottage Grove, Minnesota
    Posts
    9,502
    Thanks
    8
    Thanked 1,089 Times in 1,080 Posts
    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.

    .

  • #5
    New Coder
    Join Date
    Jul 2011
    Posts
    43
    Thanks
    11
    Thanked 0 Times in 0 Posts
    Yes, I actually just finished creating the table.

  • #6
    Master Coder
    Join Date
    Jun 2003
    Location
    Cottage Grove, Minnesota
    Posts
    9,502
    Thanks
    8
    Thanked 1,089 Times in 1,080 Posts
    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.


    .


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •