From XML to MySQL
<p>I have loaded my XML file with PHP simpleXML but I have next situation ... My XML file looks like this:</p>

<pre><code>&lt;xml&gt;
    &lt;status&gt;1&lt;/status&gt;
    &lt;market&gt;
      &lt;shop&gt;
          &lt;url&gt;https://some.api.link.with.products.of.shop.com/file_with_products.xml&lt;/url&gt;
          &lt;shopId&gt;1&lt;/shopId&gt;
          &lt;name&gt;First shop&lt;/name&gt;
      &lt;/shop&gt;
      &lt;shop&gt;
          &lt;url&gt;https://some.api.link.with.products.of.shop.com/file_with_products.xml&lt;/url&gt;
          &lt;shopId&gt;2&lt;/shopId&gt;
          &lt;name&gt;Second shop&lt;/name&gt;
      &lt;/shop&gt;
    &lt;/market&gt;
&lt;/xml&gt;
</code></pre>

<p>I'm accessing this XML data like a objects :</p>

<pre><code>foreach($xml-&gt;market-&gt;shop as $shop)
    {
        echo $shop-&gt;url;
        echo $shop-&gt;storeId;
        echo $shop-&gt;name;
    }
</code></pre>

<p>Is there a way to access data from this url links (which is also an XML file with products list of that shop) ? So every shop have url link with XML file of his products. I have to get all data and store in MySQL databse (all data means shops data from main XML file and data from url links which are product list of that shop). Im also using phalcon framework.</p>