Insert data into mysql php in diffrent rows after retrieve from xml file

Question

test.xml

<?xml version="1.0" encoding="ISO-8859-1"?>
<propertyList>
  <business  type="food">
  <listingAgent id="1">
    <name>Spiro Abelas</name>
    <email>[email protected]</email>
  </listingAgent>
 </business>
 <business  type="food">
  <listingAgent id="2">
    <name>andy</name>
    <email>[email protected]</email>
  </listingAgent>
 </business>
</propertyList>

Php code Interprets an XML file into an object

<?php
  if (file_exists('test.xml')) {
    $xml = simplexml_load_file('test.xml');
      echo "<pre>";
      print_r($xml);
      echo "</pre>";
  } else {
     exit('Failed to open test.xml.');
     }
 ?>

Output

     SimpleXMLElement Object
(
[business] => Array
(
[0] => SimpleXMLElement Object
(
    [@attributes] => Array
        (
            [type] => food
        )
    [listingAgent] => SimpleXMLElement Object
        (
            [@attributes] => Array
                (
                    [id] => 1
                )
            [name] => spiro
            [email] => [email protected]
        )
)
[1] => SimpleXMLElement Object
(
    [@attributes] => Array
        (
            [type] => food
        )
    [listingAgent] => SimpleXMLElement Object
        (
            [@attributes] => Array
                (
                    [id] => 2
                )
            [name] => andy
            [email] => [email protected]
        )
)))

Table structure

enter image description here

i want to inset data like that into table

enter image description here

but i not getting how to retrieve data from array and insert into multiple rows

so plz guide me how to sort out it

possible duplicate of Insert array data into mysql php

eggyal
– eggyal

2012-05-29 13:16:08 +00:00
Commented May 29, 2012 at 13:16 — eggyal
– eggyal, Commented May 29, 2012 at 13:16

Bastian Rang · Accepted Answer · 2012-05-29 13:37:03Z

1

foreach($xml->business as $row)
{
  $business_type = $row->attributes()->type;
  $id = $row->listingAgent->attributes()->id;
  $name = $row->listingAgent->name;
  $email = $row->listingAgent->email;
  mysql_query('INSERT INTO table…');
}

edited May 29, 2012 at 13:37

answered May 29, 2012 at 13:16

Bastian Rang

2,1971 gold badge19 silver badges25 bronze badges

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

1 Comment

thecodedeveloper.com Over a year ago

thanks for reply, but i m getting those error Call to a member function attributes() on a non-object

Collectives™ on Stack Overflow

Insert data into mysql php in diffrent rows after retrieve from xml file

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related