Re: SQL injection, php and queueing multiple statement - Mailing list pgsql-general

From Tom Lane
Subject Re: SQL injection, php and queueing multiple statement
Date
Msg-id 20609.1208031514@sss.pgh.pa.us
Whole thread Raw
In response to Re: SQL injection, php and queueing multiple statement  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List pgsql-general
Ivan Sergio Borgonovo <mail@webthatworks.it> writes:
> Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Use prepared statements.

> Yeah... but how can I effectively enforce the policy that ALL input
> will be passed through prepared statements?

Modify the PHP code (at whatever corresponds to the DBD layer)
to always use PQexecParams, never PQexec, even when you don't
have any parameters.

            regards, tom lane

pgsql-general by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Postgres on shared network drive
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: SQL injection, php and queueing multiple statement