Jump to content

[SOLVED] array to DB


smilesmita

Recommended Posts

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]

Link to comment
https://forums.phpfreaks.com/topic/62709-solved-array-to-db/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.