','>',$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 1, Frage 4: anguria $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 = 1 AND antwort.fragenr = 4 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 ''; ?>