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 关于#Mybatis#的问题:怎么办重复数据如下"KSDM":37,"KSMC":"呼吸内科门诊","ksdm":37,"ksmc":"呼吸内科门诊"xml文件填写
  • ¥40 servlet的web程序部署出错
  • ¥50 activiti 新建流程系列问题
  • ¥50 为什么我版本升级之后运行速度变慢5倍??
  • ¥15 如何在gazebo中加载机械臂和机械手
  • ¥15 纯运放实现隔离采样方案设计
  • ¥20 easyconnect无法连接后缀带.com的网站,一直显示找不到服务器ip地址,但是带有数字的网站又是可以连接上的,如何解决
  • ¥15 电脑开机过商标后就直接这样,求解各位
  • ¥15 mysql , 用自己创建的本地主机和用户名 登录不上
  • ¥15 关于#web项目#的问题,请各位专家解答!