Parsing XML with php to Array

Question

I've tried to parse a XML String with php.

The example of XML is

<?xml version="1.0"?>
<root>
    <Log>
        <Item>
            <name>![CDATA[James]]</name>
            <address>![CDATA[Korea]]</address>
            <email>![CDATA[[email protected]]]</email>
        </Item>
        <Item>
            <name>![CDATA[James2]]</name>
            <address>![CDATA[Korea2]]</address>
            <email>![CDATA[[email protected]]]</email>
        </Item>
    </Log>
</root>

My Parsing PHP Code is

$xml = simplexml_load_string($input,null,LIBXML_NOCDATA);
$xml=json_decode( json_encode( $xml),true);

However, When I try to get sizeof($xml['Log']['Item']), have some problems.

If XML have One 'Item' , then sizeof($xml['Log']['Item']) return '3' .

but If XML have 4 'Item's , then it return '4'.

I want to return 1, if XML have One 'Item'.

How can I solve this problem.?

don't you need to do sizeof($xml['root']['Log']['Item'])?

Memor-X
– Memor-X

2015-12-03 03:12:58 +00:00
Commented Dec 3, 2015 at 3:12 — Memor-X
– Memor-X, Commented Dec 3, 2015 at 3:12
this is test code for DB insert..

lucidmaj7
– lucidmaj7

2015-12-03 03:58:06 +00:00
Commented Dec 3, 2015 at 3:58 — lucidmaj7
– lucidmaj7, Commented Dec 3, 2015 at 3:58
why not iterate the XML with foreach()?

michi
– michi

2015-12-03 10:47:56 +00:00
Commented Dec 3, 2015 at 10:47 — michi
– michi, Commented Dec 3, 2015 at 10:47
I solved it with foreach(). thanks for your comment.

lucidmaj7
– lucidmaj7

2015-12-03 13:05:42 +00:00
Commented Dec 3, 2015 at 13:05 — lucidmaj7
– lucidmaj7, Commented Dec 3, 2015 at 13:05

lucidmaj7 · Accepted Answer · 2015-12-03 13:03:56Z

1

I solved this parsing problem with foreach().

$xml = simplexml_load_string($input,null,LIBXML_NOCDATA);
$itemArray=$xml->Log->Item;
$i=0;
$sqlParamArray= array();
foreach ($itemArray as $tag) {
 $name= trim($tag->name);
 $address= trim($tag->address);
 $email= trim($tag->email);
  array_push($sqlParamArray,$name,$address,$email);
  $i++;
}
echo $i;

....

sizeof('Item') is saved in $i.

I solved it.

answered Dec 3, 2015 at 13:03

lucidmaj7

872 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Parsing XML with php to Array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related