XML - parse 1

[vietboy505]

I was wondering how I can parse XML using PHP or Perl to output as a nice table & edit later?

If so, how would that work? I am a newbie.

 

[Vragabond]

Have you checked PHP's XML parser functions? It sounds like you could benefit from that.

 

[vietboy505]

I try to follow the example from http://search.cpan.org/~grantm/XML-Simple-2.14/lib/XML/Simple.pm"]XML Parse[/URL] with foo.

#!/usr/local/bin/perl

use XML::Simple;

my $ref = XMLin('foo.xml');

#also with my $ref = XMLin();

use Data::Dumper;

print Dumper($config);
print $config->{logdir};

where foo.xml

  <config logdir="/var/log/foo/" debugfile="/tmp/foo.debug">
    <server name="sahara" osname="solaris" osversion="2.6">
      <address>10.0.0.101</address>
      <address>10.0.1.101</address>
    </server>
    <server name="gobi" osname="irix" osversion="6.5">
      <address>10.0.0.102</address>
    </server>
    <server name="kalahari" osname="linux" osversion="2.0.34">
      <address>10.0.0.103</address>
      <address>10.0.1.103</address>
    </server>
  </config>

I try to test out foo.pl and get
$VAR1 = undef;
Why is that, it doesn't match the one with from the web.

 

[jpadie]

are you asking a question about why your perl script does not work? if so - better to ask in the perl forum, i'd guess.

i can't help feeling that you're using element attributes as data values too. i don't think that's great xml strategy. would not the following be more normal?:

    <server>
      <server_name>
        sahara
      </server_name>
      <osname>
        solaris
      </osname>
      <osversion>
        2.6
      </osversion>
      <addresses>
        <address>
         10.0.0.101
        </address>
        <address>
         10.0.1.101
        </address>
      <addresses>
    </server>