[SOLVED] array to DB

[smilesmita]

hi there,

I have converted my xml string into array of this form.I wanted to know how i can put the array values and data into a database table...how shud i extract it.for example

SubscriptionFile is the column in my table and i want the value of it to get poplulated in the table.



Array
(
[subscriptionFile] => xxxxxxxxxxxxxxx
[FileName] => xxxxxxxx1_1xxxxxxxx
[statusType] => UUnread
[Codes] => xxxx
[Description] => Active
[Manifest] => Cxxxxxxxxxxxxx
4601 MACIE STCHARLOTTENC28217-1810US
CEHG4220 LAURA KOPPEHOUSTONTX770165029US

[shipper] => xxxxxxxxxxxxxx
4601 MACIE STCHARLOTTENC28217-1810US

[shipperNumber] => xxxxxxxxxx
[Address] => 4xxxxxxxxxxxx
[shipTo] =>
Cxxxxxxxxxxx
[ConsigneeName] => xxxxxxxxxxx
[AddressLine1] => 4601 MACIE ST
[City] => CHARLOTTE
[stateProvinceCode] => NC
[PostalCode] => 28217-1810
[CountryCode] => US
[ReferenceNumber] => xxxxxxxxxxxxxx
[service] => 003
[PickupDate] => 20070731
[scheduledDeliveryDate] => 20070803
[Package] => xxxxxxxxxxxxxxx
[Activity] => xxxxxxxxxxxx
[Date] => 20070731
[Time] => 101300
[TrackingNumber] => 1xxxxx
[PackageServiceOptions] =>
[billToAccount] => xxxxxxxxxxx
[Option] => xxxxxxxxxx
[Number] => xxxxxxxxxxx
[subscriptionFile] => xxxxxxxxxxxxxxx
[FileName] => xxxxxxxx1_1xxxxxxxx
[statusType] => UUnread
[Code] => A
[Description] => Active
[Manifest] => Cxxxxxxxxxxxxx
4601 MACIE STCHARLOTTENC28217-1810US
CEHG4220 LAURA KOPPEHOUSTONTX770165029US

[shipper] => xxxxxxxxxxxxxx
4601 MACIE STCHARLOTTENC28217-1810US

[shipperNumber] => xxxxxxxxxx
[Address] => 4xxxxxxxxxxxx
[shipTo] =>
Cxxxxxxxxxxx
[ConsigneeName] => xxxxxxxxxxx
[AddressLine1] => 4601 MACIE ST
[City] => CHARLOTTE
[stateProvinceCode] => NC
[PostalCode] => 28217-1810
[CountryCode] => US
[ReferenceNumber] => xxxxxxxxxxxxxx
[service] => 003
[PickupDate] => 20070731
[scheduledDeliveryDate] => 20070803
[Package] => xxxxxxxxxxxxxxx
[Activity] => xxxxxxxxxxxx
[Date] => 20070731
[Time] => 101300
[TrackingNumber] => 1xxxxx
[PackageServiceOptions] =>
[billToAccount] => xxxxxxxxxxx
[Option] => xxxxxxxxxx
[Number] => xxxxxxxxxxx)
)

[/code]