', '>', $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 8: immondizia $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 = 8 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;"; // (antwort_informant REGEXP " . $query_string_1 . " or antwort_informant REGEXP " . $query_string_2 . " or antwort_informant REGEXP " . $query_string_3 . " or antwort_informant REGEXP " . $query_string_4 . ") and $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 ''; ?>