this is the code
<?php
require_once("lib/phpchartdir.php");
$conexion=mysql_connect("localhost","root","1234");
mysql_select_db("velocidad",$conexion);
If (mysql_errno($conexion)!=0)
{ $mensaje= mysql_error($conexion);
Echo "$mensaje";
}
if(isset($_REQUEST['lista1'])) {
$i=0;
$resul=mysql_query("SELECT Npagina, tiempo from stat_table order by tiempo desc",$conexion);
while ($fila=mysql_fetch_array($resul)) {
//$registro[] =$fila[0];
//$fecha[] =$fila[1];
//$velocidad[]=$fila[2];
$tiempo[] =$fila[3];
$Nom_pagina[]=$fila[4];
$labels[$i]= $fila[0];
$data[$i]= $fila[1];
$i++;
}
# The data for the bar chart
//$data = array("campos[0], campos[1], campos[2]");
# The labels for the bar chart
//$labels = array("campos[0], campos[1], campos[2]");
# Create a XYChart object of size 600 x 360 pixels
$c = new XYChart(600, 360);
# Add a title to the chart using 18pts Times Bold Italic font
$c->addTitle("VELOCIDAD", "timesbi.ttf", 18);
# Set the plotarea at (60, 40) and of size 500 x 280 pixels. Use a vertical gradient
# color from light blue (eeeeff) to deep blue (0000cc) as background. Set border and
# grid lines to white (ffffff).
$c->setPlotArea(60, 40, 500, 280, $c->linearGradientColor(60, 40, 60, 280, 0xeeeeff,
0x0000cc), -1, 0xffffff, 0xffffff);
# Add a multi-color bar chart layer using the supplied data. Use soft lighting effect
# with light direction from left.
$barLayerObj = $c->addBarLayer3($data);
$barLayerObj->setBorderColor(Transparent, softLighting(Left));
# Set x axis labels using the given labels
$c->xAxis->setLabels($labels);
# Draw the ticks between label positions (instead of at label positions)
$c->xAxis->setTickOffset(0.5);
# Add a title to the y axis with 10pts Arial Bold font
$c->yAxis->setTitle("Euros", "arialbd.ttf", 10);
# Set axis label style to 8pts Arial Bold
$c->xAxis->setLabelStyle("arialbd.ttf", 8);
$c->yAxis->setLabelStyle("arialbd.ttf", 8);
# Set axis line width to 2 pixels
$c->xAxis->setWidth(2);
$c->yAxis->setWidth(2);
# Output the chart
header("Content-type: image/png");
print($c->makeChart2(PNG));
}
?> |
Forum Home
Search
Message List
Post Message
help with DB