Embed code in mysql

Hi Guys,

When i insert video embed code into mysql for example:


<object width="640" height="270"><param name="movie" value=""></param><param name="allowFullScreen" value="true"></param><embed src="" type="application/x-shockwave-flash" allowfullscreen="true" width="640" height="270"></embed></object>


all the <> symbols appear as &^54 (or similar) what would be the proper way to deal with this? do i need to do anything to the embed code before it goes in or when it comes out?

thanks fior nay help guys

Graham

No when you echo it back out from the db it will appear just as you entered it. I would probably use mysql_real_escape_string on it first.

If you're referring to &# 62; etc, (without the space), the HTML code is being entity encoded. Checked what's in the DB to see if it's being encoded on input or output.

Hi Guys,

i checked in the database and its being encoded on input, is this because i'm using tinymce do you think?

cheers guys

Graham

i checked in the database and its being encoded on input, is this because i'm using tinymce do you think?

Most likely so. See if there's an option within it to disable entity encoding.

Just decode the special characters

http://www.php.net/manual/en/function.htmlspecialchars-decode.php

thanks for the help guys i got it sorted :)

cheers

Graham

thanks for the help guys i got it sorted :)

Good to hear. It would help if you mentioned how you've sorted it, btw. The answer will then be archived for reference if anyone runs across the same problem in the future.