Käynnissä

Quick XML to mysql table

Hello, I need a quick php code with will pull elements from a xml string to be inserted into a table.

The xml is as follows:

<?xml version="1.0" encoding="utf-8"?><GSDR xmlns:i="[url removed, login to view]"><Ack>Success</Ack><TimeStamp>2012-06-29T18:34:00</TimeStamp><Subscription><Identifiers><Guid>UYSUNB4252012174922</Guid><Status>Active</Status><PackageLinkID>Base500Monthly</PackageLinkID></Identifiers><BillingDetails><StartDate>4/26/2012 12:49 AM</StartDate><EndDate>1/1/1970 12:00 AM</EndDate><BillingPeriod>Month</BillingPeriod><BillingFrequency>1</BillingFrequency><TrialBillingPeriod>Day</TrialBillingPeriod><TrialBillingFrequency>1</TrialBillingFrequency><TrialTotalBillingCycles>7</TrialTotalBillingCycles><TrialEndDate>5/2/2012 5:49 PM</TrialEndDate><Amount>90</Amount><NextBillingDate>7/2/2012 10:00 AM</NextBillingDate><NextBillingAmt>90</NextBillingAmt><NumCyclesCompleted>2</NumCyclesCompleted><NumCyclesRemaining>99999</NumCyclesRemaining><LastPaymentDate>6/2/2012 12:19 PM</LastPaymentDate><LastPaymentAmount>50</LastPaymentAmount><CurrencyCode>USD</CurrencyCode><TrialAmount>20</TrialAmount></BillingDetails><SubscriptionDetails><Description>Base Plan 500</Description></SubscriptionDetails><BalanceTotal>2.33</BalanceTotal><BalanceDetails><Balance><Amount>1</Amount><Reason>Pro-rated balance for Add Feature</Reason></Balance><Balance><Amount>1.33</Amount><Reason>Pro-rated balance for Add Feature</Reason></Balance></BalanceDetails><Terms><div class="sbTermsWrapper"><div class="sbTerms">$ 20.00 for the first 7 days</div><div class="sbTermsSub">$ 90.00 every month until cancelled</div></div></Terms><Customer><CustomerID>2196454</CustomerID><FullName>John Smith</FullName><FirstName>John</FirstName><LastName>Smith</LastName><Email></Email><BillingAddress><FirstName>John</FirstName><LastName>Smith</LastName><Address>addresst</Address><City>Anywhere</City><Region>State</Region><PostalCode>12345</PostalCode><Country>US</Country><Phone>phone</Phone></BillingAddress></Customer><Features><Feature><FeatureLinkID>294216</FeatureLinkID><Name>Widget</Name><Description><p>Widget Charge</p></Description><TrialPrice>20</TrialPrice><Price>20</Price></Feature><Feature><FeatureLinkID>255047</FeatureLinkID><Name>Widget 2</Name><Description><p>Add one widget to the account to be charged in the subscription.</p></Description><Price>20</Price></Feature></Features></Subscription></GSDR>

Need the <Features><Feature> array dropped into mysql table

If feature AND GUID exists, update table,

else insert

INSERT INTO features (GUID,FeatureLinkID,Name,Description,Price,NextBillingDate,timestamp)

Taidot: MySQL, PHP, XML

Näytä lisää: usd 305, table customer, region 13, mysql org, john price, customer table, charged to, be smith, xml php array, timestamp, table, ack, add div div, update status php mysql, php insert xml, mysql else insert, update mysql xml, php table array, table month php, region code, mysql update else, xmlns, mysql xml update, mysql inserted, xml mysql class

Tietoa työnantajasta:
( 13 arvostelua ) Wilmington, United States

Projektin tunnus: #1726626

Myönnetty käyttäjälle:

netxpertindia

We are ready to do this project.

40 $ USD 1 päivässä
(87 arvostelua)
6.8

11 freelancers are bidding on average $55 for this job

ansi2

Proposal details will follow. Thanks, 2ansi

30 $ USD 0 päivässä
(85 arvostelua)
6.3
cristisst

i can do it right.

50 $ USD 0 päivässä
(74 arvostelua)
5.8
devservice

I can write script right now. Thanks.

30 $ USD 0 päivässä
(99 arvostelua)
5.8
muhammadghasan

***PHP Expert*** Check your PMB, Thanks

80 $ USD 2 päivässä
(24 arvostelua)
5.2
istankov85

hi t2f, I have php, mysql and xml knowledge. Regards, Ivan Stankov

30 $ USD 1 päivässä
(27 arvostelua)
4.7
mkhall

I can write a function to do this for you using the PHP DOM methods. Please see PM.

40 $ USD 1 päivässä
(10 arvostelua)
4.4
rishab6565

** Top notch PHP+MySQL expert with similar work experience(4 Years)** Please check PMB for more details.

55 $ USD 1 päivässä
(5 arvostelua)
3.8
MakhijaRavi

Check your pm

30 $ USD 1 päivässä
(1 arvostelu)
0.9
joytion

Hey, We have expert team regarding to your project. Please check PMB for detail bid !!! Thanks.

175 $ USD 3 päivässä
(0 arvostelua)
0.0
MTruper

I have already written the PHP code for this. I can either send you a flat text file with the PHP code, upload the php code to a server of your choice, or host the code here and provide you with a link to a working ex Lisää

50 $ USD 1 päivässä
(0 arvostelua)
0.0