Results 1 to 2 of 2

Thread: Generating reports via Mysql

  1. #1
    Join Date
    May 2014

    Generating reports via Mysql

    Hi There

    I am in the midst of creating a website where the user can upload and download music/fx.

    What I need to know is how to generate reports specifically for the following:

    User info:
    -who downloaded/uploaded what, how many times and when

    - what piece of audio, how many times and when

    If anyone just point me in the general direction to start I'd be most grateful.


  2. #2
    Join Date
    Aug 2004
    Well, the first thing you have to do is record those actions in your database. Once you come up with the data schema for that, the reporting process should be fairly straight-forward. At a bare minimum, you need some sort of activity table that includes foreign keys to your user table and your music/fx table, including a column indicating if it's an upload or download. (Depending on how complex things may get or personal preference, it might be desirable to make it two different tables: uploads and downloads.) It would include a timestamp field, which could default to NOW(), allowing you to select and/or sort by date/time.
    "Well done....Consciousness to sarcasm in five seconds!" ~ Terry Pratchett, Night Watch

    How to Ask Questions the Smart Way (not affiliated with this site, but well worth reading)

    My Blog
    cwrBlog: simple, no-database PHP blogging framework

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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