 |
|
Code (PHP)
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Report For APC</title>
</head>
<body>
<p><img src="wallpaper3.jpg" width="1024" height="211" />
</p>
<p>
<?
mysql_connect("localhost","root","1234") or die(mysql_error());
mysql_select_db("apcreport");
mysql_query("SET NAMES UTF8");
?>
<form action="phpmydream1.php" method="post" name="form1">
รายการสินค้า<br>
<select name="lmName1">
<option value=""><-- กรุณาเลือกสินค้า --></option>
<?
$strSQL = "SELECT * FROM bcitemgroup1";
$objQuery = mysql_query($strSQL);
while($objResuut = mysql_fetch_array($objQuery))
{
?>
<option value="<?=$objResuut["code"];?>"><?=$objResuut["code"]." - ".$objResuut["Name"];?></option>
<?
}
?>
</select>
<input name="btnSubmit" type="submit" value="Submit"><br><br>
</form>
<?
$sql = "SELECT salecode,groupcode,SUM(NetAmount) AS sumprice FROM bcarinvoicesub WHERE groupcode='TO' GROUP BY salecode,groupcode";
$result = mysql_query($sql);
$sum = mysql_fetch_array($result);
include("C:\AppServ\www\phpmydream\JpGraph\src\jpgraph.php");
include("C:\AppServ\www\phpmydream\JpGraph\src\jpgraph_pie.php");
$g = new pieGraph(500,500);
$title = iconv("tis-620","utf-8","ซื้อสินค้า");
$g->title->set($title);
$g->title->setFont(FF_JASMINE,FS_BOLD,18);
$legends = array();
$data_graph = array();
while($data = mysql_fetch_array($result)){
$lg=iconv("tis-620","utf-8",$data['salecode']);
array_push($legends, $lg);
array_push($data_graph,$data['sumprice']);
}
$pie = new PiePlot($data_graph);
$pie->SetLegends($legends);
$g->Add($pie);
$g->Stroke();
?>
</p>
</body>
</html>
[font=Verdana]Database ค่ะ[/font]
กราฟที่ต้องการค่ะ
error ตัวใหญค่ะ
JpGraph Error: 15009 Illegal pie plot. Sum of all data is zero for Pie Plot
Tag : PHP, MySQL
|
|
|
 |
 |
 |
 |
| Date :
2011-09-28 11:18:11 |
By :
confusion |
View :
2259 |
Reply :
10 |
|
 |
 |
 |
 |
|
|
|
|
 |
