Unable在使用图形时,从数据库获取数据到脚本标记 [英] Unable To fetch data from database to script tag while using graph
本文介绍了Unable在使用图形时,从数据库获取数据到脚本标记的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
plotOptions:{
column:{
pointPadding:0.2,
borderWidth:0
}
},
series:[{
name:'Not Completed',
data:[<?php echo json_encode($ TotalNotCompleted); ?>]
/ *这里如何编写查询以从数据库获取数据,使我的图表动态工作* /
},{
name:'Completed',
data:[<??php echo json_encode($ TotalCompleted); ?>]
}]
解决方案
p> plotOptions:{
column:{
pointPadding:0.2,
borderWidth:0
}
} [
< ;?
$ QueryTST = mysql_query(SELECT * FROM TotalCounterSales WHERE AdminCity ='$ City'AND AdminStore ='$ StoreNo'AND SalesDate ='$ TodaysDate')
while($ RowQTST = mysql_fetch_array($ QueryTST))
{
$ ProductNo = $ RowQTST ['ItemNo'];
$ QueryProductName = mysql_query(SELECT * FROM products WHERE PId ='$ ProductNo');
while($ RowQPN = mysql_fetch_array($ QueryProductName))
{
$ ProductName = $ RowQPN ['name'];
}
?>
{name:<?echo $ ProductName;?>,data:[<?echo $ RowQTST ['Quantity'];?>]},
<?} >
]
plotOptions: {
column: {
pointPadding: 0.2,
borderWidth: 0
}
},
series: [{
name: 'Not Completed',
data: [<?php echo json_encode($TotalNotCompleted); ?>]
/* here how to write query to fetch data from database, to make my graph work dynamically */
}, {
name: 'Completed',
data: [<?php echo json_encode($TotalCompleted); ?>]
}]
解决方案
plotOptions: {
column: {
pointPadding: 0.2,
borderWidth: 0
}
},
series: [
<?
$QueryTST=mysql_query("SELECT * FROM TotalCounterSales WHERE AdminCity='$City' AND AdminStore='$StoreNo' AND SalesDate='$TodaysDate'");
while($RowQTST=mysql_fetch_array($QueryTST))
{
$ProductNo=$RowQTST['ItemNo'];
$QueryProductName=mysql_query("SELECT * FROM products WHERE PId='$ProductNo' ");
while($RowQPN=mysql_fetch_array($QueryProductName))
{
$ProductName=$RowQPN['name'];
}
?>
{ name: "<?echo $ProductName;?>", data: [<?echo $RowQTST['Quantity'];?>]},
<?}?>
]
这篇关于Unable在使用图形时,从数据库获取数据到脚本标记的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文