XML File into Database MYSQL

XML, Perl, Python, and other languages can be discussed here, even if it isn't PHP (We might forgive you).

Moderator: General Moderators

Post Reply
chrisonline
Forum Newbie
Posts: 2
Joined: Sun Sep 11, 2005 10:25 am

XML File into Database MYSQL

Post by chrisonline »

feyd | Please use

Code: Select all

and

Code: Select all

tags where approriate when posting code. Read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]


I have an XML File and want to put it into an MYSQL Database...

The Problem is that the XML File has more Tables...
I have found the Tool NAVICAT but this tool create only ONE Table and inserts the data...
The problem ist that for example the Regions or the Genres are with only 1 entry in the database !?!?
For this two i need an extra table...

Please help   , ist there any tool out there that can handle this XML File into Database?!?!?!

Example -- the Tag Regions or Genres has mor than one element:

Code: Select all

<?xml version="1.0" encoding="us-ascii"?>
<!-- DVD Profiler Version 2.4.0 Collection Export -->
<!-- Exported: 10.09.2005 15:23:20 -->
<Collection>
<DVD>
  <ID>000019112004.5</ID>
  <UPC>000019-112004</UPC>
  <ProfileTimestamp>2004-11-25 06:48:01</ProfileTimestamp>
  <Title>Heavenly Creatures</Title>
  <SortTitle>Heavenly Creatures</SortTitle>
  <Description>SFT Ausgabe</Description>
  <Regions>
    <Region>2</Region>
    <Region>1</Region>
  </Regions>
  <Discs>
  </Discs>
  <CollectionType>Owned</CollectionType>
  <CollectionNumber>33</CollectionNumber>
  <Locks>
    <Entire>False</Entire>
    <Covers>False</Covers>
    <Title>False</Title>
    <Cast>False</Cast>
    <Crew>False</Crew>
    <DiscInformation>False</DiscInformation>
    <Overview>False</Overview>
    <Regions>False</Regions>
    <AudioSubtitles>False</AudioSubtitles>
    <Genres>False</Genres>
    <SRP>True</SRP>
    <Studios>False</Studios>
  </Locks>
  <ProductionYear>1994</ProductionYear>
  <Released>2004-11-19</Released>
  <RunningTime>95</RunningTime>
  <CaseType>Keep Case</CaseType>
  <Genres>
    <Genre>Drama</Genre>
    <Genre>Action</Genre>
  </Genres>

p.s. sorry for my bad english i am from austria :D


feyd | Please use

Code: Select all

and

Code: Select all

tags where approriate when posting code. Read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

if you're wanting people on phpclasses.org to help then you may want to post on their support board: http://www.phpclasses.org/discuss/
chrisonline
Forum Newbie
Posts: 2
Joined: Sun Sep 11, 2005 10:25 am

Post by chrisonline »

i want any help :lol:
not only from phpclasses...
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

then this is going to be moved to an appropriate location: Misc.
Post Reply