XML data extraction
| From: | Andrew Williams | Date: | Thu, 02 Apr 2009 09:02:53 +0000 |
| Subject: | XML data extraction | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-290948@lists.php.net to get a copy of this message | ||
Best All,
How can you best and accurately extract XLM data to DB table. e.g.:
<EXCHANGE_LIST AMOUNT="3">
-
<EXCHANGE>
<ID_EXCHANGE>20</ID_EXCHANGE>
<CODE_EXCHANGE>FRA</CODE_EXCHANGE>
<NAME_EXCHANGE>Frankfurt</NAME_EXCHANGE>
</EXCHANGE>
-
<EXCHANGE>
<ID_EXCHANGE>28</ID_EXCHANGE>
<CODE_EXCHANGE>LSE</CODE_EXCHANGE>
<NAME_EXCHANGE>London Stock Exchange</NAME_EXCHANGE>
</EXCHANGE>
-
<EXCHANGE>
<ID_EXCHANGE>226</ID_EXCHANGE>
<CODE_EXCHANGE>GER</CODE_EXCHANGE>
<NAME_EXCHANGE>Xetra</NAME_EXCHANGE>
</EXCHANGE>
</EXCHANGE_LIST>
www.willandy.co.uk