Welcome to WebmasterWorld Guest from 54.227.1.130

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

PHP XML Parser into .sql file

     

alpacinofr

7:33 am on May 28, 2008 (gmt 0)

5+ Year Member



Hi all

I need to do XML import in MySQL database. I have found this script and it reads and parse my XML file to display it in browser.

How can I modify code to write results into SQL style format file with INSERT statements...

Thanks


<?php

$file = "sodim.xml";

function contents($parser, $data){
echo $data;
}

function startTag($parser, $data){
echo "<b>";
}

function endTag($parser, $data){
echo "</b><br />";
}

$xml_parser = xml_parser_create();

xml_set_element_handler($xml_parser, "startTag", "endTag");

xml_set_character_data_handler($xml_parser, "contents");

$fp = fopen($file, "r");

$data = fread($fp, 80000);

if(!(xml_parse($xml_parser, $data, feof($fp)))){
die("Error on line " . xml_get_current_line_number($xml_parser));
}

xml_parser_free($xml_parser);

fclose($fp);

?>

ahmedtheking

2:48 pm on May 29, 2008 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



You need to focus on these functions:

function startTag($parser, $data){
echo "<b>";
}

function endTag($parser, $data){
echo "</b><br />";
}

xml_set_element_handler($xml_parser, "startTag", "endTag");

As xml_set_element_handler() tells PHP how to handle each element. So, if you rewrote them so that instead of putting the data inside <b></b>, it put them inside '' and added the VALUES and other SQL, you'd be there!

 

Featured Threads

Hot Threads This Week

Hot Threads This Month