note 110833 added to simplexml.examples-basic
| From: | Niqo | Date: | Wed, 12 Dec 2012 21:04:35 +0000 |
| Subject: | note 110833 added to simplexml.examples-basic | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-192501@lists.php.net to get a copy of this message | ||
How do I save the below XML to MySQL table with php?
<Zipbill>
<Hierarchy MainAccount="48255"/>
<Invoice AccountNumber="48255" AccountLinkCode="100243"
InvoiceNumber="FINV-00661288-12" InvoiceDate="27/11/2012"
DueDate="27/12/2012" InvoicePeriod="28/10/2012 - 27/11/2012"/>
<SubscriberDetails Title="FNB NAMIBIA" FirstName="" MidName=""
LastName="" Address1="P.O. BOX 195" Address2="-"
City="WINDHOEK" Country="NAMIBIA" Postalcode=""
ProfileType="G" ContactPerson="0" Email=""/>
<MarketingMsg Msg="Dear Customer data roaming is costly. To activate or deactivate please
dial *682#, select DATA SERVICES and follow the instructions. We suggest that you cancel automatic
data updates on your devices if you choose to do data roaming. Roaming costs are not immediately
charged to your available credit limit but only when roaming partners forward your call
records."/>
<AccountSummary PreviousBalance="19391.21" PaymentReceived="-62500.94"
Adjustments="0.00" AmountOverdue="-43109.73" CurrentCharges="71837.08"
TotalBalance="28727.35" AdjPrePayment="-46883.23" Desc="Recurring
charges/Access fees (eg: Monthly subscription fees) are payable in advance and are up to and
including 27 December 2012. Usage charges and payments are up to and including 27 November
2012" />
<AccountSummary2 Days91="0.00" Days60To90="0.00" Days31To60="0.00"
Days1To30="75610.58" PreInvPayments="0.00"/>
<CurrentChargedSummary AmtExclusiveVAT="103680.44"
AmtVATCalculate="15039.87" AmtIncludingVAT="118720.31">
<RoamMade Description="RoamMade" Charge="560.85" Discount="0.00"
Total="560.85"/>
<OtherCharges Description="OtherCharges" Charge="3479.95"
Discount="0.00" Total="3479.95"/>
<MonthlySubscCharges Description="MonthlySubscCharges" Charge="4231.18"
Discount="-610.59" Total="3620.59"/>
<RoamMadeVat Description="RoamMadeVat" Charge="1872.48"
Discount="0.00" Total="1872.48"/>
<OtherCrdCharges Description="OtherCrdCharges" Charge="-99.00"/>
<GPRSROAM Description="GPRSROAM" Charge="0.11" Discount="0.00"
Total="0.11"/>
<GPRSROAMVATNA Description="GPRSROAMVATNA" Charge="1842.16"
Discount="0.00" Total="1842.16"/>
<MMS Description="MMS" Charge="20115.46" Discount="0.00"
Total="20115.46"/>
<GPRS Description="GPRS" Charge="11597.18" Discount="0.00"
Total="11597.18"/>
<InternationalCalls Description="InternationalCalls" Charge="6301.90"
Discount="0.00" Total="6301.90"/>
<UsageCharges Description="UsageCharges" Charge="96678.90"
Discount="0.00" Total="96678.90"/>
<NationalCalls Description="NationalCalls" Charge="54144.43"
Discount="0.00" Total="54144.43"/>
<RoamReceived Description="RoamReceived" Charge="244.33"
Discount="0.00" Total="244.33"/>
</CurrentChargedSummary>
</Zipbill>
----
Server IP: 69.147.83.199
Probable Submitter: 72.52.91.2 (proxied: 197.243.208.99)
----
Manual Page -- http://php.net/manual/en/simplexml.examples-basic.php
Edit -- https://master.php.net/note/edit/110833
Del: integrated -- https://master.php.net/note/delete/110833/integrated
Del: useless -- https://master.php.net/note/delete/110833/useless
Del: bad code -- https://master.php.net/note/delete/110833/bad+code
Del: spam -- https://master.php.net/note/delete/110833/spam
Del: non-english -- https://master.php.net/note/delete/110833/non-english
Del: in docs -- https://master.php.net/note/delete/110833/in+docs
Del: other reasons-- https://master.php.net/note/delete/110833
Reject -- https://master.php.net/note/reject/110833
Search -- https://master.php.net/manage/user-notes.php