pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Help with urlencode and rawurlencode
3+ messages / 2 participants
[nested] [flat]

* Help with urlencode and rawurlencode
@ 2002-10-14 15:31 Duncan Adams (DNS) <duncan.adams@vcontractor.co.za>
  2002-10-14 16:20 ` Re: Help with urlencode and rawurlencode Justin Clift <justin@postgresql.org>
  0 siblings, 1 reply; 3+ messages in thread

From: Duncan Adams (DNS) @ 2002-10-14 15:31 UTC (permalink / raw)
  To: pgsql-php

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Help with urlencode and rawurlencode
  2002-10-14 15:31 Help with urlencode and rawurlencode Duncan Adams (DNS) <duncan.adams@vcontractor.co.za>
@ 2002-10-14 16:20 ` Justin Clift <justin@postgresql.org>
  0 siblings, 0 replies; 3+ messages in thread

From: Justin Clift @ 2002-10-14 16:20 UTC (permalink / raw)
  To: Duncan Adams (DNS) <duncan.adams@vcontractor.co.za>; +Cc: pgsql-php

"Duncan Adams (DNS)" wrote:
<snip>
> ......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


<snip> 
> 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Help with urlencode and rawurlencode
@ 2002-10-14 16:31 Duncan Adams (DNS) <duncan.adams@vcontractor.co.za>
  0 siblings, 0 replies; 3+ messages in thread

From: Duncan Adams (DNS) @ 2002-10-14 16:31 UTC (permalink / raw)
  To: Justin Clift <justin@postgresql.org>; +Cc: pgsql-php

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:
<snip>
> ......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


<snip> 
> 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2002-10-14 16:31 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-10-14 15:31 Help with urlencode and rawurlencode Duncan Adams (DNS) <duncan.adams@vcontractor.co.za>
2002-10-14 16:20 ` Justin Clift <justin@postgresql.org>
2002-10-14 16:31 Re: Help with urlencode and rawurlencode Duncan Adams (DNS) <duncan.adams@vcontractor.co.za>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox