Home > Archive > PHP DB > September 2004 > Re: [PHP-DB] Names with apostrophe's
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: [PHP-DB] Names with apostrophe's
|
|
|
| You need to use the urlencode() function
On Wed, 29 Sep 2004 13:23:07 -0500, Craig Hoffman <choffman@eclimb.net> wrote:
> Hello,
> I could use some help here. I have an entry in the MySQL, that use an
> apostrophe, for example lets call it "O'Reilly". I have added
> addslashes to my insert statement so MySQL accepts it with out
> complaining.
>
> The problem I am having is I use this information "O'Reilly" in a GET
> URL somewhere else in the site.
> For example here's my link:
> echo("<td><a
> href='user_book_results_detail.php?book=$row[book]>$row[book]</a></
> td>");
>
> When I mouse over and view the URL, PHP thinks the apostrophe (single
> quote) is the end and quits. I know I need to include a back slash or
> escape this character but I am not entirely sure how I do it?
> Suggestions?
>
> Sample URL:
> http://user_book_results_detail.php?book=O
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
| |
| Craig Hoffman 2004-09-30, 8:56 pm |
| Thanks everyone.
urlencode worked like a charm.
On Sep 29, 2004, at 3:53 PM, GH wrote:
> You need to use the urlencode() function
>
>
>
> On Wed, 29 Sep 2004 13:23:07 -0500, Craig Hoffman
> <choffman@eclimb.net> wrote:
>
|
|
|
|
|