Creating XML File from PHP but get HTML one [duplicate]

Question

I'm using this code to create an XML file (not filed) from a PHP one. Here is the code:

<?php
include_once ('conf.php');
$conn =  mysql_connect($host, $user, $password);    
if (!$conn) {
    die('No hay conexion a la BBDD');
}
$bd = mysql_select_db($name, $conn);
if (!$bd) {
    die ('Error en la BBDD');
}
$query = "select * from usuarios where activo = 0 order by puntuacion desc limit 0, 10";
$res = mysql_query($query, $conn);
$salida = '<?xml version="1.0" encoding="utf-8" standalone="yes" ?>'."\n";
$salida .= '<score>'."\n";
$i = 1;
while ($row = mysql_fetch_array($res))
{
    $salida.= '<posicion num="' . $i . '">'."\n";
    $salida .= '<id>'.$row['id'].'</id>'."\n";
    $salida .= '<puntuacion>'.$row['puntuacion'].'</puntuacion>'."\n";
    $salida .= '</posicion>'."\n";
    $i++;
}
$salida .= '</score>';
mysql_free_result($res);
mysql_close($conn);
echo $salida;
?>

When I call this file I obtain (using Chrome Inspector) the XML file embeded in a HTML file with its html, head and body tags. I want this php file to get readed by an ajax's get function.

Any ideas about what is wrong?

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial. — j0k
– j0k, Commented Feb 4, 2013 at 10:03
Where do you tell Chrome inspector that it is an XML file? You aren't setting a Content-Type: application/xml header anywhere. But if you simply inspect source code manually you'll see the raw output. — Álvaro González
– Álvaro González, Commented Feb 4, 2013 at 10:27

ickmund · Accepted Answer · 2013-02-04 10:08:34Z

2

Add a header specifying that you're outputting XML. header('Content-Type: text/xml') right before you echo.

answered Feb 4, 2013 at 10:08

ickmund

2891 gold badge2 silver badges9 bronze badges

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

1 Comment

DGM.- Over a year ago

Fixed!!! Thanks all of you.

Dyin · Accepted Answer · 2013-02-04 10:23:50Z

2

Read the PHP manual about XML Manipulation.

You will find juicy tools there to fetch, manipulate and create XML documents.

Also, before making any output, add a line header ("Content-type: text/xml"); to your script, to specify for the client entity, that you are going to send XML and it should be parsed as XML. header — Send a raw HTTP header

answered Feb 4, 2013 at 10:23

Dyin

5,4058 gold badges46 silver badges70 bronze badges

2 Comments

Álvaro González Over a year ago

That's it. It's very difficult to generate valid XML with raw echo statements.

hakre Over a year ago

@ÁlvaroG.Vicario: Actually it's equally difficult to generate valid HTML with raw ech statements, that's why you use DOMDocument for the HTML all the time, right? ;)

Collectives™ on Stack Overflow

Creating XML File from PHP but get HTML one [duplicate]

2 Answers 2

1 Comment

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Linked

Related