How to show the data in graph

Anon

Hi everyone,

I need help with retriving data from the database for the Graphs, and how to print the results either on the monitor or the printer.

Thanks for your help.

mcrbids

Specifics?

What version of PHP are you using? What types of graphs? Bar? Line? Pie?

You might try looking at the articles section at the bottom of the PHPBUILDER home page - there was an article a few months ago about this very thing... using GD.

...
-Ben

soulreaver

Below is the code I use to draw a graph with X & Y axis. It then draws two lines on the chart from left to right. As it stands it needs the ADODB database wrapper to get the info from the database (haven't had to convert it for general release yet.) You can get ADODB @ http:\php.weblogs.com

Heres the code hope it helps

header("Content-type:image/gif");
include('c:\inetpub\scripts\php\adodb\adodb.inc.php'); // load code common to ADODB
ADOLoadCode('access'); // load Access code
$conn = &ADONewConnection(); // create a connection
$conn->PConnect('graph'); // connect to MS-Access, "graph" system DSN
$recordSet=&$conn->Execute('select week_number,value from graphing');

// Here we set the colours & variables
$image=ImageCreate(540,720);
$white=ImageColorAllocate($image,255,255,255);
$red=ImageColorAllocate($image,255,0,0);
$blue=ImageColorAllocate($image,0,0,255);
$black=ImageColorAllocate($image,0,0,0);
$x=20;
$y=700;
$a=20;
$b=700;

// This section draws the graph
while (!$recordSet->EOF)
{
$week=$recordSet->FetchField(0);
$value=$recordSet->FetchField(1);
ImageLine($image,$x,$y,$x+10,700-$recordSet->fields[1],$blue);
$x=$x+10;
$y=700-$recordSet->fields[1];
ImageLine($image,$a,$b,$a+10,700-$recordSet->fields[0],$red);
$a=$a+10;
$b=700-$recordSet->fields[0];
$recordSet->MoveNext();
}

ImageLine($image,20,700,20,0,$black); // Y axis
ImageLine($image,20,700,540,700,$black); // X axis

// This section draws the x axis division lines
$z=30;
While ($z!=540)
{
ImageLine($image,$z,700,$z,710,$black);
$z=$z+10;
}

//This section draws the Y axis division lines
$w=690;
While ($w!=0)
{
ImageLine($image,20,$w,10,$w,$black);
$w=$w-10;
}

ImageGif($image); // this draws the picture

$recordSet->Close(); //close the database
$conn->Close();

'till next time

Neil

Anon

Thanks Neil

Anon

i need to know how to create graph using php and i really need it please help me .....
urgent

soulreaver

OK here is the non ADODB version

INPUT PAGE

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<head>
<title>Untitled</title>
<meta name="generator" >
</head>
<body background="marble0H.gif">
<h1><img src="hours.gif" width="434" height="33" align="right"></h1>
<?
$dberror="";
$link=mysql_connect("DBNAMEHERE","USERID","PASSWORD");
if (!$link)
die("Couldn't connect to MySQL");
mysql_select_db("graphs") or die ("Couldn't open Database");

$dberror="";
if (isset($Week) )
{
$sql = "insert into graphdata (Week_No,Hours)";
$sql .= "values ('$Week','$Hours')";
if(!mysql_query($sql,$link))
{$dberror=mysql_error();
print $dberror;
}
}
?>
<br><br><br>
<table><tr><td>
<img src="graph1.php"></td><td><form>
Week Number <INPUT type="text" name="Week" size="5"><br><br>
Hours             <INPUT type="text" name="Hours" size="10"><br><br>
 <INPUT type="submit" value="Update">    <INPUT type="reset" value="Clear"></td>
<td>
<table><tr><td>Week</td><td>Hours</td></tr>
<?
$select="SELECT graphdata.* FROM graphdata";
$result=mysql_query($select);

while($a_row=mysql_fetch_array($result))
{
print "<tr><td>".$a_row[Week_No]."</td><td>".$a_row[Hours]."</td></tr>";
}

?>
</td></tr>
</table>
</body>

PROCESS PAGE

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

$dberror="";
$link=mysql_connect("SERVER","USERID","PASSWORD");
if (!$link)
die("Couldn't connect to MySQL");
mysql_select_db("graphs") or die ("Couldn't open Database");

// here we interogate the DB
$select="SELECT graphdata.* FROM graphdata";
$result=mysql_query($select);

// This section draws the graph
while($a_row=mysql_fetch_array($result))
{
ImageLine($image,$x,$y,$x+10,700-$a_row[Hours],$blue);
$x=$x+10;
$y=700-$a_row[Hours];
ImageLine($image,$a,$b,$a+10,700-$a_row[Week_No],$red);
$a=$a+10;
$b=700-$a_row[Week_No];
}

ImageLine($image,20,700,20,0,$black); // Y axis
ImageLine($image,20,700,540,700,$black); // X axis

// This section draws the x axis division lines
$z=30;
While ($z!=540)
{
ImageLine($image,$z,700,$z,710,$black);
$z=$z+10;
}

//This section draws the Y axis division lines
$w=690;
While ($w!=0)
{
ImageLine($image,20,$w,10,$w,$black);
$w=$w-10;
}

ImageGif($image); // this draws the picture