 |
|

Code เขียนกราฟครับ ดึงข้อมูลจาก DB ครับ
Code (PHP)
<?php
require_once ('../jpgraph-3.5.0b1/src/jpgraph.php');
require_once ('../jpgraph-3.5.0b1/src/jpgraph_bar.php');
require_once ('../jpgraph-3.5.0b1/src/jpgraph_line.php');
require_once ('../jpgraph-3.5.0b1/src/jpgraph_error.php');
$objConnect = mysql_connect("localhost","root","1234") or die ("Error connect to Database");
$objDB = mysql_select_db("db_iservice");
mysql_query("SET NAMES UTF8");
$strSQL = "SELECT part_a,SUM(fix_price_a) AS part_a FROM requests GROUP BY part_a";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$xdata = array();
$ydata = array();
while ($rs = mysql_fetch_array($objQuery)){
$xdata[] = $rs[part_a];
$ydata[] = $rs[fix_price_a];
}
//สร้างกราฟ
$graph = new Graph(960,2000);
$graph->SetMargin(40,70,20,40);
$graph->SetScale("textlin");
$graph->SetShadow();
$graph->SetColor(array(250,250,250));
$graph->img->SetTransparent("white");
//สร้าง bar plot
$bplot = new BarPlot($xdata);
$bplot->SetFillColor("orange");
$bplot->SetLegend("result");
//เพิ่ม plot ไปในกราฟ
$graph->Add($bplot);
//สร้าง text
$txt = new Text('ทดสอบ');
$txt->SetPos(50,20);
$txt->SetColor('darkred');
$txt->SetFont(FF_ANGSA,FS_BOLD,15);
$txt->SetBox('white','navy','[email protected]');
$graph->AddText($txt);
$graph->title->Set("สรุปค่าใช้จ่ายทั้งหมด");
$graph->xaxis->title->Set("แกน X");
$graph->yaxis->title->Set("แกน Y");
$graph->title->SetFont(FF_ANGSA,FS_BOLD,20);
$graph->yaxis->title->SetFont(FF_ANGSA,FS_BOLD,20);
$graph->xaxis->title->SetFont(FF_ANGSA,FS_BOLD,20);
$graph->xaxis->SetTickLabels($ydata);
$graph->Stroke();
?>
Tag : PHP, MySQL, HTML/CSS
|
|
 |
 |
 |
 |
Date :
2014-03-12 13:51:43 |
By :
smith |
View :
730 |
Reply :
4 |
|
 |
 |
 |
 |
|
|
|
 |