Problem with XML MYSQL PHP Import Script?

[innitboy]

This script turns all the xml tags into arrays and inputs the relevant data into the field names in my table

I cant get it to loop over each result (or top level tag),

It only shows and imports the last result in the resultset

Would appreciate any help?

[code]<?php
    include 'library/config.php';
    include 'library/opendb.php';
$file = "my-xml.xml";

$feed = array();
$key = "";
$info = "";


function startElement($xml_parser,  $attrs ) {
  global $feed; 
  }

function endElement($xml_parser, $name) {
  global $feed,  $info;
  $key = $name;
  $feed[$key] = $info;
  $info = ""; }

function charData($xml_parser, $data ) {
  global $info;
 
 
  $info .= $data; }
$xml_parser = xml_parser_create();
xml_set_element_handler($xml_parser, "startElement", "endElement");
xml_set_character_data_handler($xml_parser, "charData" );
$fp = fopen($file, "r");
while ($data = fread($fp, 8192))
!xml_parse($xml_parser, $data, feof($fp));
xml_parser_free($xml_parser);

$sql= "INSERT INTO section ( ";
$j=0;
$i=count($feed);

foreach( $feed as $assoc_index => $value )
  {
  $j++;
  $sql.= strtolower($assoc_index);
  if($i>$j) $sql.= " , ";
  if($i<=$j) {$sql.= " ) VALUES ('";}
  }
$h=0;
foreach( $feed as $assoc_index => $value )
  {
  $h++;
  $sql.= utf8_decode(trim(addslashes($value)));
  if($i-1>$h) $sql.= "', '";
  if($i<=$h) $sql.= "','');";
  }
  $query=trim($sql);
  echo $value;
if (mysql_query($sql)){
echo "success in table creation.";
} else {
echo "no table created.";
}
echo mysql_error();
  echo $sql;
?> [/code]

[innitboy]

am i missing something like this?

if ($assoc_index = "my_top_level_tag")

{
rest of my code
}

[innitboy]

ok have found out that this piece of code is causing the problem

[code] $feed[$key] = $info;[/code]

just not sure what to replace it with to get it to show each key rather than the last key in the array.

[innitboy]

bump innit

[innitboy]

en autre  bump