PHP output doesn't print in xml format

Question

i have the following code.

$stmt = $conn->prepare('SELECT sponsor_path FROM sponsors WHERE conference_id = ?');
$stmt->execute(array($cid));

$sponsorsImg = $stmt->fetchall (PDO::FETCH_OBJ);

$xml_output = "<?xml version=\"1.0\" ?>";
$xml_output .= "<sponsors>";
foreach ($sponsorsImg as $spImg){
    $xml_output .= "<sponsor>\n";
    $xml_output .= "<image>".$spImg->sponsor_path."</image>\n";
    $xml_output .= "</sponsor>\n";
}
$xml_output .= "</sponsors>";

echo $xml_output;

Instead of printing the results in xml format i get only the $spImg->sponsor_path's content in plain text. Any ideas?

use right click on html page and show source

Jérôme Teisseire
– Jérôme Teisseire

2014-10-24 11:30:47 +00:00
Commented Oct 24, 2014 at 11:30 — Jérôme Teisseire
– Jérôme Teisseire, Commented Oct 24, 2014 at 11:30

dnshio · Accepted Answer · 2014-10-24 11:29:49Z

3

Most browsers will render markup that looks like XML. So it might be the case that the XML that you want is actually produced but not displayed correctly on the browser.

Try the following:

Set the content type before outputting:

header('Content-Type: text/xml');
echo $xml_output;

If the output looks the same, then right click on the page and select view source. You should see your XML markup as intended there.

answered Oct 24, 2014 at 11:29

dnshio

9341 gold badge8 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

PHP output doesn't print in xml format

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related