# Help need for converting xml to php
**URL:** https://forum.kirupa.com/t/help-need-for-converting-xml-to-php/267926
**Category:** Uncategorized
**Created:** [August 7, 2008, 11:49am UTC](https://forum.kirupa.com/t/help-need-for-converting-xml-to-php/267926 "2008-08-07T11:49:20Z")
**Posts on this page:** 1
**Page:** 1
### Author:  [@vetrib2w](https://forum.kirupa.com/u/vetrib2w)
#### Post date: [August 7, 2008, 11:49am UTC](https://forum.kirupa.com/t/help-need-for-converting-xml-to-php/267926/1 "2008-08-07T11:49:20Z")
Hi Friends,
I m having xml file and i need to convert it to php and then i need to insert it into mysql table.
While doing so i come across few issues.and i dont know how to solve it.
…this is my xml file…
\
\
\
[COLOR=Red] \
\Raymond1\
\Ying\
\raymond.ying@telecom.co.nz\
\0272514517\
\35 Virginia Ave East\
\Kingsland\
\Auckland\
\Auckland Region\
\NZ\
\
\
\Raymond\
\Ying\
\raymond.ying@telecom.co.nz\
\0272514517\
\35 Virginia Ave East\
\Kingsland\
\Auckland\
\Auckland Region\
\NZ\
\[/COLOR]
\
\\
\
\\
\
\\
\
\
\\
\
\
\
…This is my php file…
```php
$dom=new DOMDocument();
$dom->load('order.xml');
$OrderBatch=$dom->getElementsByTagName('OrderBatch');
foreach($OrderBatch as $OrderBatch){
$xsi=$OrderBatch->getAttribute('xmlns:xsi');
$ns1=$OrderBatch->getAttribute('xmlns:ns1');
$schemaLocation=$OrderBatch->getAttribute('xsi:schemaLocation');
}
$Order=$dom->getElementsByTagName('Order');
foreach($Order as $Order){
$FerritOrderID=$Order->getAttribute('FerritOrderID');
$FerritRetailerID=$Order->getAttribute('FerritRetailerID');
$CreationDate=$Order->getAttribute('CreationDate');
$LastModifiedDate=$Order->getAttribute('LastModifiedDate');
$FerritCustomerID=$Order->getAttribute('FerritCustomerID');
}
$Payment=$dom->getElementsByTagName('Payment');
foreach($Payment as $Payment){
$Currency=$Payment->getAttribute('Currency');
$GrandTotal=$Payment->getAttribute('GrandTotal');
$Refunded=$Payment->getAttribute('Refunded');
}
$DPS=$dom->getElementsByTagName('DPS');
foreach($DPS as $DPS){
$PxToken=$DPS->getAttribute('PxToken');
}
$ShippingMethod=$dom->getElementsByTagName('ShippingMethod');
foreach($ShippingMethod as $ShippingMethod){
$Shipping_id=$ShippingMethod->getAttribute('id');
$Shipping_Total=$ShippingMethod->getAttribute('Total');
$Shipping_Code=$ShippingMethod->getAttribute('Code');
$Shipping_Name=$ShippingMethod->getAttribute('Name');
$Shipping_BasePrice=$ShippingMethod->getAttribute('BasePrice');
$Shipping_Discount=$ShippingMethod->getAttribute('Discount');
}
$Product=$dom->getElementsByTagName('Product');
foreach($Product as $Product){
$Product_id=$Product->getAttribute('id');
$Product_SKU=$Product->getAttribute('SKU');
$Product_Name=$Product->getAttribute('Name');
$Product_Quantity=$Product->getAttribute('Quantity');
$Product_Total=$Product->getAttribute('Total');
$Product_BasePrice=$Product->getAttribute('BasePrice');
$Product_Discount=$Product->getAttribute('Discount');
$Product_TaxClass=$Product->getAttribute('TaxClass');
$Product_QuantityDispatched=$Product->getAttribute('QuantityDispatched');
$Product_QuantityRefunded=$Product->getAttribute('QuantityRefunded');
}
$Entry=$dom->getElementsByTagName('Entry');
foreach($Entry as $Entry){
$DateTime=$Entry->getAttribute('DateTime');
$Visibility=$Entry->getAttribute('Visibility');
$Event=$Entry->getAttribute('Event');
$Message=$Entry->getAttribute('Message');
}
```
…php file ends here…
**my issue:
I can get all the values expect [COLOR=Red]billing address(firstname,lastname…Country) and shipping address (firstname,lastname…Country)…[/COLOR]
i dont know how to write for it… i did new things but i failed…**
**so,
please help me…**