Hmm, maybe not URL encoding.
What happens when you call the php page directly - in Firefox, does it
show you the XML, or do you have to view the source? (The former would
mean firefox considered it valid xml)
Does the XML show all the url-encoded characters, or is it just in Flash?
As an aside to help with your XML, you could do this - it might not help
your encoding, check the results by echoing them out I guess?
//Don't worry about \n and whitespace in your $response var, the
DOMDocument will sort it out ;)
//You don't need to include the <?xml?> tag either.
$response = ....
//...
$doc = new DOMDocument();
$doc->preserveWhiteSpace = false;
$doc->formatOutput = true;
$doc->loadXML($response);
echo $doc->saveXML();
Another trick might be to do this to make your "output" a bit more
easy to automate:
$fields = array("code", "datum", "klant_nummer", ...);
while($row = mysql_fetch_assoc($result)) {
$response .="<project>";
foreach($fields as $field) {
$response .= "<project_${field}><![CDATA[" .$row["project_"
.$field] ."]]></project_${field}">;
}
HTH
Glen
On 20/07/2011 15:39, Cor wrote:
This is it without the DB-conection ofcourse:
if (isset($_POST['sendRequest'])&& $_POST['sendRequest'] ==
"read_all_projects") {
$sql = "SELECT * FROM tbl_projecten";
$result = mysql_query($sql);
header("Content-type: text/xml");
$response ='<?xml version="1.0" encoding="UTF-8" ?>';
$response .="\n<data>";
while($row = mysql_fetch_object($result)){
$response.='<project>';
$response.='<project_code><![CDATA['.$row->project_code.']]></project_code>'
;
$response.='<project_datum><![CDATA['.$row->project_datum.']]></project_datu
m>';
$response.='<project_klant_nummer><![CDATA['.$row->project_klant_nummer.']]>
</project_klant_nummer>';
$response.='<project_naam><![CDATA['.$row->project_naam.']]></project_naam>'
;
$response.='<project_omschrijving><![CDATA['.$row->project_omschrijving.']]>
</project_omschrijving>';
$response.='<project_werkzaamheden><![CDATA['.$row->project_werkzaamheden.']
]></project_werkzaamheden>';
$response.='<project_ordernummer_klant><![CDATA['.$row->project_ordernummer_
klant.']]></project_ordernummer_klant>';
$response.='<project_contactpersoon><![CDATA['.$row->project_contactpersoon.
']]></project_contactpersoon>';
$response.='<project_aanneemsom><![CDATA['.$row->project_aanneemsom.']]></pr
oject_aanneemsom>';
$response.='<project_opdracht><![CDATA['.$row->project_opdracht.']]></projec
t_opdracht>';
$response.='</project>';
}
$response.="</data>";
print $response;
}
Best regards,
Cor
-----Original Message-----
From: flashcoders-boun...@chattyfig.figleaf.com
[mailto:flashcoders-boun...@chattyfig.figleaf.com] On Behalf Of Henrik
Andersson
Sent: woensdag 20 juli 2011 16:37
To: Flash Coders List
Subject: Re: [Flashcoders] Incorrect XML from PHP to Flash
Your php code is broken then.
_______________________________________________
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
_______________________________________________
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
_______________________________________________
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
