Anyone have any idea on how to do a simple line graph using PHP codes?
Use PHP to do Line Graph
Collapse
X
-
Tags: None
-
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
-
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
Comment