Re: postgresql in PHP - Mailing list pgsql-general

From brian
Subject Re: postgresql in PHP
Date
Msg-id 4726A234.5000802@zijn-digital.com
Whole thread Raw
In response to postgresql in PHP  (davidrboyer@gmail.com)
List pgsql-general
davidrboyer@gmail.com wrote:
> When I try to add or update a postgresql field from php, even though I
> escape it, when I
> try to include a single quote in a varchar field, the result is the
> quote and everything following
> is missing after being INSERTed or UPDATEd.  Anybody have any ideas
> what is going on?
> Thanks in advance!

What is the setting for magic_quotes_gpc in your php.ini?

hint: get_magic_quotes_gpc() will return TRUE if this is enabled, so you
can use stripslashes() where necessary.

Are you using a database wrapper (eg. PEAR MDB2) or the pg_whatever()
functions?

If the former, are you using a prepared statement?

brian

pgsql-general by date:

Previous
From: Jorge Godoy
Date:
Subject: Re: print command in sproc
Next
From: "Dot Yet"
Date:
Subject: SSL Connectivity on Solaris 10 x86