<?php
//We've included ../Includes/FusionCharts.php and ../Includes/DBConn.php, which contains
//functions to help us easily embed the charts and connect to a database.
include("../Includes/FusionCharts.php");
include("../Includes/DBConn.php");
?>
<HTML>
<HEAD>
<TITLE>
FusionCharts - Database and Drill-Down Example
</TITLE>
<?php
//You need to include the following JS file, if you intend to embed the chart using JavaScript.
//Embedding using JavaScripts avoids the "Click to Activate..." issue in Internet Explorer
//When you make your own charts, make sure that the path to this JS file is correct. Else, you would get JavaScript errors.
?>
<SCRIPT LANGUAGE="Javascript" SRC="../../FusionCharts/FusionCharts.js"></SCRIPT>
<style type="text/css">
<!--
body {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
background-image: url(../../../images/bg.gif);
}
.text{
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
}
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874"></HEAD>
<BODY>
<CENTER>
<h2>ปปปปปปปป</h2>
<h4> </h4>
<?php
//In this example, we show how to connect FusionCharts to a database.
//For the sake of ease, we've used an MySQL databases containing two
//tables.
// Connect to the DB
$link = connectToDB();
//We also keep a flag to specify whether we've to animate the chart or not.
//If the user is viewing the detailed chart and comes back to this page, he shouldn't
//see the animation again.
$animateChart = $_GET['animate'];
//Set default value of 1
if ($animateChart=="")
$animateChart = "1";
//$strXML will be used to store the entire XML document generated
//Generate the chart element
$strXML = "<chart caption=xxxxxxxxxxxx' subCaption='จำแนกตาม ปริมาณ' pieSliceDepth='30' showBorder='1' formatNumberScale='0' numberSuffix=' รายการ' animation=' " . $animateChart . "'>";
// Fetch all factory records
// $strQuery = "select * from Factory_Master";
// $result = mysql_query($strQuery) or die(mysql_error());
$strQuery = "select sub_risk_kind.kind_sub_name AS type_name,risk_level,count(*) as count from new_risk LEFT JOIN sub_risk_kind ON sub_risk_kind.kind_sub_name = new_risk.risk_level group by new_risk.risk_level ";
$result2 = mysql_query($strQuery) or die(mysql_error());
//Iterate through each factory
if ($result2) {
while($ors2 = mysql_fetch_array($result2)) {
$strXML .= "<set label='" . $ors2['type_name'] . "' value='" . $ors2['count'] . "' />";
}
}
mysql_close($link);
//Finally, close <chart> element
$strXML .= "</chart>";
//Create the chart - Pie 3D Chart with data from strXML
echo renderChart("../../FusionCharts/Column3D.swf", "", $strXML, "FactorySum", 700, 400, false, false);
?>
<BR><BR>
</CENTER>
</BODY>
</HTML>
ถ้าคุณจะใช้ปุ่ม ในการส่งไปอีกหน้า ก็ใช้การส่งแบบ post ครับ เปลี่ยนที่ method ของ from จาก get เป็น post
แล้วไปที่อีกหน้า ก็ใช้ตัวแปร post เอาได้เลยครับ
Load balance : Server 00
