Go4Expert

Go4Expert (http://www.go4expert.com/)
-   PHP (http://www.go4expert.com/forums/php/)
-   -   Drawing Bar Graphs using GD/MySQL (http://www.go4expert.com/forums/drawing-bar-graphs-using-gd-mysql-t5545/)

coool 30Jul2007 19:51

Drawing Bar Graphs using GD/MySQL
 
Hi..

I'm having problem in this code !

I beileve it's almost done, but just need a little fix !

here's the code:
image.php
PHP Code:

<?php 
//already been connected to database 

$sql "SELECT Status FROM Table1 GROUP BY Status"
$x mysql_query($sql) or die("Error - Could not $sqlmysql_error()); 

$sql "SELECT COUNT(Items) FROM Table1 GROUP BY Status"
$y mysql_query($sql) or die("Error - Could not $sqlmysql_error()); 

//x= sold,shipped,InStock,UnKnown 
//y= 8,6,3,5 

        
$width 300
        
$height 200

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

        
$image ImageCreate($width,$height) or die ("Cannot Create image"); 

        
$white ImageColorAllocate($image,255,255,255); 
        
$black ImageColorAllocate($image,0,0,0); 
        
$red ImageColorAllocate($image,255,0,0); 
        
$green ImageColorAllocate($image,0,255,0); 
        
$blue ImageColorAllocate($image,0,0,255); 

        
$maxY 0
        for (
$i=0;$i<7;$i++){ 
          if (
$y[$i] > $maxY)$maxY=$y[$i]; 
        } 

        
ImageRectangle($image,1,1,319,239,$black); 

        
imageLine($image,10,5,10,230,$blue); 
        
imageLine($image,10,230,300,230,$blue); 

        
ImageString($im,3,15,5,"CR ID",$black); 
        
ImageString($im,3,280,240,"Status",$black); 
        
ImageString($im,5,100,50,"Simple Graph",$red); 
        
ImageString($im,5,125,75,"by Lina",$green); 

        
$xPos 15
        
$yPos 230
        
$barWidth 20
        
$barHeight 0

        for (
$i=0;$i<3;$i++){ 
          
$barHeight = ($y[$i]/$maxY)* 100
          
imagerectangle($image,$xPos,$yPos,$xPos+$barWidth,($yPos-$barHeight),$red); 
          
imagestring$image,2,$xPos-1,$yPos+1,$x[$i],$black); 
          
imagestring$image,2,$xPos-1,$yPos+10,$y[$i],$black); 
          
$xPos += ($barWidth+20); 
        } 

        
ImagePng($image"graph.png"90); 
?>

page.php
Code:


....
<img src="image.php"/>
....

Error: after excuting page.php
The image “http://websiteName.com/image.php” cannot be displayed, because it contains errors.

pradeep 31Jul2007 09:53

Re: Drawing Bar Graphs using GD/MySQL
 
Please refer to the PHP Manual!
ImagePng($image, "graph.png", 90);

The imagepng() outputs a GD image stream (image) in PNG format to standard output (usually the browser) or, if a filename is given by the filename it outputs the image to the file.

coool 9Aug2007 19:06

Re: Drawing Bar Graphs using GD/MySQL
 
Things are working perfectly

Thanks :)


All times are GMT +5.5. The time now is 07:49.