Re: postgresql in PHP

davidrboyer(at)gmail(dot)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