Export Results in XML Format

HappyHourHotSpots.com

Hello everyone,

I am trying to display the results of a query in XML format and cant
seem to get it to work. Has anyone had any trouble exporting PHP/MySQL
-> XML? I am using the following format:
File: xmlexport.php

<?php header("Content-Type: text/xml"); ?>
<?xml version"1.0"?>
<rss version="2.0">
<channel>

<?php
// Database Functions Here to Access Data
echo "<item>$iteminfofromdb</item>";
?>

</channel>
</rss>
This is the basic format i am following. When I just put some plain
XML data in the file and try to access it through my web browser
nothing shows up either. Is there something about using the .php
extension as an XML file?

Thanks,
-Rick

Jul 17 '05 #1

Follow Post Reply

11026

Joshua Beall

"HappyHourHotSpots.com" <Ri*********@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

Hello everyone,

I am trying to display the results of a query in XML format and cant
seem to get it to work. Has anyone had any trouble exporting PHP/MySQL
-> XML? I am using the following format:
File: xmlexport.php

<?php header("Content-Type: text/xml"); ?>
<?xml version"1.0"?>
<rss version="2.0">
<channel>

<?php
// Database Functions Here to Access Data
echo "<item>$iteminfofromdb</item>";
?>

</channel>
</rss>
This is the basic format i am following. When I just put some plain
XML data in the file and try to access it through my web browser
nothing shows up either. Is there something about using the .php
extension as an XML file?

Thanks,
-Rick

Linkage?

Jul 17 '05 #2

Daniel Tryba

HappyHourHotSpots.com <Ri*********@gmail.com> wrote:

File: xmlexport.php

<?php header("Content-Type: text/xml"); ?>
<?xml version"1.0"?>
<rss version="2.0"> [snip] </rss>
This is the basic format i am following. When I just put some plain
XML data in the file and try to access it through my web browser
nothing shows up either.

Define nothing shows up! You did look at the source and not at the
rendered version?

Jul 17 '05 #3

HappyHourHotSpots.com

Yeah, the source shows only <html><body></body></html>.

Jul 17 '05 #4

Daniel Tryba

HappyHourHotSpots.com <Ri*********@gmail.com> wrote:

Yeah, the source shows only <html><body></body></html>.

Which aren't present in the show script, you shouldn't use IE to debug.

For proper debugging (withaout an actual debugger):
-error_reporting to the max (E_ALL for php4)
-use a client that doesn't mess with output (lynx -source, of a moz/fire*
with with a plugin, or even a packetsniffer)

Jul 17 '05 #5

Nick Robins

HappyHourHotSpots.com wrote:

Hello everyone,

I am trying to display the results of a query in XML format and cant
seem to get it to work. Has anyone had any trouble exporting
PHP/MySQL
-> XML? I am using the following format:
File: xmlexport.php

<?php header("Content-Type: text/xml"); ?>
<?xml version"1.0"?>
<rss version="2.0">
<channel>

<?php
// Database Functions Here to Access Data
echo "<item>$iteminfofromdb</item>";
?>

</channel>
</rss>
This is the basic format i am following. When I just put some plain
XML data in the file and try to access it through my web browser
nothing shows up either. Is there something about using the .php
extension as an XML file?

Thanks,
-Rick

It could be that your server has short_open_tag set to on and is having
problems with the xml declaration (the parser sees the <? part of <?xml
and attempts to parse the declaration as php).

If this is the problem, you can either set short_open_tag to 'off' (edit
php.ini or use ini_set() ) or echo / print / etc the xml declaration.

Nick

Jul 17 '05 #6

HappyHourHotSpots.com

I was thinking that too, but I have short_open_tags set to off. I
remember seeing that when i was setting up my server so i left it off
just for this reason.

Jul 17 '05 #7

HappyHourHotSpots.com

That was actually the show source output that i got from Firefox. Is
there some sort of trick to writing XML with PHP? I figured that if
the file extension ended in PHP it wouldnt matter as long as what was
outputted is in proper XML format.

Jul 17 '05 #8

HappyHourHotSpots.com

OK, i changed all my echo()'s to print() instead and now that seems to
have worked but now I am getting an error that says "XML Parsing Error:
xml processing instruction not at start of external entity"

Jul 17 '05 #9

Export Results in XML Format

This discussion thread is closed

Similar topics