 |
|
ไม่รู้ผิดตรงไหนค่ะ
Code (PHP)
<?php
$objConnect = mysql_connect("localhost","root","1234") or die(mysql_error());
$objDB = mysql_select_db("mydatabase");
$strSQL = "SELECT * FROM customer";
$objQuery = mysql_query($strSQL) or die (mysql_error());
$resultArray = array();
?>
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript">
google.load("visualization", "1", {packages:["corechart"]});
google.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable([
['Year', 'square'],
<?php
while($obResult = mysql_fetch_array($objQuery))
{
array_push($resultArray,$obResult);
//echo $obResult['Name'];
echo "['".$obResult['Name']."',".$obResult['Budget']."],";
}
?>
]);
var options = {
title: 'Model',
vAxis: {title: "square metre"},
width: data.getNumberOfRows() * 65,
bar: {groupWidth: 35},
tooltip: {textStyle: {color: '#3C6A9D'}, showColorCode: true},
chartArea : {left:80,top:60,width:"80%", height: "60%"}
};
var chart = new google.visualization.ColumnChart(document.getElementById('chart_div'));
chart.draw(data, options);
}
</script>
<div class="chart_div " id="chart_div"></div>
Tag : HTML/CSS, JavaScript
|
ประวัติการแก้ไข 2013-05-23 10:58:08
|
 |
 |
 |
 |
Date :
2013-05-23 10:57:26 |
By :
nongtoom |
View :
5788 |
Reply :
8 |
|
 |
 |
 |
 |
|
|
|
 |