[RESOLVED] xml to mysql table insert

BEFOR

I need to insert repeat values from xml feed

This is php version 4 (no SimpleXML) and not certain if a if parcer is needed for this. Would like to structure around this insert, if possible.

xml address will be at:
http://aenergy.com/b.xml

mysql_query("INSERT INTO Articles (Title, ArticleID, Descript, Date) VALUES ('$TITLE', '$ARTICLEID', $DESCRIPT, CURRENT_TIMESTAMP)"); 

[I]sample xml:[/I]
<source>
<article>
<title>wind turbine energy</title> 
<date> Weds, 22 Apr 2009 20:00:00</date>
<articleid>4435664</articleid>
<description>Summary information on the generation of electricity by clean means.<description>
</article>
<article>
<title>geothermal extration</title> 
<date> Mon, 20 Apr 2009 18:00:00</date>
<articleid>4455211</articleid>
<description>The energy source as it evolves into a more practical alternative<description>
</article>
<source>

Weedpacket

You will need a parser of some sort to parse the document. If you don't want to write your own there are the [man]xml[/man] parser or [man]DOMXML[/man] extensions.

Also note that PHP 4 has been dead for more than a year now and moribund for several. The longer upgrading is delayed the more it will hurt when it becomes necessary.

djjjozsi

@: if I am not indiscreet what sort of tool you have ?🙂

This code was generated by a tool.

i'm making this tool to make tools to generate tools 🙂
here 🙂

Weedpacket

djjjozsi wrote:
@: if I am not indiscreet what sort of tool you have ?

Visual Studio. A lot of its templates for autogenerated code contain that line; I guess no-one at Microsoft realised what it's like to read.

Zpixel

download any php classes from phpclasses.org. php parser class might help.

djjjozsi

@: becouse i'm planning generators, and looking for ideas 🙂
My aim is to build a new framework 🙂 That's why i'm asking.

thanks,
jjozsi