PHP using xpath output

Question

I just started playing with xpath and need some help.

I'm using tvdb's api and have the following xml (shortened for the question)

<Data>
   <Episode>
      <id>4762752</id>
      <EpisodeName>I.</EpisodeName>
      <EpisodeNumber>1</EpisodeNumber>
      <SeasonNumber>1</SeasonNumber>
   </Episode>
   <Episode>
      <id>4762756</id>
      <EpisodeName>II.</EpisodeName>
      <EpisodeNumber>2</EpisodeNumber>
      <SeasonNumber>1</SeasonNumber>
   </Episode>
</Data>

I want to get all the Episode details where episode number = something and season number is equal to something.

I think I have the xpath query correct but I cannot (or do not know how to) access the data after.

My code so far:

$tvdbSeriesData = simplexml_load_file($tvdbSeriesFeed);

$tvdbEpisodes = $tvdbSeriesData->xpath("//Data/Episode[SeasonNumber/text() = '$seasonNumber'][EpisodeNumber/text() = '$episodeNumber']");

echo $tvdbEpisodes->id;

This is my first try with xpath, so apologies if this is trivial, but could someone throw me in the right direction or explain to me what I've done wrong here.

Thanks

It's look like working fine if you try print_r($tvdbEpisodes); — Quynh Nguyen
– Quynh Nguyen, Commented Aug 1, 2016 at 21:14

Dekel · Accepted Answer · 2016-08-01 21:11:24Z

The xpath function returns Array with the results of your xpath query:

$tvdbSeriesFeed = '<Data>
   <Episode>
      <id>4762752</id>
      <EpisodeName>I.</EpisodeName>
      <EpisodeNumber>1</EpisodeNumber>
      <SeasonNumber>1</SeasonNumber>
   </Episode>
   <Episode>
      <id>4762756</id>
      <EpisodeName>II.</EpisodeName>
      <EpisodeNumber>2</EpisodeNumber>
      <SeasonNumber>1</SeasonNumber>
   </Episode>
</Data>';

$tvdbSeriesData = simplexml_load_string($tvdbSeriesFeed);
$seasonNumber = 1;
$episodeNumber = 1;
$tvdbEpisodes = $tvdbSeriesData->xpath("//Data/Episode[SeasonNumber/text() = '$seasonNumber'][EpisodeNumber/text() = '$episodeNumber']");

echo $tvdbEpisodes[0]->id; // 4762752

I used the function simplexml_load_string only for the example to work.

You can also var_dump the results:

var_dump($tvdbEpisodes);

Will output:

array(1) {
  [0] =>
  class SimpleXMLElement#3 (4) {
    public $id =>
    string(7) "4762752"
    public $EpisodeName =>
    string(2) "I."
    public $EpisodeNumber =>
    string(1) "1"
    public $SeasonNumber =>
    string(1) "1"
  }
}

Collectives™ on Stack Overflow

PHP using xpath output

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