tags:

views:

51

answers:

1

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>
+1  A: 
<?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>";
?>
Amarghosh
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>
shantanuo
Add this to the question.
Amarghosh
@shantanuo updated answer to print tables.
Amarghosh