gpt4 book ai didi

javascript - 在xml中调用php变量

转载 作者:行者123 更新时间:2023-11-29 12:57:40 26 4
gpt4 key购买 nike

我想使用 xml 文件制作一些图表并使用 javascript 调用图表,但是我在 Data.php 中遇到问题(包含 php 和 xml 来构建图表)。这是我的代码:

<?php require_once('../../Connections/edb.php'); ?>
<?php
mysql_select_db($db, $edb) or die(mysql_error());

$parlimen[] = "Segamat";
$parlimen[] = "Sekijang";
$parlimen[] = "Labis";


foreach ($parlimen as $p){
$count = mysql_query("SELECT COUNT(*) FROM tbl_ahli WHERE parlimen = '".$p."' AND status='Perwakilan'");
$result = mysql_fetch_assoc($count) or die(mysql_error());
//print $result['COUNT(*)'];
//the result some thing like
//for three loop 100,
//if I print like this :
//print $p." = ".$result100['COUNT(*)']."<br/>" or die(mysql_error()) ;
//the result will be like this
// Segamat = 1
// Sekijang = 0
// Labis = 0
}
?>

这是我的 PHP 代码,其中包含我的 XML 代码:

<?php
header("Content-type: text/xml");
echo "<chart caption='Weekly Sales Summary for two Products' xAxisName='Weeks' yAxisName='Amount' yAxisMinValue='0' yAxisMaxValue='500' adjustDiv='0' numDivLines='9'> ";
echo "<categories>";
echo "<category Label=\"Segamat\"/>";
echo "<category Label=\"Sekijang\"/>";
echo "<category Label=\"Labis\"/>";
echo "</categories>";
echo "<dataset seriesName=\"Product A\">";
echo "<set value='$result' /> ";
echo "<set value='$result' /> ";
echo "<set value='$result' /> ";
echo "</dataset>";
echo "</chart>";
?>

我用相同的文件名Data.php制作这两个代码,我在php中制作xml。我在将查询结果提交到 xml 时遇到问题

这是我调用 Data.php 和图表的 javascript

<body>     
<div id="chartContainer">FusionCharts XT will load here!</div>
<script type="text/javascript"><!--

var myChart = new FusionCharts( "MSColumn3D.swf",
"myChartId", "400", "300", "0" );
myChart.setXMLUrl("Data.php");

myChart.render("chartContainer");

// -->
</script>

最佳答案

答案是:

<?php
header("Content-type: text/xml");
echo "<chart caption='Bilangan Ahli Mengikut Parlimen' xAxisName='Parlimen' yAxisName='Jumlah(Orang)' yAxisMinValue='0' yAxisMaxValue='500' adjustDiv='0' numDivLines='9' canvasbgcolor='#FFFFFF' canvasbasecolor='#CCCCCC' showcanvasbg='1' palettecolors='#008ee4,#6baa01,#f8bd19,#e44a00,#33bdda' divlinecolor='#CCCCCC' divlinealpha='70' useroundedges='1'> ";

foreach ($parlimen as $p){
$count = mysql_query("SELECT COUNT(*) FROM tbl_ahli WHERE parlimen = '".$p."' AND status='Perwakilan'");
$result = mysql_fetch_assoc($count) or die(mysql_error());
echo "<set label=\"".$p."\" value=\"".$result['COUNT(*)']."\" />";
}
echo "</chart>";

关于javascript - 在xml中调用php变量,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/23796785/

26 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com