[RESOLVED] XML to MySQL script

[Pulsorock]

Hello,

I'm looking for a script or a php class to import from a XML file to a MySQL table.

I found this one:
http://www.phpclasses.org/browse/package/782.html

but can't make it work.

Any other suggestion?

Thanks!

[Pulsorock]

This is a example of the XML I want to import to mysql.

<current-conditions gmt="1184597874" gmt-offset="0">
  <date>Monday, July 16</date> 
  <dateabbr>07/16/07</dateabbr> 
  <time>02:57 PM</time>
  <reporting-station code="TJSJ">
  <city>San Juan</city> 
  <state>Puerto Rico</state> 
  <temperature>78</temperature> 
  <dew-point>75</dew-point> 
  <relative-humidity>90</relative-humidity> 
  <wind-chill>78</wind-chill> 
  <heat-index>84</heat-index> 
  <wind-direction>E</wind-direction> 
  <wind-direction-degrees>090</wind-direction-degrees> 
  <wind-speed>5</wind-speed> 
  <wind-gusts /> 
  <pressure>1017.4</pressure> 
  <high-today>82</high-today> 
  <low-today>77</low-today> 
  <precip-today>0.10</precip-today> 
  <snow-depth /> 
  <visibility>10.0</visibility> 
  <ceiling /> 
  <pressure-tendency>R</pressure-tendency> 
  <altimeter>30.05</altimeter> 
  <highyesterday>91</highyesterday> 
  <lowyesterday>76</lowyesterday> 
  <sky-conditions>Rain</sky-conditions> 
  <icon-select>10</icon-select> 
  <state-abbr /> 
  </reporting-station>
  <reporting-station code="ZSSS">
  <city>Shanghai</city> 
  <state>China</state> 
  <temperature>82</temperature> 
  <dew-point>75</dew-point> 
  <relative-humidity>79</relative-humidity> 
  <wind-chill>82</wind-chill> 
  <heat-index>90</heat-index> 
  <wind-direction>S</wind-direction> 
  <wind-direction-degrees>170</wind-direction-degrees> 
  <wind-speed>13</wind-speed> 
  <wind-gusts /> 
  <pressure /> 
  <high-today>90</high-today> 
  <low-today>75</low-today> 
  <precip-today /> 
  <snow-depth /> 
  <visibility>3500</visibility> 
  <ceiling /> 
  <pressure-tendency /> 
  <altimeter>29.62</altimeter> 
  <highyesterday>91</highyesterday> 
  <lowyesterday>77</lowyesterday> 
  <sky-conditions>Fog</sky-conditions> 
  <icon-select>4</icon-select> 
  <state-abbr /> 
  </reporting-station>
</current-conditions>

and so on for each reporting-station...

and this is the table I want to import the xml to....

CREATE TABLE `current` (
  `reporting-station` varchar(100) NOT NULL default '',
  `city` varchar(100) default NULL,
  `state` varchar(100) default NULL,
  `temperature` varchar(100) default NULL,
  `dew-point` varchar(100) default NULL,
  `relative-humidity` varchar(100) default NULL,
  `wind-chill` varchar(100) default NULL,
  `heat-index` varchar(100) default NULL,
  `wind-direction` varchar(100) default NULL,
  `wind-direction-degrees` varchar(100) default NULL,
  `wind-speed` varchar(100) default NULL,
  `wind-gusts` varchar(100) default NULL,
  `pressure` varchar(100) default NULL,
  `high-today` varchar(100) default NULL,
  `low-today` varchar(100) default NULL,
  `precip-today` varchar(1001) default NULL,
  `snow-depth` varchar(100) default NULL,
  `visibility` varchar(100) default NULL,
  `ceiling` varchar(100) default NULL,
  `pressure-tendency` varchar(100) default NULL,
  `altimeter` varchar(100) default NULL,
  `highyesterday` varchar(100) default NULL,
  `lowyesterday` varchar(100) default NULL,
  `sky-conditions` varchar(100) default NULL,
  `icon-select` varchar(100) default NULL,
  `state-abbr` varchar(100) default NULL,
  PRIMARY KEY  (`reporting-station`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

[Pulsorock]

Nevermind... I parsed each field manually and it runs fast enough. Later I post what I did... thanks...