using PHP & MySQL to Input XML data to database!

[balean]

Hi guys,

I need help. I am trying to extract data from XML file. I am using all the fucntions needed to parse the xml data every thing working fine, but what I am looking for is to take the string data in each element and enter it to database. for example

I have the following xml file "sitecontent.xm l" .
--------------------------
<?xml version="1.0" encoding="UTF-8" ?>
- <content>
<link>http://www.web.com</link>
<title>Title name </title>
<description>Th is line will be description bla bla </description>
<keywords>Thi s line will be all data ..............e tc </keywords>
</content>
-------------------------
and my PHP code will be like this

----------------------
<?php
include ('dbconnet.php' );
$parser=xml_par ser_create();
xml_set_element _handler($parse r,"start","stop ");
xml_set_charact er_data_handler ($parser,"char" );
$fp=fopen("site content.xml","r ");
while ($data=fread($f p,4096))
{
xml_parse($pars er,$data,feof($ fp)) or
die (sprintf("XML Error: %s at line %d",
xml_error_strin g(xml_get_error _code($parser)) ,
xml_get_current _line_number($p arser)));
}
function start($parser,$ element_name, $attribs)
{
switch($element _name)
{
case "CONTENT":
echo "<p>-- CONTENT --</p><br/>";
break;
case "LINK":
echo "<B>Link:</B> ";
break;
case "TITLE":
echo "<B>Title:</B> ";
break;
case "DESCRIPTIO N":
echo "<B>Description :</B> ";
break;
case "KEYWORDS":
echo "<B>Keyword s:</B> ";
Break;
}
}
function stop($parser,$e lement_name)
{
echo "<br /><br />";
}
function char($parser,$d ata)
{
echo $data;
}
xml_parser_free ($parser);
----------------------------
The output is like this

-- CONTENT --


Link: http://www.web.com

Title: Title name

Description: This line will be description bla bla

Keywords: This line will be all data ..............e tc


---------------
What I need to do is take link content which it is http://www.web.com insert it to my table where field name = link
same thing with the other "Title name " to field name Title , "This line will be descritoption bla bla " to discription filed and so on.

If you know any way of tools to do that I will be greaty apritiated.

Balean