|
Posted by Tyrone Slothrop on 09/17/05 04:23
On Fri, 16 Sep 2005 22:06:53 GMT, "Shawn Wilson"
<shawnw_nospam_@_nospam_dvigroup.net> wrote:
>I have a photo album page written in PHP where I pull captions and such from
>an SQL
>database and the result is of course an HTML page.
>
>My problem is with the use of an apostrophe (single quote) and other such
>characters as they break my HTML. I'm also using javascript and it's a
>problem there as well.
>
>How should I store such characters in SQL, or maybe just how should I read
>them out so they can't break my code, yet they show up on the screen fine?
>
>The method I use to insert such characters works without problems. In the
>SQL I get what was intended... e.g. Ginny's Wedding
>
>However when I pull it out I get this: (seemingly correct)
>
><a href="album.php?albumid=293&frompage=1"><img id="img_two"
>src="data/293/0/cover3.jpg" alt="Ginny's Wedding"
>onMouseOver="switchit('Ginny's Wedding - Jun 11 2005');"
>onMouseOut="clearit();"></a><br>
>
>...But then my JS broken because the text is in single quotes and another
>extra one breaks it.
Shawn:
Refer to these:
http://us2.php.net/manual/en/function.htmlspecialchars.php
http://us2.php.net/manual/en/function.htmlentities.php
Since what you seem to be pulling from the data table is simple text
to populate the display, they ought to work for you.
[Back to original message]
|