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:
$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;
$leg = $row;
$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?
Adding 24HR time to a graph
1 reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users