ampersands in URL string

[Gene Kelley]

I'm having some trouble echoing string data that contains an ampersand
in it.

I am filling a WHERE clause in my SQL query with a string based upon a
choice made in a select/option form element via GET.

My request for
http://www.example.com/update_company.php?company=Bill%20&%20John's%20Cri tter%20Control%20Company

returns only Bill

Any suggestions?

--
------------------------------------
Gene Kelley
Senior Open Source Software Engineer
Advanced Design Solutions Team
Network Solutions (MonsterCommerce)
Swansea, Illinois, USA

[=?ISO-8859-15?Q?Iv=E1n_S=E1nchez_Ortega?=]

Gene Kelley wrote:

I'm having some trouble echoing string data that contains an ampersand
in it.

[...]

Any suggestions?

Are you urlencode()'ing your URLs?

How are you grabbing the data from the URL?

--
----------------------------------
Iván Sánchez Ortega -ivansanchez-algarroba-escomposlinux-punto-org-

Proudly running Debian Linux with 2.6.24-1-amd64 kernel, KDE 3.5.9, and PHP
5.2.5-3 generating this signature.
Uptime: 00:18:34 up 8 days, 3:38, 2 users, load average: 1.13, 1.20, 0.71

[Jerry Stuckle]

Gene Kelley wrote:

I'm having some trouble echoing string data that contains an ampersand
in it.

I am filling a WHERE clause in my SQL query with a string based upon a
choice made in a select/option form element via GET.

My request for
http://www.example.com/update_company.php?company=Bill%20&%20John's%20Cri tter%20Control%20Company
returns only Bill

Any suggestions?

An ampersand in the query string means end the current variable and
start a new one. Standard HTML.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[Gene Kelley]

Jerry Stuckle wrote:

>
An ampersand in the query string means end the current variable and
start a new one. Standard HTML.

Thanks Jerry.

I will try to find a PHP function to handle the url encoding properly.

I would find it hard to believe that PHP couldn't pull a string from a
database that contained an ampersand in it.

--
------------------------------------
Gene Kelley
Senior Open Source Software Engineer
Advanced Design Solutions Team
Network Solutions (MonsterCommerce)
Swansea, Illinois, USA

[Jerry Stuckle]

Gene Kelley wrote:

Jerry Stuckle wrote:

>>
An ampersand in the query string means end the current variable and
start a new one. Standard HTML.

Thanks Jerry.

I will try to find a PHP function to handle the url encoding properly.

I would find it hard to believe that PHP couldn't pull a string from a
database that contained an ampersand in it.

There's no problem pulling it from the database. Your problem that's
how HTML works.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[Gene Kelley]

Jerry Stuckle wrote:

>
There's no problem pulling it from the database. Your problem that's
how HTML works.

.... and in the end. The solution for me was str_replace() :-)

For my particular situation it was easiest to simply not allow &s in the
database.

--
------------------------------------
Gene Kelley
Senior Open Source Software Engineer
Advanced Design Solutions Team
Network Solutions (MonsterCommerce)
Swansea, Illinois, USA

[Jerry Stuckle]

Gene Kelley wrote:

Jerry Stuckle wrote:

>>
There's no problem pulling it from the database. Your problem that's
how HTML works.

... and in the end. The solution for me was str_replace() :-)

For my particular situation it was easiest to simply not allow &s in the
database.

As I said - there is no problem with ampersands in the database. All
you need to do is urlencode() the string before attaching it to the url
- which you should be doing, anyway. str_replace() is not required.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[Gene Kelley]

Jerry Stuckle wrote:

Gene Kelley wrote:

>Jerry Stuckle wrote:

As I said - there is no problem with ampersands in the database. All
you need to do is urlencode() the string before attaching it to the url
- which you should be doing, anyway. str_replace() is not required.

I will do that. Thanks for the help Jerry.

--
------------------------------------
Gene Kelley
Senior Open Source Software Engineer
Advanced Design Solutions Team
Network Solutions (MonsterCommerce)
Swansea, Illinois, USA