Array to DB
Posted: Tue Jul 31, 2007 2:25 pm
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
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
Code: Select all
=> 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
[SubscriptionFile] => xxxxxxxxxxxxxxx
[FileName] => xxxxxxxx1_1xxxxxxxx
[StatusType] => UUnreadCode: Select all
=> 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)
)