Displaying database contents on the web

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • FP

    Displaying database contents on the web

    I have a comments field in my database that I want on the web.
    I put some weird characters in for testing.
    When I had <bin the comment field it turned all text after that bold.
    I tried using htmlspecialchar s() & htmlentities() but then I got
    "”" instead of a quote.

    The code I'm using to display the text in HTML is:
    <TD>
    <P><FONT SIZE="+1">
    <? echo(htmlentiti es($ResultOne['Comment'][0])); ?>
    </FONT></P>
    </TD>

    Do I need to change the HTML code or is there a PHP function that will
    handle all weird characters in this situation? Please keep in mind I'm
    fairly new to this, so if there's an obvious answer just point me in
    the right direction.

    P.S.
    Someone had suggested using a regex function but I couldn't find that
    in my manual, I assumed they were referring to the htmlspecialchar s()
    function.

  • bobzimuta

    #2
    Re: Displaying database contents on the web

    For clarification, I take it that you want your quotes to remain as
    quotes, and not become html entities. You were close, just use the
    following

    htmlentities( $str, ENT_NOQUOTES ); // leaves ' and " as they are


    FP wrote:
    I have a comments field in my database that I want on the web.
    I put some weird characters in for testing.
    When I had <bin the comment field it turned all text after that bold.
    I tried using htmlspecialchar s() & htmlentities() but then I got
    "”" instead of a quote.
    >
    The code I'm using to display the text in HTML is:
    <TD>
    <P><FONT SIZE="+1">
    <? echo(htmlentiti es($ResultOne['Comment'][0])); ?>
    </FONT></P>
    </TD>
    >
    Do I need to change the HTML code or is there a PHP function that will
    handle all weird characters in this situation? Please keep in mind I'm
    fairly new to this, so if there's an obvious answer just point me in
    the right direction.
    >
    P.S.
    Someone had suggested using a regex function but I couldn't find that
    in my manual, I assumed they were referring to the htmlspecialchar s()
    function.

    Comment

    Working...