Use PHP to do Line Graph

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • fruityfreak
    New Member
    • Jun 2007
    • 24

    Use PHP to do Line Graph

    Anyone have any idea on how to do a simple line graph using PHP codes?
  • Markus
    Recognized Expert Expert
    • Jun 2007
    • 6092

    #2
    Try the jpgraph library.

    Hope that helps.

    Regards, markus.

    Comment

    • fruityfreak
      New Member
      • Jun 2007
      • 24

      #3
      How can i use something like this to do a line graph??? Anyone can give me any clue on that???


      http://www.daniweb.com/forums/thread100930.ht ml

      <?php
      include_once 'db.php';

      $qt=mysql_query ("select * from gd_graph1 order by sales");


      header ("Content-type: image/gif");


      $x_gap=40; // The gap between each point in y axis

      $x_max=$x_gap*1 3; // Maximum width of the graph or horizontal axis
      $y_max=250; // Maximum hight of the graph or vertical axis
      // Above two variables will be used to create a canvas of the image//


      $im = @ImageCreate ($x_max, $y_max)
      or die ("Cannot Initialize new GD image stream");
      $background_col or = ImageColorAlloc ate ($im, 234, 234, 234);
      $text_color = ImageColorAlloc ate ($im, 233, 14, 91);
      $graph_color = ImageColorAlloc ate ($im,25,25,25);

      $x1=0;
      $y1=0;
      $first_one="yes ";
      while($nt=mysql _fetch_array($q t)){
      //echo "$nt[month], $nt[sales]";
      echo $nt['month'];
      echo $nt['sales'];
      $x2=$x1+$x_gap; // Shifting in X axis
      $y2=$y_max-$nt[sales]; // Coordinate of Y axis
      ImageString($im ,2,$x2,$y2,$nt[month],$graph_color);
      //Line above is to print month names on the graph
      if($first_one== "no"){ // this is to prevent from starting $x1= and $y1=0
      imageline ($im,$x1, $y1,$x2,$y2,$te xt_color); // Drawing the line between two points
      }
      $x1=$x2; // Storing the value for next draw
      $y1=$y2;
      $first_one="no" ; // Now flag is set to allow the drawing
      }

      ImageJPEG ($im);

      ?>

      Comment

      • spudse
        New Member
        • Jan 2008
        • 11

        #4
        Jpgraph is indeed created just to do this. The script you pasted is a Jpgraph script also.

        Jpgraph is a sort of script/library that uses GD library (needs to be installed in php) to create graphs. It comes with a massive load of examples, which you can alter to create into something you like.

        Comment

        Working...