Results 1 to 2 of 2

Thread: How to use php-gd create a graph from data that is stored inside a sqlite database?

  1. #1
    Join Date
    Mar 2013
    Beans
    45

    How to use php-gd create a graph from data that is stored inside a sqlite database?

    I can't find any on the website...any simple tutorial for this kind of problem?

  2. #2
    Join Date
    Feb 2007
    Location
    West Hills CA
    Beans
    10,048
    Distro
    Ubuntu 14.04 Trusty Tahr

    Re: How to use php-gd create a graph from data that is stored inside a sqlite databa

    Try searching for php5-gd in google.

    http://php.net/manual/en/book.image.php

    Typically you would do an SQL query on the data that you are interested in and dump it to a file, then use php5-gd to read that file and plot your data.

    I don't know of a way to directly plot SQL query data from php5-gd without an intermediate step.

    Normally when you can't find how to do something, you might be using the wrong tool. For instance: "How do I draw an SQL graph using an eggbeater?" You won't get many hits. But, "How do I draw a graph with PHP" brings up a lot of hits:

    http://pchart.sourceforge.net/
    https://developers.google.com/chart/...ery/chart_gall
    http://teethgrinder.co.uk/open-flash-chart-2/
    http://graphpite.sourceforge.net/
    http://www.jscharts.com/
    http://stackoverflow.com/questions/1...php-from-mysql

    php5-gd may be an eggbeater for this application. Not the right tool for the job.
    Last edited by tgalati4; March 18th, 2013 at 06:06 PM.
    -------------------------------------
    Oooh Shiny: PopularPages

    Unumquodque potest reparantur. Patientia sit virtus.

Tags for this Thread

Bookmarks

Posting Permissions

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