Posted by Koncept on 01/09/07 16:06

In article <8Xvoh.20798$U12.20666@bignews1.bellsouth.net>, Paul
<lof@invalid.com> wrote:

> I have tested my logic flow and determined that the conversion from what is
> given to the
> $db->prepare() statement and what is stored in the database iteslf goes
> from:
>
> "I'm helpful"
> to
> "I&#039;m helpful"
>
> is converted by pear's DB. I am using $db->prepare() statement. When I do
> a print_r() of $db after the prepare(), it does display:
> ...., field2 = 'I'm helpful', field3=....
>
> but what ends up in the database is:
> "I&#039;m helpful"
>
> I'm using PHP 4.3 and have tried html_entity_decode() and others
> unsuccessfully.
>
> Any ideas?
>
>
>

Maybe something like this?

<?php
$encoded = "&#104;&#101;&#108;&#108;&#111;
&#119;&#111;&#114;&#108;&#100;";
echo preg_replace('/&#(\d+);/e','chr(\1)', $encoded);
?>

--
Koncept <<
"The snake that cannot shed its skin perishes. So do the spirits who are
prevented from changing their opinions; they cease to be a spirit." -Nietzsche

• Next in forum: [PHP4] Upload progress meter
• Prev in forum: Re: I need $this->self to be identical to and reference to $this, but how in PHP 5.2+?
• Thread view: Re: pear DB converting ' to &#039 - how to convert back?

[Reply to this message]