', '>', $xmlStr); $xmlStr = str_replace('"', '"', $xmlStr); $xmlStr = str_replace("'", ''', $xmlStr); $xmlStr = str_replace("&", '&', $xmlStr); $xmlStr = str_replace("Á", 'Á', $xmlStr); $xmlStr = str_replace("á", 'á', $xmlStr); $xmlStr = str_replace("À", 'À', $xmlStr); $xmlStr = str_replace("á", 'à', $xmlStr); $xmlStr = str_replace("Ì", 'Ì', $xmlStr); $xmlStr = str_replace("ì", 'ì', $xmlStr); $xmlStr = str_replace("Ù", 'Ù', $xmlStr); $xmlStr = str_replace("ù", 'ù', $xmlStr); $xmlStr = str_replace("É", 'É', $xmlStr); $xmlStr = str_replace("é", 'é', $xmlStr); $xmlStr = str_replace("È", 'È', $xmlStr); $xmlStr = str_replace("è", 'è', $xmlStr); $xmlStr = str_replace("Ó", 'Ó', $xmlStr); $xmlStr = str_replace("ó", 'ó', $xmlStr); $xmlStr = str_replace("Ò", 'Ò', $xmlStr); $xmlStr = str_replace("ò", 'ò', $xmlStr); return $xmlStr; } // Query for Fragerunde 5, Frage 6: pantofole $query = "SELECT DISTINCT(ort.plz) AS plz, ort.ortsname AS ortsname, ort.lat AS lat, ort.lng AS lng, antwort.antwort_informant AS response, informant.geschlecht AS geschlecht, informant.informant_alter AS inf_alter FROM antwort INNER JOIN informant ON antwort.informantid = informant.informantid INNER JOIN ort ON informant.ortid = ort.ortid WHERE antwort.fragerunde = 5 AND antwort.fragenr = 6 AND antwort.antwort_informant <> '' ORDER BY antwort.antwort_informant;"; $result = mysqli_query($db_server, $query); if (!$result) { die('Invalid query: ' . mysqli_error()); } header("Content-type: text/xml"); // Start XML file, echo parent node echo ''; // Iterate through the rows, printing XML nodes for each while ($row = @mysqli_fetch_assoc($result)) { $response = parseToXML($row['response']); // Add to the XML Document Node echo ''; } // End of XML file echo ''; ?>