Problem with " and ' in a PHP->XML script!!!!

3stripe

Hello, this is a follow up to my last post about a Flash message board... the last part is some php which parses the database to an xml format ready for flash to read.....

I can't get 's and "s to work properly though... they stop the code working, although they do seem to be working for the 'body' field for some reason :queasy:

Could anyone help me on this possibly??? I know it's somewhere in the last 10 lines or so...

<?php
#***********************************
#  XML OUTPUT
#***********************************

define('********** , TRUE);
include('admin/functions.php');


   $DBhost = "*******";   // Database Server
   $DBuser = "*******";            // Database User
   $DBpass = "*******";            // Database Pass
   $DBName = "********";            // Database Name


   // Connect to mySQL Server
   $DBConn = mysql_connect($DBhost,$DBuser,$DBpass) or die("Error in News Application: " . mysql_error());
   // Select mySQL Database
   mysql_select_db($DBName, $DBConn) or die("Error in News Application: " . mysql_error());

$query = 'SELECT id, author, title, body, thedate, intro, FROM_UNIXTIME(timestamp, \'%M %D %Y\') date  

 					FROM *********
 					LIMIT 20';

$result = mysql_query($query);

$nl = "\r\n";

echo '<?xml version="1.0" encoding="ISO-8859-1"?>' . $nl;
  echo '<ROOT>' . $nl;

 while($r = mysql_fetch_array($result)){
 	$c = str_replace("´", "'", $r['author']);
 	$c = str_replace("´", "'", $r['date']);
 	$c = str_replace("´", "'", $r['title']);
 	$c = str_replace("´", "'", $r['intro']);
 	$c = str_replace("´", "'", $r['body']); 	
	$c = str_replace("\n", "", $c);
 	echo '<news id="' . $r['id'] . '" title="' . stripslashes2($r['title']) . '" intro="' . stripslashes2($r['intro']) . '"  date="' . $r['date'] . '" author="' . stripslashes2($r['author']) . '">' . $nl;
 	echo '<body><![CDATA[' . stripslashes2($c) . ']]></body>' . $nl;
 	echo '</news>' . $nl;


 }

 echo '</ROOT>' . $nl;

 ?>

vaaaska

Because this line needs some slashes?

 echo '<?xml version=\\"1.0\\" encoding=\\"ISO-8859-1\\"?>' . $nl;

or perhaps like this...

 echo "<?xml version='1.0' encoding='ISO-8859-1'?>" . $nl;

3stripe

hello, just tried both of those options and they don't help, it's something further down from this line.....

thorpe

just a thought. this <? has to confuse php as it can elso be used as the php delimeter. maybe try soimething like;

echo "<"."?"."xml version='1.0' encoding='ISO-8859-1'"."?".">" . $nl;

3stripe

Hi sorry I don't think I explained this very clearly, my fault!

The echo '<?xml version="1.0" encoding="ISO-8859-1"?>' . $nl; is working fine, it's the lines below this that are causing a problem if I add a news item that includes the ' or " characters!

 echo '<news id="' . $r['id'] . '" title="' . stripslashes2($r['title']) . '" intro="' . stripslashes2($r['intro']) . '"  date="' . $r['date'] . '" author="' . stripslashes2($r['author']) . '">' . $nl;
    echo '<body><![CDATA[' . stripslashes2($c) . ']]></body>' . $nl;
    echo '</news>' . $nl;

spits out this:

<news id="19" title="Test Article 1" intro="Neque porro quisquam est, qui dolorem ipsum quia. ´ " * & % $ date="June 9th 2005" author="Claire">
<body><![CDATA[The body starts here enim ad minima veniam, body nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur. ' " * & % $

Enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt.
]]></body>
</news>

As you can see, the INTRO contents are truncated because the " is not being converted properly - although this is not a problem in BODY as you can see...

Still can't puzzle this one out!

3stripe

Ok I think I see a solution.. if each field is parsed using CDATA then I can avoid the problems with special characters.. just makes the Actionscript more complicated in the Flash file 🙁

echo '<title><![CDATA[' . stripslashes2($a) . ']]></title>' . $nl; 
echo '<intro><![CDATA[' . stripslashes2($b) . ']]></intro>' . $nl; 
echo '<body><![CDATA[' . stripslashes2($c) . ']]></body>' . $nl;

body = xml.firstChild.childNodes[at].firstChild.firstChild.nodeValue;

If this is finding the data for the firstChild, how can I find the data for the next child in the xml, and the next one after that? I believe it involves nextSibling, but what is the corect syntax for this, I'm a bit confused....

Something like this???

author = xml.firstChild.childNodes[at].firstChild.firstChild.nextSibling;
date = xml.firstChild.childNodes[at].firstChild.firstChild.nextSibling.nextSibling;

3stripe

Ok ok I got it, talking to myself here 🙂

xml.firstChild.childNodes[at].firstChild.nextSibling.firstChild.nodeValue;