Bonjour,

j'ai cette erreur :Erreur d'analyse XML : données incompréhensibles après l'élément de document

lorsque j’exécute mon code suivant :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
<?php
 ini_set('display_errors', true);
 ini_set('display_startup_errors', true);
 error_reporting(E_ALL);
  if(isset($_GET['hotelId']) ||  isset($_GET['login']) ||  isset($_GET['pass']) )
{
    # Get the ID
    $hotelId = $_GET['hotelId'];
	$login   = $_GET['login'];
	$pass    = $_GET['pass'];
 
include_once 'connect.php';
 
 
mysql_select_db($dbname, $conn);
 
$sqlp ="SELECT partenaire.login, partenaire.pass
        FROM partenaire where login='$login' and pass='$pass' ";
		$req = mysql_query($sqlp)or die(mysql_error());
		$datalog = mysql_fetch_assoc($req);
 
    # Make sure the ID is in fact a valid ID
    if(!is_numeric($hotelId) || ($hotelId <= 0)) {
        die("HotelID is unidentified");
        }
 
	if($datalog['login']!=$login || ($datalog['pass']!=$pass)) {
 
	     header('Content-type: text/xml');
		$xml = new DOMDocument('1.0', 'UTF-8');
		$message = $xml->createElement('message');
		$message = $xml->appendChild($message);
 
		$failure = $xml->createElement('failure');
   		$failure = $message->appendChild($failure);
 
		$comment = $xml->createElement('comment');
    	$comment = $failure->appendChild($comment);
 
       // create CDATA section
        $cdata = $xml->createCDATASection("Incorrect login/password");
        $comment->appendChild($cdata);
        echo $xml->saveXML();
     //    die("The Login or pass is invalid!");
        }
 
 
$sql = "SELECT DISTINCT propertys.propertys_uid,propertys.property_name,rooms.room_uid,rooms.room_name,rates.rates_uid, where propertys.propertys_uid='$hotelId'  ORDER BY rooms.room_uid"; 
$qry = mysql_query($sql) or die(mysql_error());
 
$xml = new DOMDocument('1.0', 'UTF-8');
$xml->formatOutput = true;
$message = $xml->createElementNS(NULL, 'message');
$message->setAttributeNS('http://www.w3.org/2000/xmlns/','xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance');
$message->setAttributeNS('http://www.w3.org/2000/xmlns/','xmlns:xsd','http://www.w3.org/2001/XMLSchema');
$xml->appendChild($message);
 
 
if (mysql_num_rows($qry))
{
 
 
    $rooms= $xml->createElement('rooms');
	$rooms = $message->appendChild($rooms);
	$data = mysql_fetch_assoc($qry);
	$rooms->setAttribute("hotelId",$data['propertys_uid']);
    $rooms->setAttribute("hotelName", $data['property_name']);
 
	while ($data = mysql_fetch_assoc($qry)) {
 
    if (!isset($room) || $data['room_uid'] != $room->getAttribute('code')) {
        $room = $xml->createElement('room');
        $room = $rooms->appendChild($room);
        $room->setAttribute("code",$data['room_uid']);
        $room->setAttribute("name", $data['room_name']);
        $room->setAttribute("maxOccupancy", $data['maxpeople']);
        $room->setAttribute("minOccupancy", $data['minpeople']);
        $rooms->appendChild($room);
    }
 
    $rate = $xml->createElement('rate');
    $rate = $room->appendChild($rate);
    $rate->setAttribute("code",$data['rates_uid']);
    $rate->setAttribute("name", $data['rate_title']);
    //$rate->setAttribute("regime", $data['room_class_abbv']);
}	  
 
   // $xml->appendChild($rooms);
   $xml->appendChild($message);
}
 
header('Content-type: text/xml');
mysql_set_charset('utf8');
//header('Content-type: text/plain');
header('Charset: utf-8');
//echo htmlentities($xml->saveXML());
echo $xml->saveXML();
}
 else
{
header('Content-type: text/xml');
$xml = new DOMDocument('1.0', 'UTF-8');
$message = $xml->createElement('message');
$message = $xml->appendChild($message);
 
$failure = $xml->createElement('failure');
    $failure = $message->appendChild($failure);
 
	$comment = $xml->createElement('comment');
    $comment = $failure->appendChild($comment);
 
// create CDATA section
      $cdata = $xml->createCDATASection("Incorrect login/password");
      $comment->appendChild($cdata);
      echo $xml->saveXML();
 
	//echo "Error! No ID was passed.";
}
 
?>
Merci de vous réponse