Đang Thực Hiện

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>[url removed, login to view]</BalanceTotal><BalanceDetails><Balance><Amount>1</Amount><Reason>Pro-rated balance for Add Feature</Reason></Balance><Balance><Amount>[url removed, login to view]</Amount><Reason>Pro-rated balance for Add Feature</Reason></Balance></BalanceDetails><Terms><div class="sbTermsWrapper"><div class="sbTerms">$ [url removed, login to view] for the first 7 days</div><div class="sbTermsSub">$ [url removed, login to view] 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 thêm: usd 305, table customer, region 13, mysql org, john price, customer table, charged to, be smith, xml php array, timestamp, table, ack, 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, insert mysql table, balance update

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

Mã Dự Án: #1726626

Đã trao cho:


We are ready to do this project.

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

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


Proposal details will follow. Thanks, 2ansi

$30 USD trong 0 ngày
(85 Đánh Giá)

i can do it right.

$50 USD trong 0 ngày
(74 Đánh Giá)

I can write script right now. Thanks.

$30 USD trong 0 ngày
(99 Đánh Giá)

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

$80 USD trong 2 ngày
(24 Đánh Giá)

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

$30 USD trong 1 ngày
(27 Đánh Giá)

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 Giá)

** 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 Giá)

Check your pm

$30 USD trong 1 ngày
(1 Đánh Giá)

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

$175 USD trong 3 ngày
(0 Đánh Giá)

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 Giá)