[RESOLVED] XML Help

[Mark_Nordstrom]

I wanna upload an XML and use PHP to strip all of its contents but whats in the fields <Name> there are multiple name fields. After it does this I need to be able to echo all the names so i can import them to sql (my server doesn't allow load xml or this would be easier). I've tried simplexml but I cant get anything to work.

[traq]

Mark Nordstrom;11003888 wrote:

I've tried simplexml but I cant get anything to work.

Could you post an example of the code you tried? SimpleXML is going to be a lot easier/more reliable than the alternative (regexes).

[Mark_Nordstrom]

<?xml version="1.0" encoding="UTF-8"?>
<Group>
  <GroupId>9223372036854844736</GroupId>
  <LeaderId>214202457684634865</LeaderId>
  <Type>0</Type>
  <Assistants>
    <Assistant>
      <Id>214202457684599056</Id>
    </Assistant>
    <Assistant>
      <Id>214202457579552095</Id>
    </Assistant>
    <Assistant>
      <Id>214202457727758793</Id>
    </Assistant>
    <Assistant>
      <Id>214202457684594537</Id>
    </Assistant>
  </Assistants>
  <Parties>
    <Party>
      <Id>9223372036854844575</Id>
      <LeaderId>0</LeaderId>
      <Members>
        <Member>
          <Id>214202457727758793</Id>
          <Name>randomname1</Name>
          <Disconnected>False</Disconnected>
          <AFK>False</AFK>
        </Member>
      </Members>
    </Party>
    <Party>
      <Id>9223372036854844737</Id>
      <LeaderId>0</LeaderId>
      <Members>
        <Member>
          <Id>214202457686984724</Id>
          <Name>randomname6</Name>
          <Disconnected>False</Disconnected>
          <AFK>False</AFK>
        </Member>
      </Members>
    </Party>
    <Party>
      <Id>9223372036854844738</Id>
      <LeaderId>0</LeaderId>
      <Members>
        <Member>
          <Id>214202457704421028</Id>
          <Name>randomname11</Name>
          <Disconnected>False</Disconnected>
          <AFK>False</AFK>
        </Member>
      </Members>
    </Party>
    <Party>
      <Id>9223372036854844739</Id>
      <LeaderId>0</LeaderId>
      <Members>
        <Member>
          <Id>214202457697694548</Id>
          <Name>randomname16</Name>
          <Disconnected>False</Disconnected>
          <AFK>False</AFK>
        </Member>
      </Members>
    </Party>
  </Parties>
</Group>

Except every file will have 10-20 actual names.

[traq]

Mark Nordstrom;11003888 wrote:

I've tried simplexml but I cant get anything to work.

traq;11003895 wrote:

Could you post an example of the code you tried?

🙂

[Mark_Nordstrom]

extract( $_POST );
$form_data=$_FILES['form_data']['tmp_name'];

$file = "$form_data"; 

function contents($parser, $data){ 
    echo $data; 
} 

function startTag($parser, $data){ 
    echo "<Name>"; 
} 

function endTag($parser, $data){ 
    echo "</Name>"; 
} 

$xml_parser = xml_parser_create(); 

xml_set_element_handler($xml_parser, "startTag", "endTag"); 

xml_set_character_data_handler($xml_parser, "contents"); 

$fp = fopen($file, "r"); 

$data = fread($fp, 80000); 

if(!(xml_parse($xml_parser, $data, feof($fp)))){ 
    die("Error on line " . xml_get_current_line_number($xml_parser)); 
} 

xml_parser_free($xml_parser); 

fclose($fp); 

This is the first thing I tried and it removes all the tags from the xml and shows all the data what I need is something to show just the name fields.

I also tried

<?php
extract( $_POST );
$form_data=$_FILES['form_data']['tmp_name'];
$xml = simplexml_load_file("$form_data");

echo $xml->getName() . "<br />";

foreach($xml->children() as $child)
  {
  echo $child->getName() . ": " . $child . "<br />";
  }
?>

doesn't go deep enough into the xml It will show

Group
GroupId: 9223372036854844736
LeaderId: 214202457684634865
Type: 0
Assistants:
Parties:

[Weedpacket]

function startTag($parser, $data){ 
    echo "<Name>"; 
} 

Have you considered writing something more worthwhile here? Instead of just writing "<Name>" to the output every time you read any start tag?

What you're supposed to do here is set a property (or global variable if you're avoiding objects for some reason) to say that you've entered an element. You use the second parameter to identify which kind of element you've entered (in this case you'd want to see if $data=='Name').

Then in the character data handler, you look at this property, and if it indicates you're in a Name element, you know that the character data you're looking at is what you're looking for.

And of course the closing tag handler would reset the property when it sees you've reached the '</Name>' closing tag.

Have a look at the examples spread all through the [man]xml_parse[/man] chapter of the manual - including the user notes.

$xml = new DOMDocument;
$xml->loadXML($form_data);
$name_elemens = $xml->getElementsByTagName('Name');

[Mark_Nordstrom]

<?php
extract( $_POST );
$form_data=$_FILES['form_data']['tmp_name'];
$file = "$form_data"; 

function objectsIntoArray($arrObjData, $arrSkipIndices = array())
{
    $arrData = array();

// if input is object, convert into array
if (is_object($arrObjData)) {
    $arrObjData = get_object_vars($arrObjData);
}

if (is_array($arrObjData)) {
    foreach ($arrObjData as $index => $value) {
        if (is_object($value) || is_array($value)) {
            $value = objectsIntoArray($value, $arrSkipIndices); // recursive call
        }
        if (in_array($index, $arrSkipIndices)) {
            continue;
        }
        $arrData[$index] = $value;
    }
}
return $arrData;
}

$xmlUrl = "$form_data"; // XML feed file/URL
$xmlStr = file_get_contents($xmlUrl);
$xmlObj = simplexml_load_string($xmlStr);
$arrXml = objectsIntoArray($xmlObj);
print_r($arrXml);

?>

So this shows the xml in arrays how would I only print the data within tags <Name> </Name>

[Mark_Nordstrom]

I figured it out thanks for the help guys.