hi everyone .... how to graph data from MSSQL database using php? i research in google and i found phpgraphlib but it only graph the value of the array

Pass the database values to array and use that array

Pass the database values to array and use that array

i use odbc connection...and i dont know much about array ..

i dunno how to array my variables .. im totally newbie for chart thing :(

here is my code....

<?php

$conn=odbc_connect('datasourcegaby','','');

$search=mysql_escape_string($_POST['SEARCH']);


if (!$conn)
  {exit("Connection Failed: " . $conn);}
$sql="SELECT POWER_GEN_1,POWER_FACTOR_GEN_1,KWH_GEN_1 FROM generators WHERE convert(datetime,convert(char(10),TIMESTAMP,101)) = '$search' ";


$rs=odbc_exec($conn,$sql);
if (!$rs)
  {exit("Error in SQL");}
echo "<div class=\"leftdv\"><div class=\"topb\"><FONT SIZE=\"5\">GENERATOR 1</FONT></div><table border=\"1\" style=\"table-layout:fixed\" class=\"totalinsidet\"><tr class=\"topbth\">";
echo "<th>POWER_GEN_1</th>";
echo "<th>POWER_FACTOR_GEN_1</th>";
echo "<th>KWH_GEN_1</th></tr>";





while (odbc_fetch_row($rs))
  {
    
  $powergen1=odbc_result($rs,"POWER_GEN_1");
  $powerfactorgen1=odbc_result($rs,"POWER_FACTOR_GEN_1");
    $kwhgen1=odbc_result($rs,"KWH_GEN_1");
	

  
  echo "<tr><td style=\"white-space:pre-wrap;white-space:-moz-pre-wrap;white-space:-pre-wrap;white-space:-o-pre-wrap;word-wrap:break-word\">$powergen1</td>";
   echo "<td style=\"white-space:pre-wrap;white-space:-moz-pre-wrap;white-space:-pre-wrap;white-space:-o-pre-wrap;word-wrap:break-word\">$powerfactorgen1</td>";
  
	  echo "<td style=\"white-space:pre-wrap;white-space:-moz-pre-wrap;white-space:-pre-wrap;white-space:-o-pre-wrap;word-wrap:break-word\">$kwhgen1</td></tr></div>";






  }
 
  
echo "</table>";
?>

btw i found a script... how can i do this? .. i mean to work it with my code...coz it gives me an error when i try to mixed it with my code


sorry im totally a newbie

here it is:

<?
	# ------- The graph values in the form of associative array
	$values=array(
		"Jan" => 110,
		"Feb" => 130,
		"Mar" => 215,
		"Apr" => 81,
		"May" => 310,
		"Jun" => 110,
		"Jul" => 190,
		"Aug" => 175,
		"Sep" => 390,
		"Oct" => 286,
		"Nov" => 150,
		"Dec" => 196
	);

 
	$img_width=450;
	$img_height=300; 
	$margins=20;

 
	# ---- Find the size of graph by substracting the size of borders
	$graph_width=$img_width - $margins * 2;
	$graph_height=$img_height - $margins * 2; 
	$img=imagecreate($img_width,$img_height);

 
	$bar_width=20;
	$total_bars=count($values);
	$gap= ($graph_width- $total_bars * $bar_width ) / ($total_bars +1);

 
	# -------  Define Colors ----------------
	$bar_color=imagecolorallocate($img,0,64,128);
	$background_color=imagecolorallocate($img,240,240,255);
	$border_color=imagecolorallocate($img,200,200,200);
	$line_color=imagecolorallocate($img,220,220,220);
 
	# ------ Create the border around the graph ------

	imagefilledrectangle($img,1,1,$img_width-2,$img_height-2,$border_color);
	imagefilledrectangle($img,$margins,$margins,$img_width-1-$margins,$img_height-1-$margins,$background_color);

 
	# ------- Max value is required to adjust the scale	-------
	$max_value=max($values);
	$ratio= $graph_height/$max_value;

 
	# -------- Create scale and draw horizontal lines  --------
	$horizontal_lines=20;
	$horizontal_gap=$graph_height/$horizontal_lines;

	for($i=1;$i<=$horizontal_lines;$i++){
		$y=$img_height - $margins - $horizontal_gap * $i ;
		imageline($img,$margins,$y,$img_width-$margins,$y,$line_color);
		$v=intval($horizontal_gap * $i /$ratio);
		imagestring($img,0,5,$y-5,$v,$bar_color);

	}
 
 
	# ----------- Draw the bars here ------
	for($i=0;$i< $total_bars; $i++){ 
		# ------ Extract key and value pair from the current pointer position
		list($key,$value)=each($values); 
		$x1= $margins + $gap + $i * ($gap+$bar_width) ;
		$x2= $x1 + $bar_width; 
		$y1=$margins +$graph_height- intval($value * $ratio) ;
		$y2=$img_height-$margins;
		imagestring($img,0,$x1+3,$y1-10,$value,$bar_color);
		imagestring($img,0,$x1+3,$img_height-15,$key,$bar_color);		
		imagefilledrectangle($img,$x1,$y1,$x2,$y2,$bar_color);
	}
	header("Content-type:image/png");
	imagepng($img);

?>
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.