How do i parse this XML file?

@bbq1Jul 19.2019

I have tried for so long to understand this XML file to parse it but I cant make it.

[CODE] <?xml version=”1.0″ encoding=”ISO-8859-1″?> <se:List xmlns:se=”http://www.”> <se:Event timestamp=”2019-07-01 10:56:19″> <se:Date endcet=”2019-07-02″ endutc=”2019-07-01″ startcet=”2019-07-02″ startutc=”2019-07-01″ weekdaycet=”1″ weekdayutc=”1″ weeknocet=”27″ weeknoutc=”27″/> <se:StartTime endcet=”01:25:00″ endutc=”23:25:00″ startcet=”00:40:00″ startutc=”22:40:00″/> </se:Event> <se:Event timestamp=”2019-07-01 10:56:20″> <se:Date endcet=”2019-07-02″ endutc=”2019-07-01″ startcet=”2019-07-02″ startutc=”2019-07-01″ weekdaycet=”1″ weekdayutc=”1″ weeknocet=”27″ weeknoutc=”27″/> <se:StartTime endcet=”01:55:00″ endutc=”23:55:00″ startcet=”01:25:00″ startutc=”23:25:00″/> </se:Event> </se:List> [/CODE]

[CODE] $xml = simplexml_load_file(‘file.xml’); print_r($xml); [/CODE]

gives the result:
**SimpleXMLElement Object ( )**
I have no idea where to go from there

to post a comment

PHP

14 Comments(s) _↴

@ginerjmJul 19.2019 — #It didn't give you anything more than that heading? Are you sure you pointed to the right place/file? And that it is not empty?

The php manual shows an example of exactly what you did and the result of that shows the element that the sample xml file contained. So .....

@bbq1authorJul 19.2019 — #@ginerjm#1606501 no it didnt give me anything more than that. I am 100% sure i pointed to the correct file and the file got over 1000 lines of xml

if I do

[CODE]
 $xml = simplexml_load_file('file.xml');
 print_r($xml[0]);
 [/CODE]

I get:

**SimpleXMLElement Object ( )**

if I do

[CODE]
 $xml = simplexml_load_file('file.xml');
 print_r($xml[1]);
 [/CODE]

I get:

**Warning: main(): Cannot add element List number 1 when only 0 such elements exist in ... ...

SimpleXMLElement Object ( )**

so the data is there....but its not?

@ginerjmJul 19.2019 — #No. It says there are "0 such elements". Sounds 'empty' to me. What happens if you just read in the file as if it were a text file and dump that?

And how about a test on the filename with "if (is_file('file.xml')....."

@bbq1authorJul 19.2019 — #@ginerjm#1606504 do you mean **var_dump(file_get_contents('file.xml'));** ? that gives me **string(1968395) " "**

doing

[CODE]
 if (file_exists('file.xml')) {
 echo "The file exists";
 } else {
 echo "The file does not exist";
 }
 [/CODE]

outputs "The file exists"

@ginerjmJul 19.2019 — #OK. We ruled out error #1.

How about breaking up that line of code into distinct operations?

PS - How big is this xml file? IE, size in bytes/kb/mb.

@bbq1authorJul 19.2019 — #@ginerjm#1606507 what do you mean? I am pretty bad with php

If doing gettype on $xml it says Object

doing strlen on $xml gives 2239

i added an "or die" which does actually point me to the "error"...this is very weird to me

[CODE]
 $xml = simplexml_load_file('file.xml') or die('error');
 [/CODE]

the file is very big. 1.88MB

@ginerjmJul 19.2019 — #Aha! In the directory listing can you give a better number for its size in bytes? I'm comparing it to that number you showed earlier. Approx. 1.92 mb.

@bbq1authorJul 19.2019 — #@ginerjm#1606509 1 968 395 byte. 1 974 272 byte on disk

@ginerjmJul 19.2019 — #See? That's the same number you got earlier when you combined the read and the dump.

<i>
 </i>$data = file_get_contents('file_xml');
 var_dump($data);

This is what I meant by using distinct operations.

@ginerjmJul 19.2019 — #So? What happens when you do those two lines of code? I'm hoping you get some real output instead of just a filesize again.

@SempervivumJul 19.2019 — #I struggled some time and finally found this:

https://stackoverflow.com/questions/1575788/php-library-for-parsing-xml-with-a-colons-in-tag-names

This code:

`var_dump($xml->children('se', true));

</C><br/>
 gives a meaningful output for your example.<br/>
 You can then access attributes this way:<br/>
 <C>

var_dump($xml->children('se', true)->Event[0]->Date->attributes()->endcet);`

@ginerjmJul 19.2019 — #Does that solve your problem? Cause it didn't solve mine.

@bbq1authorJul 19.2019 — #@Sempervivum#1606513 @ginerjm#1606514 yes that worked for me! thanks alot both of you

and FYI giner. that did only output **string(1968395) " "**

@ginerjmJul 19.2019 — #Interesting that it produces the file size but no message as to not being a proper tool to look at the file with.

Also in #PHP _↴

MySQL Joined Search PHP error when dealing with classes Public key encryption between JS and PHP. Completely lost - need help

Success!

Help @bbq1 spread the word by sharing this article on Twitter...

Tweet This

How do i parse this XML file?

14 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

How do i parse this XML file?

14 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

14 Comments(s) _↴

Also in #PHP _↴