Re: PL/pgSQL and PHP 5

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

Glad you found the problem.

On Aug 9, 2006, at 11:42 PM, PostgreSQL Admin wrote:

> $connection->execute("SELECT insert_staff_b('$staff 
> [insert_firstname]'::varchar)");
> $connection->execute("SELECT insert_staff_b('".$staff 
> ['insert_firstname']."'::varchar)");

If you are creating SQL functions you want to call from PHP, you  
might be interested in this simple class:

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


Then instead of all the quoting issue you have above, you could  
simply call your SQL function like a normal PHP method call:

$connection->insert_staff_b($staff['insert_firstname']);




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