%20 char disables query

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Stijn Goris
    #1

    %20 char disables query

    hi all,

    I have a site where a user can enter text (newspost). I recently discovered
    that when %20 is entered the text is properly inserted in the database
    (INSERT) but isn't shown on the page isn't shown on the page (SELECT).

    The text is shown via printf(nl2br(st ripslashes($myr ow[1]))); where myrow[1]
    is the text containing the %20 . Someone knows whats goin on?

    Regards
    Stijn


    Tags: None
    • Ken Robinson
      #2
      Re: %20 char disables query


      Stijn Goris wrote (in part):[color=blue]
      > hi all,
      >
      > I have a site where a user can enter text (newspost). I recently[/color]
      discovered[color=blue]
      > that when %20 is entered the text is properly inserted in the[/color]
      database[color=blue]
      > (INSERT) but isn't shown on the page isn't shown on the page[/color]
      (SELECT).[color=blue]
      >
      > The text is shown via printf(nl2br(st ripslashes($myr ow[1]))); where[/color]
      myrow[1][color=blue]
      > is the text containing the %20 . Someone knows whats goin on?[/color]

      The string '%20' is the urlencoded value for a space character. If
      you're not enclosing your value in quotes, then the statement would
      include the entire string.
      To really help you, we have to see more of your code.

      Ken

        Comment

        • Ken Robinson
          #3
          Re: %20 char disables query


          Stijn Goris wrote (in part):[color=blue]
          > hi all,
          >
          > I have a site where a user can enter text (newspost). I recently[/color]
          discovered[color=blue]
          > that when %20 is entered the text is properly inserted in the[/color]
          database[color=blue]
          > (INSERT) but isn't shown on the page isn't shown on the page[/color]
          (SELECT).[color=blue]
          >
          > The text is shown via printf(nl2br(st ripslashes($myr ow[1]))); where[/color]
          myrow[1][color=blue]
          > is the text containing the %20 . Someone knows whats goin on?[/color]

          The string '%20' is the urlencoded value for a space character. If
          you're not enclosing your value in quotes, then the statement would
          include the entire string.
          To really help you, we have to see more of your code.

          Ken

            Comment

            Previous template Next
            Working...