Re: PL/pgSQL and PHP 5 - Mailing list pgsql-php

From John DeSoi
Subject Re: PL/pgSQL and PHP 5
Date
Msg-id E09B3902-103E-41D7-A03F-BA8D45BFEFC8@pgedit.com
Whole thread Raw
In response to Re: PL/pgSQL and PHP 5  (PostgreSQL Admin <postgres@productivitymedia.com>)
List pgsql-php
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


pgsql-php by date:

Previous
From: PostgreSQL Admin
Date:
Subject: Re: [SQL] PL/pgSQL and PHP 5 - thanks
Next
From: Fatih Gulec
Date:
Subject: DB Error: connect failed