Help with urlencode and rawurlencode

Hi all

I have a sql query that needs to be feed to a php page

.......host_table.hostname ilike '%omc%' order by......

but when i use urlencode or rawurlencode on it i get the following.

.......host_table.hostname ilike \'%omc%\' order by....
^ ^
on the next page.

it needs to be encoded as it is part of an javascript operation.

Why is it doing this and how does one get around it.

Thanx

duncan

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Re: Help with urlencode and rawurlencode

"Duncan Adams (DNS)" wrote:

> ......host_table.hostname ilike \'%omc%\' order by....
> on the next page.

It sounds like you have the PHP variable "magic_quotes_gpc" set On in
your "php.ini" configuration file. If you turn this off (can't remember
if it's possible with a function) then it will probably fix your
problem.

:-)

Regards and best wishes,

Justin Clift



> duncan
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Re: Help with urlencode and rawurlencode

shot, that did the trick, thanx.

-----Original Message-----
From: Justin Clift [mailto:justin@postgresql.org]
Sent: Monday, October 14, 2002 6:21 PM
To: Duncan Adams (DNS)
Cc: PGSQL
Subject: Re: [PHP] Help with urlencode and rawurlencode


"Duncan Adams (DNS)" wrote:

> ......host_table.hostname ilike \'%omc%\' order by....
> on the next page.

It sounds like you have the PHP variable "magic_quotes_gpc" set On in
your "php.ini" configuration file. If you turn this off (can't remember
if it's possible with a function) then it will probably fix your
problem.

:-)

Regards and best wishes,

Justin Clift



> duncan
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org