What am i doing wrong? create xml using php

Question

I am following this tutorial step by step http://code.google.com/apis/maps/articles/phpsqlajax.html . Actually I copy pasted the code and created the database, added the data to the table, downloaded the provided php and html files but when i actually try to run the page that will create the xml file i get this error. Can anyone guess what is wrong? I am using XAMPP 1.7.4 [PHP: 5.3.5]

(The google tutorial suggests 3 ways to generate the xml file. I tried all 3 of them and the same error appears on the first 2 and an "error on line 10" (which is the line that php script begins) appears when i try the 3rd suggested way. I am thinking if this wont work to use mysqldump command in order to export the xml file i need.) enter image description here

I don't know much about this, but could the fact that you have declared the content type to be text/html be the problem? — Drew Galbraith
– Drew Galbraith, Commented Sep 22, 2011 at 23:55
You clearly didn't follow the tutorial correctly, otherwise you'd have only <markers>...</markers> as your output. — NullUserException
– NullUserException, Commented Sep 22, 2011 at 23:57
Well i just copy pasted the provided code. I dont know why there is an html part above <markers> — redfrogsbinary
– redfrogsbinary, Commented Sep 23, 2011 at 0:03

bradley.ayers · Accepted Answer · 2011-09-22 23:59:25Z

1

You have two root elements in your XHTML: html and markers. This is why your browser correctly considers it to be invalid.

The problem with blindly copying/pasting code is that when you come across a problem it's very difficult to solve, because you don't understand what the code is doing. I suggest you read through the code closely. When you understand it, you'll be able to fix it.

Essentially you'll want to remove all of the output up until the <markers> tag. Perhaps the HTML file you're using is incorrect.

edited Sep 22, 2011 at 23:59

answered Sep 22, 2011 at 23:38

bradley.ayers

38.5k14 gold badges98 silver badges101 bronze badges

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

3 Comments

redfrogsbinary Over a year ago

there is no obvious problem. It is copy paste from google tutorial.

bradley.ayers Over a year ago

Include the page source in your question.

redfrogsbinary Over a year ago

i posted a print screen of the source

derp · Accepted Answer · 2011-09-23 01:33:11Z

0

-EDIT-
Problem was in the connection to the database, value for $host and/or $user and/or $pass was incorrect or not provided.

If you use version 2 (phpsqlajax_genxml2), edit the file at line 15 replacing localhost with 'localhost'.

If you use version 3 (phpsqlajax_genxml3), edit the file at line 13replacing localhost with 'localhost'.

Then try again.

edited Sep 23, 2011 at 1:33

answered Sep 23, 2011 at 0:21

derp

3,07020 silver badges16 bronze badges

8 Comments

derp Over a year ago

weird I was getting the same error but that fixed it for me, gonna try find something else.

redfrogsbinary Over a year ago

Nothing changed... I cant explain how html is created out of nothing.

derp Over a year ago

You know, on your screenshot it says undefined localhost bla bla.., could you post a screenshot of what it says after you replace localhost for 'localhost'.

redfrogsbinary Over a year ago

I edited the screenshot. Is there a chance that it is apache's fault?

derp Over a year ago

You know, I have no idea, I reduced the script to try and find the culprit but it still seems like it's the connection line to me, could you try the following: gist.github.com/1236521 and tell me if you can get an xml without un-commenting anything? if not I give up :S

|

Collectives™ on Stack Overflow

What am i doing wrong? create xml using php

2 Answers 2

3 Comments

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related