On Mar 29, 2005, at 3:48 PM, Cima wrote:
> how do i call a stored procedure i have in postgresql 8.0.1 from php
> with the necesary parameters or variables?
You don't say want php interface you are using, but with the standard
pgsql interface included with php it might look something like this:
$x = 3;
$result = pg_query($conn, "select myprocedure(1, 2, $x);");
$rows = pg_fetch_all($result);
John DeSoi, Ph.D.
Power Tools for PostgreSQL
In response to
pgsql-novice by date
|Next:||From: Andreas Kretschmer||Date: 2005-03-29 18:46:36|
|Subject: Re: [despammed] Calling Stored Procedures from PHP|
|Previous:||From: Gene.Brumm||Date: 2005-03-29 16:09:25|
|Subject: Connect to database using pg_connect|