PHP getting element from inside a list

2 comments

1. The output from it is:

   If the output is literally what you said, it’s not possible. I mean, I know that “Kraantje Pappie Nijdrop Opwijk” means that the artist is “Kraantje Pappie” and the location is “Nijdrop Opwijk”, but that’s because I’m Dutch and I happen to like “Kraantje Pappie”. Most other people wouldn’t even know where to split the string, so how do you want to tell your computer how to it?

   If the result is coming from the database, perhaps you can request it differently?

   UPDATE:

   Since the comments suggest that i should put some kind of structure in i used a var_dump on the values with the <p id=""> </p> and the output is

   Those linebreaks change everything. You can now operate under the assumption that there’s a pattern in the string: artist, break, location, break, date, break. If there’s a pattern, you can use that. Assuming that’s a format you’re always getting, you can do this quite simply:

   <?php
   $output = 'Sioen 
   
   De Zwerver leffinge
   
   24/03/2012 
   
   Nathan
   
   The zydeco Cha-Chas n9 Eeklo 
   
   24/03/2012 
   
   Kraantje Pappie 
   
   Nijdrop Opwijk 
   
   24/03/2012';
   
   /**
    * Remove empty lines.
    */
   $lines = array_map( 'trim', array_filter( explode( "n", $output ) ) );
   
   /**
    * This is for saving the values temporarily.
    */
   $i = 0;
   $entries = array( );
   $current = array( );
   
   /**
    * Loop through all the entries.
    */
   foreach( $lines as $line ) {
       /**
        * Add the current line to the current entry.
        */
       $current[] = $line;
   
       /**
        * If $i == 2, that was the date. Add $current to the stack, and reset it's contents.
        */
       if( $i ++ === 2 ) {
           $entries[] = $current;
           $current = array( );
           $i = 0;
       }
   }
   
   /**
    * Build XML root.
    */
   $concerts = new SimpleXmlElement( '<concerts></concerts>' );
   
   /**
    * Append each entry as a concert.
    */
   foreach( $entries as $entry ) {
       $concert = $concerts->addChild( 'concert' );
   
       $concert->addChild( 'artist', array_shift( $entry ) );  
       $concert->addChild( 'location', array_shift( $entry ) );    
       $concert->addChild( 'date', array_shift( $entry ) );    
   }
   
   /**
    * Output, finally.
    */
   var_dump( $concerts->asXml( ) );
   

   That results in the following output:

   <?xml version="1.0"?>
   <concerts>
       <concert>
           <artist>Sioen</artist>
           <location>De Zwerver leffinge</location>
           <date>24/03/2012</date>
       </concert>
       <concert>
           <artist>Nathan</artist>
           <location>The zydeco Cha-Chas n9 Eeklo</location>
           <date>24/03/2012</date>
       </concert>
       <concert>
           <artist>Kraantje Pappie</artist>
           <location>Nijdrop Opwijk</location>
           <date>24/03/2012</date>
       </concert>
   </concerts>
   

   Log in to Reply

2. If you need to get the content put them in divs with numeric ids i.e.

   <div id='1'>Sportpaleis-Antwerpen-25/02/2012</div>
   <div id='2'>Sioen-De Zwerver leffinge-24/03/2012</div>
   

   Now when you get the data, use the php function html_entity_decode find the total divs in the text by php function and then loop them to get the result.

   You may seperate them by – to get three different parts of a div.

   Log in to Reply