Re: entrance from php to postgresql

[John DeSoi <desoi(at)pgedit(dot)com>]

On Jul 11, 2006, at 1:23 PM, DCarrero wrote:

> I was asking if this useful, or secure to do a transaction on web, or
> you recomend use a function with parameters an inside this insert
> data, thank for the information too...

If you are inserting user entered data (especially from the web) I  
highly recommend you use prepared statements. This will deal with  
security issues related to SQL injection. I prefer to use functions,  
but it is not necessary. Here is a short article I wrote which you  
might find helpful in using prepared statements from PHP:

http://pgedit.com/resource/php/pgfuncall




John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL