parser sax in php to mysql

[santiz]

i have a parser xml with sax in php, it run very well.now i need to import the data from xml to mysql.i have 4 data in this parser: $zupid, $names, $desc, $linkthese 4 variables have to be inserted in the same line of the database but i dont know hot to do it.post my parser:\[code\] <?php mysql_connect("xx.xxx.xx.xx", "xxxxxxx", "xxxxxxxxx") or die(mysql_error()); mysql_select_db("xxxxxxxx") or die(mysql_error()); echo "connesso<br>"; $table = "copiaTabella"; $empty = "DELETE FROM `".$table."`"; mysql_query($empty); echo "tabella pulita<br>"; class Content_Handler { function Content_Handler(){} function start_element($parser, $name, $attrs) { global $desc, $names, $link; if ($name == "PRODUCT"){ $zupid = ($attrs["ZUPID"]); echo "$zupid<br>"; } if ($name == "DESCRIPTION") { $desc = true;} if ($name == "NAME") { $names = true;} if ($name == "DEEPLINK") { $link = true;} } function end_element($parser, $name) { global $desc, $names, $link; if ($name == "PRODUCT") { print "<br />"; } if ($name == "DESCRIPTION") { echo "<br />"; $desc = false;} if ($name == "NAME") { echo "<br />"; $names = false;} if ($name == "DEEPLINK") { echo "<br />"; $link = false;} } function characters($parser, $chars) { global $desc, $names, $link; if($names){echo $chars;} if($desc){echo $chars;} if($link){echo $chars;} } } $handler = new Content_Handler(); $cat_parser = xml_parser_create("UTF-8"); xml_parser_set_option($cat_parser, XML_OPTION_TARGET_ENCODING, "UTF-8"); xml_set_object($cat_parser, $handler); xml_set_element_handler($cat_parser, "start_element", "end_element"); xml_set_character_data_handler($cat_parser, "characters"); $file = "my.xml"; if ($file_stream = fopen($file, "r")) { while ($data = http://stackoverflow.com/questions/11120177/fread($file_stream, 4096)) { $this_chunk_parsed = xml_parse($cat_parser, $data, feof($file_stream)); if (!$this_chunk_parsed) { $error_code = xml_get_error_code($cat_parser); $error_text = xml_error_string($error_code); $error_line = xml_get_current_line_number($cat_parser); $output_text ="Parsing problem at line $error_line: $error_text"; die($output_text); } } } else { die("Can't open XML file."); } xml_parser_free($cat_parser); ?>\[/code\]