Dear All,
I’m a new forum member and I would like to ask some questions. I have an xml file and i want to insert it into mysql table. I wondering if you could help, This my xml format :
<?xml version=“1.0” encoding=“UTF-8”?>
<XML><RECORDS>
<RECORD>
<REFERENCE_TYPE>31</REFERENCE_TYPE>
<AUTHORS>
<AUTHOR>Author</AUTHOR>
</AUTHORS>
<YEAR>2007</YEAR>
<TITLE>Title</TITLE>
<SECONDARY_AUTHORS>
<SECONDARY_AUTHOR>Editor</SECONDARY_AUTHOR>
</SECONDARY_AUTHORS>
<SECONDARY_TITLE>Book Title</SECONDARY_TITLE>
<PLACE_PUBLISHED>City</PLACE_PUBLISHED>
<PUBLISHER>Publisher</PUBLISHER>
<VOLUME>V</VOLUME>
<PAGES>Pages</PAGES>
<TERTIARY_AUTHORS>
<TERTIARY_AUTHOR>Series Editor</TERTIARY_AUTHOR>
</TERTIARY_AUTHORS>
<TERTIARY_TITLE>Serie Title</TERTIARY_TITLE>
<EDITION>Edition</EDITION>
<ISBN>ISBN</ISBN>
<ACCESSION_NUMBER>Accession Number</ACCESSION_NUMBER>
<CALL_NUMBER>Call Number</CALL_NUMBER>
<KEYWORDS>
<KEYWORD>Key</KEYWORD>
<KEYWORD>Words</KEYWORD>
</KEYWORDS>
<ABSTRACT>Abstract</ABSTRACT>
<NOTES>Notes</NOTES>
<URL>URL</URL>
</RECORD>
</RECORDS></XML>
Best Regards
