Re: [PHP] '&' Sign in _GET Parameter

Pushpinder Singh Garcha wrote:

> Thanks for the link,
>
> $link = $row['company'];
> <a href=\"full_profile_1.php?name=', urlencode($link),' \"
>
> However this does not seem to work / what am I missing ?
>
> Thanks
> -Pushpinder
>
>
>
> On Friday, August 22, 2003, at 03:23 PM, CPT John W. Holmes wrote:
>
>> From: "Pushpinder Singh Garcha" <pgarcha@adelphia.net>
>>
>>> I am using an application where I retrieve user profile from a MySQL
>>> DB using the Company Name . I pass the name of the company to the PHP
>>> script as a '$_GET' parameter. e.g. when the name of the company is
>>> 'IBM'. , the URL with the query string would look like :
>>> http://masterstream.com/CRM/full_profile_1.php?name=IBM
>>>
>>> Now one of the records had a name : PSG & Inc. , in this case the URL
>>> with the query string would look like
>>> http://masterstream.com/CRM/full_pro...=PSG%20&%20Inc.
>>>
>>> However in the case of the latter I am not able to pull out any records
>>> from the MySQL database. It says that "no records with the name were
>>> found". I went ahead and tweaked the name of the company, to remove
>>> the "&" sign in 'PSG & Inc.' Now the query works fine. Can some one
>>> throw some light here. I am sure something minor is to be done when
>>> passing the name of the company in the parent script.
>>
>>
>> The & character separates variables in the query string, so it must be
>> encoded if it appears in the data. Take a look at
>> http://us2.php.net/urlencode
>>
>> ---John Holmes...
>>
>>
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>

Well, you need to urldecode() once it gets to the PHP script handling
it, otherwise it still wont work ;).