display XML data in PHP

Question

My XML output looks like this...

How do I display it in PHP?

  <row>
        <field name="seat_no">18</field>
        <field name="my_ticket_no">924403</field>
        <field name="pass_nm">abcd</field>
        <field name="pass_age">46</field>
        <field name="pass_sex">F</field>
  </row>

  <row>
        <field name="seat_no">19</field>
        <field name="my_ticket_no">926634</field>
        <field name="pass_nm">VANDANA</field>
        <field name="pass_age">25</field>
        <field name="pass_sex">F</field>
  </row>

... I don't get it. Why would PHP need to display it? Why not just put it in a file and serve that? — Ignacio Vazquez-Abrams
– Ignacio Vazquez-Abrams, Commented Jan 27, 2010 at 11:48
This is probably a valid question asking for how to format / layout raw XML data in PHP. We need more hints as what the end result is supposed to look like, though. — Pekka
– Pekka, Commented Jan 27, 2010 at 11:53

Amarghosh · Accepted Answer · 2010-01-27 13:03:18Z

2

<?php
$data = new SimpleXMLElement('<root><row>
        <field name="seat_no">18</field>
        <field name="my_ticket_no">924403</field>
        <field name="pass_nm">abcd</field>
        <field name="pass_age">46</field>
        <field name="pass_sex">F</field>
  </row>

  <row>
        <field name="seat_no">19</field>
        <field name="my_ticket_no">926634</field>
        <field name="pass_nm">VANDANA</field>
        <field name="pass_age">25</field>
        <field name="pass_sex">F</field>
  </row></root>');
echo "<table border='1'>";
foreach($data->row as $row)
{
    echo "<tr>";
    $seat = $row->xpath("field[@name = 'seat_no']");
    echo "<td>".$seat[0]."</td>";
    $tckt = $row->xpath("field[@name = 'my_ticket_no']");
    echo "<td>".$tckt[0]."</td>";
    //and so on...
    echo "</tr>";
}  
echo "</table>";
?>

edited Jan 27, 2010 at 13:03

answered Jan 27, 2010 at 12:01

Amarghosh

59.5k11 gold badges95 silver badges122 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

shantanuo Over a year ago

I need to display the data in a normat table format. <table> <tr> <td> 18 </td> <td> 924403</td> <td>abcd</td> <td>46</td> <td> F </td></tr> .(second row here)..</table>

Collectives™ on Stack Overflow

display XML data in PHP

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related