note 110833 added to simplexml.examples-basic

From: 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

« previous php.notes (#192501) next »