dongluo1853 2013-07-20 17:17
浏览 34
已采纳

输出xml数组解析php重复六次[关闭]

I have a php file in this format:

<?php
$username = "root";
$password= "";
$db = "kamus1";
mysql_connect("localhost",$username,$password) or die("koneksi ke MySQL gagal");
mysql_select_db($db) or die ("koneksi ke dataBase gagal");

$doc = new DomDocument('1.0');
$root = $doc->createElement('movies');
$root = $doc->appendChild($root);
$arr = array();

//$query=mysql_query("select id,istilah,definisi from kamus_jaringan");
$query=mysql_query("select * from kamus_jaringan");
while($get_data = mysql_fetch_array($query))
{
foreach($get_data as $fieldname=>$fieldvalue)
{

$item = $doc->createElement('movie');
$item = $root->appendChild($item);
$item ->setAttribute("id",$get_data["id"]);
$item ->setAttribute("istilah",$get_data["istilah"]);
$item ->setAttribute("definisi",$get_data["definisi"]);
}
}
echo $doc->saveXML();
$doc->save("movies.xml");
?>

when this code is executed on the browser, the output of each of the data will be repeated up to six times. for example id, will repeat six times. I want the output to each of the data, only one time. please help

  • 写回答

1条回答 默认 最新

  • dongtui9168 2013-07-20 17:21
    关注

    First, don't use mysql_* functions, they are deprecated. Second, you have two loops and you only need one, change your code to this:

    while($get_data = mysql_fetch_array($query))
    {
        $item = $doc->createElement('movie');
        $item = $root->appendChild($item);
        $item ->setAttribute("id",$get_data["id"]);
        $item ->setAttribute("istilah",$get_data["istilah"]);
        $item ->setAttribute("definisi",$get_data["definisi"]);
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 12864只亮屏 不显示汉字
  • ¥20 三极管1000倍放大电路
  • ¥15 vscode报错如何解决
  • ¥15 前端vue CryptoJS Aes CBC加密后端java解密
  • ¥15 python随机森林对两个excel表格读取,shap报错
  • ¥15 基于STM32心率血氧监测(OLED显示)相关代码运行成功后烧录成功OLED显示屏不显示的原因是什么
  • ¥100 X轴为分离变量(因子变量),如何控制X轴每个分类变量的长度。
  • ¥30 求给定范围的全体素数p的(p-2)/p的连乘积值
  • ¥15 VFP如何使用阿里TTS实现文字转语音?
  • ¥100 需要跳转番茄畅听app的adb命令