Đã hoàn thành

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)

Kĩ năng: MySQL, PHP, XML

Xem nhiều hơn: 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

Về Bên Thuê:
( 13 nhận xét ) Wilmington, United States

ID dự án: #1726626

Được trao cho:

netxpertindia

We are ready to do this project.

$40 USD trong 1 ngày
(87 Đánh Giá)
6.8

11 freelancer đang chào giá trung bình $55 cho công việc này

ansi2

Proposal details will follow. Thanks, 2ansi

$30 USD trong 0 ngày
(85 Nhận xét)
6.3
cristisst

i can do it right.

$50 USD trong 0 ngày
(74 Nhận xét)
5.8
devservice

I can write script right now. Thanks.

$30 USD trong 0 ngày
(99 Nhận xét)
5.8
muhammadghasan

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

$80 USD trong 2 ngày
(24 Nhận xét)
5.2
istankov85

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

$30 USD trong 1 ngày
(27 Nhận xét)
4.7
mkhall

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

$40 USD trong 1 ngày
(10 Nhận xét)
4.4
rishab6565

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

$55 USD trong 1 ngày
(5 Nhận xét)
3.8
MakhijaRavi

Check your pm

$30 USD trong 1 ngày
(1 Nhận xét)
0.9
joytion

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

$175 USD trong 3 ngày
(0 Nhận xét)
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 Thêm

$50 USD trong 1 ngày
(0 Nhận xét)
0.0