XML file into MySQL table via upload?

[dniezby]

You will have to forgive me, it has been a LONG time since I've needed to code anything by hand. I need a little help on this issue as I've seen conflicting methods and can't seem to make heads or tails.

Here is the situation. My site is a poker league site. As our results are tracked and finalized, an XML file is exported with the tournament results.

I need to upload that file to my server, have it read by a script and inserted into my MySQL tables.

How can I do this or would you recommend a different method?

Here is the XML data (trimmed down of course):

<?xml version="1.0" encoding="ISO-8859-1"?>

<Tournament type="TD v2" League="NAPoker.org" Season="2013-1" Name="2013-09-19-1930-COA" TournamentType="No Limit" TournamentGame="Texas Hold 'Em" TournamentStartDate="2013-09-19 19:36:00" TournamentEndDate="2013-09-19 22:34:40" TournamentComments="">

 <Players>
  <Player Name="" FirstName="David" LastName="SMITH" Rank="22" TournamentPts="20 RoundOut="2" TimeOut="2013-09-19 19:58:51"/>
 </Players>

This SHOULD all go into two tables. The Tournament table - called "Events" and it should relate to another table "results" or "standings"

Basically, how can I automate this import?

Thanks in advance.

[bradgrafelman]

Upload the XML file to the server (see [man]features.file-upload[/man]), use [man]DOM[/man] or [man]SimpleXML[/man] to parse it, and generate and execute the appropriate SQL queries based on the DB schema.