', '>', $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 2, Frage 4: sigaretta $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 sex FROM antwort, informant, ort WHERE fragenr = 4 AND antwort.fragerunde = 2 AND antwort.antwort_informant <> '' AND antwort.informantid = informant.informantid AND informant.ortid = ort.ortid AND (informant.geschlecht LIKE '%' AND informant.informant_alter > 0) 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 ''; ?>