Hey everyone, hopefully someone can help me out. I am building an iphone app and doing some web scraping to get an array of data. I am then using SimpleXML to parse it and save it as an XML file which will then be imported into the iPhone app for use in a tableview....it's nothing more than a team schedule.

My array is large (about 120 nodes each with subnodes). Basically I want to structure the XML like this...

<Schedule>
   <Month name="October 2009">
      <Game>
          <Date>
          <HomeTeam>
          <AwayTeam>
          <Time>
          <Result>
      </Game>
   </Month
</Schedule>

The way the array is, you almost have to know what node the November, December, etc. nodes are (for example)....

$arr = Array
(
  '0' => Array( '0' => 'October 2009', ),
  '1' => Array( '0' => 'Date',
                '1' => 'Visitor',
                '2' => 'Home',
                '3' => 'Time (ET)',
                '4' => 'TV Network/Results', ),
  '2' => Array( '0' => 'Fri Oct 2, 2009',
                '1' => 'Away Team',
                '2' => 'Home Team',
                '3' => '7:30 PM',
                '4' => 'Away Team (2) Home Team (4)',
                '5' => '', ),
  '3' => Array( '0' => 'Sat Oct 3, 2009',
                '1' => 'Away Team-3',
                '2' => 'Home Team-3',
                '3' => '11:30 AM',
                '4' => 'Away Team (3) Home Team (0)',
                '5' => '', ),
  '4' => Array( '0' => 'Sun Oct 4, 2009',
                '1' => 'Away Team-4',
                '2' => 'Home Team-4',
                '3' => '1:30 PM',
                '4' => 'Away Team (1) Home Team (16)',
                '5' => '', ),
  '5' => Array( '0' => 'November 2009', ),
  '6' => Array( '0' => 'Fri Nov 2, 2009',
                '1' => 'Away Team',
                '2' => 'Home Team',
                '3' => '7:30 PM',
                '4' => 'Away Team (2) Home Team (4)',
                '5' => '', ),
  '7' => Array( '0' => 'Sat Nov 3, 2009',
                '1' => 'Away Team-3',
                '2' => 'Home Team-3',
                '3' => '11:30 AM',
                '4' => 'Away Team (3) Home Team (0)',
                '5' => '', ),
  '8' => Array( '0' => 'Sun Nov 4, 2009',
                '1' => 'Away Team-4',
                '2' => 'Home Team-4',
                '3' => '1:30 PM',
                '4' => 'Away Team (1) Home Team (16)',
                '5' => '', ),

);

I can almost get it to work, I just can't figure out how to use switch or if statements to say for example IF the node is equal to 5, make a new <Month> tag and set the name attribute to whatever the value of $arr[5][0]. The code below just adds all the games under the October <Month> tag, but where the data for $arr[5] is for instance just disappears. Then at the end of all the <Game> tags, the code just adds closing </Month> tags. Really irritating haha.

Sorry for long post, but need some help and would really appreciate it! Thanks!

// print_r($arr); 

$xml  = '<?xml version="1.0" encoding="UTF-8"?>'; 
$xml .= " 
<Schedule> 

</Schedule>"; 

$obj = new SimpleXMLElement($xml); 

//$obj->Month["name"] = $arr[0][0]; 

foreach ($arr as $ptr => $nothing) 
{ 
    if ($ptr == 0) 
    { 
        $Month = $obj->addChild('Month'); 
        $Month->addAttribute('Name', $arr[$ptr][0]); 
    } 

if ($ptr == 1) 
{ 
    continue; 
} 

else if($ptr == 16) 
{ 
    $Month = $obj->parent->addChild('Month'); 
    $Month->addAttribute('Name', $arr[$ptr][0]); 

} 

else 
{ 


    $game = $obj->Month->addChild('Game'); 
    $game->addChild('Date',    $arr[$ptr][0]); 
    $game->addChild('Visitor', $arr[$ptr][1]); 
    $game->addChild('Home',    $arr[$ptr][2]); 
    $game->addChild('Time',    $arr[$ptr][3]); 
    $game->addChild('Results', $arr[$ptr][4]); 
} 
} 

$new = $obj->asXML(); 

$new = str_replace('><', ">\n<", $new); 
$new = str_replace('&nbsp', "", $new); 
$dom = new DOMDocument('1.0'); 
$dom->preserveWhiteSpace = true; 
$dom->formatOutput = true; 
$dom->loadXML($new); 
echo $dom->saveXML(); 
$dom->save("Schedule.xml");

    I recommend you build your array in an easily parseable format

    $arr = Array(
	Array(
		'date' => 'October, 2009',
		'games' => Array(
			Array(
				'Date' => 'Fri Oct 2, 2009',
				'Visitor' => 'Away Team',
				...
			),
			Array('Date' => ...
			)
		)
	),
	Array(
		'date' => 'November, 2009',
		'games' => Array(...)
	)
)
      7 days later

      just thinking outloud... you can do a foreach on the entire array... in that check the count of each sub-array and if its == 1 then you know your at a monthly break... between that condition is each game for that month

      foreach ($arr as $dates)
{
     if(count($dates)==1)
     {
     //NEW MONTH TAG
     }
     else
     {
     //PROCESS OTHER INFO INTO ELEMENTS
     }
}
        Write a Reply...