Parsing an XML feed in PHP4

[webgambit]

I've got a form that I submit to a 3rd party whose server responds with XML similar to:

<?xml version="1.0"?>
<response>
  <status>accept</status>
  <id>123456789</id>
  <sale>
    <price>12.00</price>
    <redirect>http://redirect-example.com</redirect>
  </sale>
</response>

I have the above XML information stored in $response, which I then do

$parser = xml_parser_create('UTF-8');
xml_parser_set_option($parser, XML_OPTION_SKIP_WHITE, 1); 
xml_parse_into_struct($parser, $response, $vals, $index); 
xml_parser_free($parser); 

Now, all I'm wanting to do is be able to call the values, such as status, id, price, etc. so that I can add them to a mySQL db, but so far I haven't been able to figure out how to do this. All the tutorials I've read deal with reading an xml file, but I'm not dealing with a file.

Any help would be appreciated.

-jeremy

[byron3@earthlink]

Documentation @ :
http://us.php.net/manual/en/function...nto-struct.php

The $index contains an index of xml keys.
The $vals contain an array of values that correspond to the keys.

[webgambit]

Byron, as much as I loved the RTFM reference there, it doesn't help. I've read that page several times over the last couple days and I can't seem to wrap my head around it at this point.

As much as I hate to ask, anyone have any newbie type tutorials for this part because everything I'm finding is just confusing me.... maybe I'm having a bad week or something.

-jeremy

[byron3@earthlink]

Do a var_dump on your $vals and $index and post the results back in this thread.

[buildakicker]

You could export a file, then delete it when finished taking necessary data from it.

Just a quick thought.

[webgambit]

echo $result; outputs:

<?xml version="1.0"?>
<response>
  <status>reject</status>
  <errors>
    <error>Your account is in test mode</error>
  </errors>
</response>

print_r(array_keys($index)); outputs:

Array ( [0] => RESPONSE [1] => STATUS [2] => ERRORS [3] => ERROR )

print_r(array_values($index)); outputs:

Array ( [0] => Array ( [0] => 0 [1] => 5 ) [1] => Array ( [0] => 1 ) [2] => Array ( [0] => 2 [1] => 4 ) [3] => Array ( [0] => 3 ) )

print_r(array_keys($vals)); outputs:

Array ( [0] => 0 [1] => 1 [2] => 2 [3] => 3 [4] => 4 [5] => 5 )

print_r(array_values($vals)); outputs:

Array ( [0] => Array ( [tag] => RESPONSE [type] => open [level] => 1 ) [1] => Array ( [tag] => STATUS [type] => complete [level] => 2 [value] => reject ) [2] => Array ( [tag] => ERRORS [type] => open [level] => 2 ) [3] => Array ( [tag] => ERROR [type] => complete [level] => 3 [value] => Your account is in test mode ) [4] => Array ( [tag] => ERRORS [type] => close [level] => 2 ) [5] => Array ( [tag] => RESPONSE [type] => close [level] => 1 ) )

-jeremy

[webgambit]

Okay, granted parsing XML is new to me, but looking through the info in my above post, here's what I'm thinking.

Shouldn't I be able to search through the $vals variable and find occurrences of status, id, price, redirect, error and then assign the next value to a variable by that name? So that when it finds the word status it creates $status which, in this case, would equal "rejected". That's all I'm wanting, so that I can then add them to my db.

-jeremy

[byron3@earthlink]

Dont split those arrays, show me the output from var_dump() for both.

[webgambit]

Here ya go:

print_r(var_dump($index));

array(4) { ["RESPONSE"]=>  array(2) { [0]=>  int(0) [1]=>  int(5) } ["STATUS"]=>  array(1) { [0]=>  int(1) } ["ERRORS"]=>  array(2) { [0]=>  int(2) [1]=>  int(4) } ["ERROR"]=>  array(1) { [0]=>  int(3) } }

print_r(var_dump($vals));

array(6) { [0]=>  array(3) { ["tag"]=>  string(8) "RESPONSE" ["type"]=>  string(4) "open" ["level"]=>  int(1) } [1]=>  array(4) { ["tag"]=>  string(6) "STATUS" ["type"]=>  string(8) "complete" ["level"]=>  int(2) ["value"]=>  string(6) "reject" } [2]=>  array(3) { ["tag"]=>  string(6) "ERRORS" ["type"]=>  string(4) "open" ["level"]=>  int(2) } [3]=>  array(4) { ["tag"]=>  string(5) "ERROR" ["type"]=>  string(8) "complete" ["level"]=>  int(3) ["value"]=>  string(45) "Your account does not have open market access" } [4]=>  array(3) { ["tag"]=>  string(6) "ERRORS" ["type"]=>  string(5) "close" ["level"]=>  int(2) } [5]=>  array(3) { ["tag"]=>  string(8) "RESPONSE" ["type"]=>  string(5) "close" ["level"]=>  int(1) } }

[byron3@earthlink]

$vals[0]["tag"] = "RESPONSE";
$vals[0]["type"] = "open";
$vals[0]["level"] = 1;
$vals[1]["tag"] = "STATUS";
$vals[1]["type"] = "complete";
$vals[1]["level"] = 2;
$vals[1]["value"] = "reject";
$vals[2]["tag"] = "ERRORS";
$vals[2]["type"] = "open";
$vals[2]["level"] = 2;
$vals[3]["tag"] = "ERROR";
$vals[3]["type"] = "complete";
$vals[3]["level"] = 3;
$vals[3]["value"] = "Your account does not have open market access";
$vals[4]["tag"] = "ERRORS";
$vals[4]["type"] = "close";
$vals[4]["level"] = 2;
$vals[5]["tag"] = "RESPONSE";
$vals[5]["type"] = "close";
$vals[5]["level"] = 1;

function getStatus( $In_r ) {
    foreach ( $In_r as $K ) {
        if ( $K["tag"] == "STATUS" ) {
            $out = $K["value"];
            return $out;
        }
    }
}

echo "Response = " .getStatus( $vals ); 

Yields : "Response = reject"