parse XML and insert data in MySQL table

Question

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

BenMorel · Accepted Answer · 2013-12-07 16:46:16Z

2

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 functions.

edited Dec 7, 2013 at 16:46

BenMorel

37k52 gold badges208 silver badges339 bronze badges

answered Jun 17, 2009 at 14:59

Freddy

3021 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Zeeshan Rang Over a year ago

I would love to use php dom. it will make things so very easy to do right? can you please give me a few sample, where i can learn about how to parse xml in php dom.

Community · Accepted Answer · 2017-05-23 12:19:36Z

2

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

Generate a form and submit it
Use XMLHttpRequest directly
Use a library like YUI or jQuery

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

edited May 23, 2017 at 12:19

CommunityBot

11 silver badge

answered Jun 17, 2009 at 14:57

Quentin

949k136 gold badges1.3k silver badges1.4k bronze badges

2 Comments

Zeeshan Rang Over a year ago

this is stupid of me, but can you tell me how should i make a form that has all my xml parsed data, and then which i can submit to php on server so that it can insert each record of my xml in a table

Quentin Over a year ago

var form = document.createElement('form'); form.action='foo.php'; form.method="post"; var data1 = document.createElement('input'); data1.value = myVar; data1.name="data1"; form.appendChild(data1); document.body.appendChild(form); form.submit(); /* Simplified of course */

red777 · Accepted Answer · 2009-06-17 14:59:16Z

1

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'); });

answered Jun 17, 2009 at 14:59

red777

3541 gold badge3 silver badges11 bronze badges

Collectives™ on Stack Overflow

parse XML and insert data in MySQL table

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related