XML : PHP XML to mysql database

I am stumped. Can't seem to access the XML array after using simplexmlelement. I have tried it all kind of ways and this site is full of examples or how to parse xml into a data array using the simplexmlelement function in PHP. I have even gone the PHP site to review the function and see how it works. I am a mid level PHP programmer. Most of these things I can figure out now. The first thing I did was to write a loop to print the data to the screen from the simplexmlelement, no go.

Here is my array:

  object(SimpleXMLElement)[4]  public 'result' => string '1' (length=1)  public 'result-text' => string 'OK' (length=2)  public 'action-type' => string 'add-customer' (length=12)  public 'result-code' => string '100' (length=3)  public 'amount' => string '0.00' (length=4)  public 'customer-id' => string '675700633' (length=9)  public 'customer-vault-id' => string '675700633' (length=9)  public 'merchant-defined-field-1' => string 'Red' (length=3)  public 'merchant-defined-field-2' => string 'Medium' (length=6)  public 'billing' =>   object(SimpleXMLElement)[5]    public 'billing-id' => string '2037042803' (length=10)    public 'first-name' => string 'John' (length=4)    public 'last-name' => string 'Smith' (length=5)    public 'address1' => string '1234 Main St.' (length=13)    public 'city' => string 'Beverly Hills' (length=13)    public 'state' => string 'CA' (length=2)    public 'postal' => string '90210' (length=5)    public 'country' => string 'US' (length=2)    public 'phone' => string '555-555-5555' (length=12)    public 'email' => string 'test@example.com' (length=16)    public 'cc-number' => string '411111******1111' (length=16)    public 'cc-exp' => string '1014' (length=4)    public 'priority' => string '1' (length=1)   public 'shipping' =>    object(SimpleXMLElement)[6]    public 'shipping-id' => string '416154095' (length=9)    public 'priority' => string '1' (length=1)    

I came at this array with everything I know how to do. I know better than to try to write full blown code. So I test out accessing the array like this.

      $xml = new SimpleXMLElement($data);      echo $xml->result . "<br>";      echo $xml->response['result-text'] . "<br>";      echo $xml->action-type . "<br>";      echo $xml->amount . "<br>";    

This nets me nothing. The $data variable holds the xml.

        $xml = <<<XML      <?xml version="1.0" encoding="UTF-8"?>       <response>        <result>1</result>         <result-text>OK</result-text>         <action-type>add-customer</action-type>         <result-code>100</result-code>         <amount>0.00</amount>         <customer-id>1680673722</customer-id>         <customer-vault-id>1680673722</customer-vault-id>         <merchant-defined-field-1>Red</merchant-defined-field-1>         <merchant-defined-field-2>Medium</merchant-defined-field-2>     <billing>        <billing-id>268327184</billing-id>        <first-name>John</first-name>        <last-name>Smith</last-name>        <address1>1234 Main St.</address1>        <city>Beverly Hills</city>        <state>CA</state>        <postal>90210</postal>        <country>US</country>        <phone>555-555-5555</phone>        <email>test@example.com</email>        <cc-number>411111******1111</cc-number>        <cc-exp>1014</cc-exp>        <priority>1</priority>     </billing>      <shipping>          <shipping-id>998194109</shipping-id>          <priority>1</priority>      </shipping>    </response>      XML;    

I know it is something simple that I am over looking but I have a really big headache now and just want to get this over with so I can move on. Thanks!

No comments:

Post a Comment