#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2012
    Posts
    2
    Rep Power
    0
    As the database is always being updated with new values each hour, how would I go about creating a dynamic chart, graph or some other format that reads from the database and display the activity of the user effectively? Any code examples would be much appreciated too, thanks in advance.
  2. #2
  3. No Profile Picture
    Lost in code
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 2004
    Posts
    8,301
    Rep Power
    7170
    Split from http://forums.devshed.com/php-develo...on-936111.html

    In the future please create a new thread for your question unless it is exactly the same as a question in an existing thread.

    There are a variety of graphing libraries that you could use to do this. flot and HighCharts are two JavaScript options. These tend to be the best options, but there are also PHP libraries like jpgraph that can generate graphs.
    PHP FAQ

    Originally Posted by Spad
    Ah USB, the only rectangular connector where you have to make 3 attempts before you get it the right way around
  4. #3
  5. Mad Scientist
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Oct 2007
    Location
    North Yorkshire, UK
    Posts
    3,660
    Rep Power
    4123
    I like Sencha's Ext (a javascript library), here are some of their examples

    Liv update when you edit the data on page

    Live update graph from server

    These are examples; and a combination of the two could be what you're looking for. their SDK has working PHP examples of some of their samples
    I said I didn't like ORM!!! <?php $this->model->update($this->request->resources[0])->set($this->request->getData())->getData('count'); ?>

    PDO vs mysql_* functions: Find a Migration Guide Here

    [ Xeneco - T'interweb Development ] - [ Are you a Help Vampire? ] - [ Read The manual! ] - [ W3 methods - GET, POST, etc ] - [ Web Design Hell ]

IMN logo majestic logo threadwatch logo seochat tools logo