Reading XML with PHP

Question

I am testing out some things with reading XML using PHP. The below is a sample of the XML File:

<?xml version="1.0" encoding="UTF-8" ?>
<BroadcastData creationDate="20140326085217">
<ScheduleData>
<ChannelPeriod beginTime="20140326090000" endTime="20140402044500">
<ChannelId>Rai Uno</ChannelId>
<Event beginTime="20140326090000" duration="1800">
<EventId>260852180006</EventId>
<EventType>P</EventType>
<EpgProduction>
<EpgText language="eng">
<Name>Unomattina storie vere</Name>
</EpgText>
</EpgProduction>
</Event>
<Event beginTime="20140326093000" duration="1500">
<EventId>260852180007</EventId>
<EventType>P</EventType>
<EpgProduction>
<EpgText language="eng">
<Name>Unomattina Verde</Name>
</EpgText>
</EpgProduction>
</Event>

This is the PHP Script I built, however notthing is showing on when I run the PHP file.

<?php 

$completeurl ="test.xml";
$xml = simplexml_load_file($completeurl);

$info = $xml->BroadcastData->ScheduleData->ChannelPeriod->ChannelId;

for ($i = 0; $i++) {
$begintime = $info[$i]->Event->attributes()->beginTime;


echo "<p>Channel: ".$info."<br/>"."Begin Time: ".$begintime."</p>";
}



?>

Many thanks for your help guys !

for ($i = 0; $i > 0; $i++) { ... do you think that loop will ever start? :) — Ja͢ck
– Ja͢ck, Commented Mar 26, 2014 at 8:49
Hi @Jack, I've amnded the for loop like this, however still it is not working: for ($i = 0; $i++) { $begintime = $info[$i]->Event->attributes()->beginTime; echo "<p>Channel: ".$info."<br/>"."Begin Time: ".$begintime."</p>"; } — RCB
– RCB, Commented Mar 26, 2014 at 8:53

Ja͢ck · Accepted Answer · 2014-03-26 09:45:46Z

1

You should iterate over each channel period rather than channel id (which is a sub element anyway):

$doc = simplexml_load_file($completeurl);

foreach ($doc->ScheduleData->ChannelPeriod as $channelPeriod) {
    $channelId = (string)$channelPeriod->ChannelId;

    foreach ($channelPeriod->Event as $event) {
        $beginTime = $event['beginTime'];

        printf('<p>Channel: %s<br />Begin Time: %s</p>', $channelId, $beginTime);
    }
}

edited Mar 26, 2014 at 9:45

answered Mar 26, 2014 at 8:55

Ja͢ck

174k39 gold badges269 silver badges317 bronze badges

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

5 Comments

RCB Over a year ago

Many thanks for your help @jack, I have amneded the code as follows but for some reason it is still not outputting anything:

<?php    if (file_exists('test.xml')) {     $xml = simplexml_load_file('test.xml'); } else {     exit('Failed to open test.xml.'); }  $doc = simplexml_load_string($xml);  foreach ($doc->ScheduleData->ChannelPeriod as $channelPeriod) {     $channelId = (string)$channelPeriod->ChannelId;      foreach ($channelPeriod->Event as $event) {         $beginTime = $event['beginTime'];          printf('<p>Channel: %s<br />Begin Time: %s</p>', $channelId, $beginTime);     } }  ?>

Ja͢ck Over a year ago

I've tested my code on your partial XML and it works just fine.

RCB Over a year ago

Can you kindly provide me with the full code you used so I can replicate as it doesn't want to work, I am using mamp to test

Ja͢ck Over a year ago

@user3025379 I used simplexml_load_string(), so you just need to replace that with simplexml_load_file().

RCB Over a year ago

ooooooo sorry didn't notice that change, I apologies. Code is working fine. Many Thanks !. Can I use the same code to post the content into a mysql database rather then output to an HTML ?

Sagar Rabadiya · Accepted Answer · 2014-03-26 10:20:07Z

0

use following function to convert the xml string into array

  json_decode(json_encode((array)simplexml_load_string($sXML)),1);

answered Mar 26, 2014 at 10:20

Sagar Rabadiya

4,3211 gold badge24 silver badges28 bronze badges

Collectives™ on Stack Overflow

Reading XML with PHP

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related