parse XML and insert data in MySQL table

Question

Hello everyone

I am trying to parse a xml file that i have (using javascript DOM). and then i want to insert this data in a mysql table (using php).

I know how to parse xml data. But i am unable to figure out how to use php and javascript together and insert data in mysql table.

Kindly help me in this.

Best Zeeshan

Answer 1

The JavaScript needs to send the data to the server. There are several ways this can be achieved.

1. Generate a form and submit it
2. Use XMLHttpRequest directly
3. Use a library like YUI or jQuery

Once there, you get the data (from $_POST for example) and insert it into MySQL as normal.

Answer 2

You can use jQuery to do this, for example:

<house>
 <roof>as</roof>


<door>asd</door><window number="12">iles</window></house>

$('path_to_xml',xml).each(function(){ roof = $('roof',this).text(); door = $('door',this).text(); num_wind = $('window',this).attr('number'); });

Answer 3

Why don't you just use PHP DOM to parse the XML ?

e.g:

$doc = new DOMDocument();
$doc->load('book.xml');
echo $doc->saveXML();

After loaded your document $doc you can use the PHP DOM fuctions.