smilesmita Posted July 31, 2007 Share Posted July 31, 2007 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.