netfrugal Posted March 24, 2006 Share Posted March 24, 2006 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! Link to comment https://forums.phpfreaks.com/topic/5693-adding-24hr-time-to-a-graph/ Share on other sites More sharing options...
trq Posted March 27, 2006 Share Posted March 27, 2006 Um... Im sure you might get a response if you posted your question in a more appropriate forum. Link to comment https://forums.phpfreaks.com/topic/5693-adding-24hr-time-to-a-graph/#findComment-21168 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.