你好,这是我第一次在这里发东西,已经在这工作了几天,但没有运气。基本上我在php查询数据库,得到我的答案,但我想把这个答案发送到一个XML文件的图形创建。任何帮助都将非常感激。
这是PHP文件中嵌入sql返回变量的部分。
$result = mysqli_query($con,
"SELECT COUNT(*) as FullCount
FROM DailyShpm
WHERE (curr_date between '2013-01-01' and now()- INTERVAL 1 YEAR)
AND (Product= 'AE')
");
while($row = mysqli_fetch_array($result)) {
echo $row['FullCount'] ;
echo "<- Full results for total AE to date for 2013";
echo "<br>";
echo $row['FullCount'] ;
echo "<br>";
$files ="data.xml";
//load xml object
$xml= simplexml_load_file($files);
//assign value
$xml->set->value = $row['FullCount'];
//$xml->chart ->set = $row['FullCount'];
//store the value into the file
file_put_contents($file, $xml->asXML());
}
下面是它在xml文件
中的输出<?xml version="1.0" encoding="ISO-8859-1"?>
<chart caption="Year to Date" xAxisName="Year" yAxisName="Amount of Shipments Air Exports">
<set label="2013" value=""><value>7707</value></set>
<set label="2014" value=""/>
我需要将7707的值放入set label="2013" value"7707"中的值
Thanks in advance
修改以下内容:
$xml->set->value = $row['FullCount'];
:
$xml->attributes()->value = ((string) $xml->attributes()->value) . $row['FullCount'];