php xml

macKeet · February 24, 2007

Newbie...Can anyone help me solve this problem....

Loaded this xml and php file onto my server and got the htm response below

.....................................................

<?xml version="1.0"?>

<name>Joe Wannabe</name>

<line>23, Great Bridge Road</line>

<line>Bombay, MH</line>

<line>India</line>

</address>

</customer>

<items>

<desc>Oversize tennis racquet</desc>

</item>

<desc>Championship tennis balls (can)</desc>

</item>

<desc>Designer gym bag</desc>

</item>

<desc>Custom-fitted sneakers</desc>

</item>

</items>

</invoice>

.....................................

<html>

<head>

</head>

Sammy's Sports Store

14, Ocean View, CA 12345, USA http://www.sammysportstore.com/

<hr>

<center>INVOICE</center>

<hr>

<?php

// arrays to associate XML elements with HTML output

$startTagsArray = array(

'CUSTOMER' => ' Customer: ',

'ADDRESS' => ' Billing address: ',

'DATE' => ' Invoice date: ',

'REFERENCE' => ' Invoice number: ',

'ITEMS' => ' Details: <table width="100%" border="1" cellspacing="0" cellpadding="3"><tr><td>Item description</td><td>Price</td><td> Quantity</td><td>Sub-total</td></tr>',

'ITEM' => '<tr>',

'DESC' => '<td>',

'PRICE' => '<td>',

'QUANTITY' => '<td>',

'SUBTOTAL' => '<td>',

'DELIVERY' => ' Shipping option: ',

'TERMS' => ' Terms and conditions: <ul>',

'TERM' => '<li>'

);

$endTagsArray = array(

'LINE' => ',',

'ITEMS' => '</table>',

'ITEM' => '</tr>',

'DESC' => '</td>',

'PRICE' => '</td>',

'QUANTITY' => '</td>',

'SUBTOTAL' => '</td>',

'TERMS' => '</ul>',

'TERM' => '</li>'

);

// array to hold sub-totals

$subTotals = array();

.....................................

//get this response?

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<META http-equiv=Content-Type

content="text/html; charset=windows-1252"><BASEFONT face=Arial>

<BODY bgColor=white>Sammy's Sports Store <FONT

size=-2>14, Ocean View, CA 12345, USA http://www.sammysportstore.com/

<HR>

<CENTER>INVOICE</CENTER>

<HR>

Warning: xmldocfile(): I/O in

e:\inetpub\esvc001204\invoice_xml\invoice.php on line

52 Warning: xmldocfile(): warning : in

e:\inetpub\esvc001204\invoice_xml\invoice.php on line

52 Warning: xmldocfile(): failed to load external entity

"/home/sammy/invoices/invoice.xml" in

e:\inetpub\esvc001204\invoice_xml\invoice.php on line

52 Fatal error: Call to a member function on a non-object

in e:\inetpub\esvc001204\invoice_xml\invoice.php on line 55 PHP

Warning: xmldocfile(): I/O in e:\inetpub\esvc001204\invoice_xml\invoice.php on

line 52 PHP Warning: xmldocfile(): warning : in

e:\inetpub\esvc001204\invoice_xml\invoice.php on line 52 PHP Warning:

xmldocfile(): failed to load external entity "/home/sammy/invoices/invoice.xml"

.............................................

Regards

Barand · February 25, 2007

If you have PHP5 you could

<?php
  $inv = simplexml_load_file('invoice1.xml');
  
  echo $inv->customer->name, '<br>';
  
  foreach ($inv->customer->address->line as $l) {
    echo $l, '<br>';
  }
  
  echo "<table border='1' cellpadding='3' cellspacing='0' width='600'>";
  echo "<tr><th> Date </th><th> Reference </th><th> Delivery </th></tr>";
  echo "<tr><td>" . date ('jS M Y', strtotime($inv->date)) . "</td><td> $inv->reference </td><td> $inv->delivery </td></tr>";
  echo '</table>';
   
  $tot = 0;
  echo "<table border='1' cellpadding='3' cellspacing='0' width='600'>";
  echo "<tr><th> Item<br>code </th><th> Description </th><th> Quantity </th><th> Unit<br>price </th><th> Price </th></tr>";
  foreach ($inv->items->item as $itm) {
    echo "<tr><td> {$itm['cid']} </td><td> $itm->desc </td><td align='center'> $itm->quantity </td><td align='right'> $itm->price </td><td align='right'> $itm->subtotal </td></tr>";
    $tot += floatval($itm->subtotal) ;
  }
  echo "<tr><td colspan='4'> Invoice total </td><td align='right'>" . number_format($tot, 2) . "</td></tr>"; 
  echo '</table>' 
?>

macKeet · February 25, 2007

Thank you for the promp answer but still getting this reply...

Fatal error: Call to undefined function: simplexml_load_file() in e:\inetpub\esvc001204\invoice_xml\invoice.php on line 2

PHP Fatal error: Call to undefined function: simplexml_load_file() in e:\inetpub\esvc001204\invoice_xml\invoice.php on line 2

Regards

Barand · February 25, 2007

Could be you don't have PHP5

macKeet · February 25, 2007

you are right, ran test php to the server and got version 4.3.11

is that version not able to parse the xml for me

or what can I do to make it work

Regards

Barand · February 25, 2007

Try this xmlparser class

http://www.phpfreaks.com/forums/index.php/topic,126827.0.html

Sign In

php xml

Recommended Posts

macKeet

Link to comment

Share on other sites

Barand

Link to comment

Share on other sites

macKeet

Link to comment

Share on other sites

Barand

Link to comment

Share on other sites

macKeet

Link to comment

Share on other sites

Barand

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information