FUDforum: comp.lang.php » Problem with special char in MySQL and XML

Home » Imported messages » comp.lang.php » Problem with special char in MySQL and XML

Show: Today's Messages :: Polls :: Message Navigator

Problem with special char in MySQL and XML [message #174834]

Tue, 12 July 2011 20:02

Sarah
Messages: 30
Registered: December 2010

Karma:

Member

Hi! I've a table UTF8_general_ci where I've symbols like: & è , à
' ...

I've seen that when I try to generate an XML file (that works OK with
other tables) I show this error:

Warning: SimpleXMLElement::addChild() [simplexmlelement.addchild]:
unterminated entity reference Pizza in /var/www/domain.com/xmlfeed.php
on line 164

In my PHP code I've something like this:

$aaa->addChild('date', strip_tags(utf8_encode($row{'Date'})) );
$aaa->addChild('title', strip_tags(utf8_encode($row{'Title'})) );

Where is it my error?

Thanks

Report message to a moderator

[Message index]

		Problem with special char in MySQL and XML By: Sarah on Tue, 12 July 2011 20:02
		Re: Problem with special char in MySQL and XML By: Sarah on Tue, 12 July 2011 23:23
		Re: Problem with special char in MySQL and XML By: Denis McMahon on Wed, 13 July 2011 00:19
		Re: Problem with special char in MySQL and XML By: alvaro.NOSPAMTHANX on Wed, 13 July 2011 07:06
		Re: Problem with special char in MySQL and XML By: Andrea Benaglio on Wed, 13 July 2011 07:56
		Re: Problem with special char in MySQL and XML By: Sarah on Wed, 13 July 2011 09:51
		Re: Problem with special char in MySQL and XML By: alvaro.NOSPAMTHANX on Wed, 13 July 2011 11:50
		Re: Problem with special char in MySQL and XML By: Sarah on Wed, 13 July 2011 12:14
		Re: Problem with special char in MySQL and XML By: Sarah on Wed, 13 July 2011 12:17
		Re: Problem with special char in MySQL and XML By: alvaro.NOSPAMTHANX on Wed, 13 July 2011 12:37
		Re: Problem with special char in MySQL and XML By: Michael Fesser on Wed, 13 July 2011 12:42
		Re: Problem with special char in MySQL and XML By: Sarah on Wed, 13 July 2011 12:56

Previous Topic:	xml rpc request with mynewsletter builder
Next Topic:	how to implement AJAX to html

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 18:00:11 GMT 2024

Total time taken to generate the page: 0.04901 seconds