From: | Ahmad Sentri <sentri(at)unila(dot)ac(dot)id> |
---|---|
To: | sebastien(dot)baudry(at)baudry-engineering(dot)com |
Cc: | pgsql-php(at)postgresql(dot)org |
Subject: | Re: How to call a PL/pgSQL function in a PHP script |
Date: | 2003-10-02 08:46:12 |
Message-ID: | Pine.BSF.4.21.0310021539490.39488-100000@maiser.unila.ac.id |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
in php syntax for call a function
u can use in sql select a function that already made
the way u can write in php syntax with :
$sql_select="SELECT name_of_fanction(var1,var2,...) from name_of_table
===
so if u make a function with the name: name_function
so :
$sql_select="SELECT name_function(var1) from table
On Thu, 2 Oct 2003, Sebastien Baudry wrote:
> Date: Thu, 2 Oct 2003 10:00:10 +0200
> From: Sebastien Baudry <sbaudry(at)yahoo(dot)com>
> Reply-To: sebastien(dot)baudry(at)baudry-engineering(dot)com
> To: pgsql-php(at)postgresql(dot)org
> Subject: [PHP] How to call a PL/pgSQL function in a PHP script?
>
> Hi,
> I created functions (using PL/pgSQL) in my PostGreSQL database and now I try
> to call them in my PHP script but it doesn't succeed.
> I can open a connection to the database, run a simple query and get the
> result, but I don't know how to do with the functions.
> Anybody could help me?
>
> --
> Sbastien BAUDRY - DBA Oracle/MS-SQL & Project Manager
> BAUDRY ENGINEERING BT. H-1025 Budapest Verhalom utca. 31/D. I/8.
> @.: sebastien(dot)baudry(at)baudry-engineering(dot)com
> mobile.: +36-30-392-0279 / tel: +36-1-326-0241 / fax: +36-1-326-0241
> http://www.baudry-engineering.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sebastien Baudry | 2003-10-02 08:54:56 | Re: How to call a PL/pgSQL function in a PHP script |
Previous Message | Viorel Dragomir | 2003-10-02 08:04:42 | Re: How to call a PL/pgSQL function in a PHP script? |