Jump to content


Adding 24HR time to a graph

  • Please log in to reply
1 reply to this topic

#1 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:

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");

$bplot = new BarPlot($data);
$bplot->SetFillColor("lightgreen"); // Fill color


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?


#2 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