Jump to content


Photo

Adding 24HR time to a graph


  • Please log in to reply
1 reply to this topic

#1 netfrugal

netfrugal
  • Members
  • PipPip
  • Member
  • 26 posts

Posted 24 March 2006 - 04:11 PM

Currently I've managed to create this graph with help from a tutorial on phpfreaks.
[img src=\"http://www.coachloanprocessing.com/download/bar-graph.gif\" border=\"0\" alt=\"IPB Image\" /]


Here is the code:

<?php
include ("c:/jpgraph/src/jpgraph.php");
include ("c:/jpgraph/src/jpgraph_bar.php");

$db = mysql_connect("localhost", "root","password") or die(mysql_error());

mysql_select_db("bar_graph",$db) or die(mysql_error());

$sql = mysql_query("SELECT * FROM employees") or die(mysql_error());

while($row = mysql_fetch_array($sql))
{
$data[] = $row[1];
$leg[] = $row[0];
}

$graph = new Graph(600,150,"auto");
$graph->SetScale("textint");
$graph->SetShadow();
$graph->Set90AndMargin(50,40,0,20);
$graph->xaxis->SetTickLabels($leg);

$bplot = new BarPlot($data);
$bplot->SetFillColor("lightgreen"); // Fill color
$bplot->value->Show();
$bplot->value->SetFont(FF_ARIAL,FS_BOLD);
$bplot->value->SetAngle(45);
$bplot->value->SetColor("black","navy");

$graph->Add($bplot);
$graph->Stroke();
?>

And here is the mysql table:
CREATE TABLE `employees` (`Name` varchar(50) default NULL, `Marks` int(11) default NULL);


What I want to do is replace the top numbers with 00:00 - 23:59 military time. And I need to make it look like this below:

[img src=\"http://www.coachloanprocessing.com/download/bar-graph2.gif\" border=\"0\" alt=\"IPB Image\" /]



Basically it is a time schedule to let me know when an employee is working during the day.

And so far the first example is as far as I can go without pulling my hair out.
Does anyone have any ideas how to change the code to reflect this?

thanks!

#2 trq

trq
  • Staff Alumni
  • Advanced Member
  • 31,041 posts

Posted 27 March 2006 - 12:41 PM

Um... Im sure you might get a response if you posted your question in a more appropriate forum.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users