Sr. Web Developer
mediabistro.com
US-NY-New York

Justtechjobs.com Post A Job | Post A Resume

Comments for: kevin20010314

Message # 1049082:
Date: 02/12/06 08:35
By: Jim Morrissey
Subject: Postgres & PHP

I'm trying to call a stored procedure from PHP. The SP is defined as emp_query(p1 in number, p2 in out number, p3 in out varchar, p4 out varchar, p5 out date, p6 out number). I try to call this from PHP using this command:

p1="30";
$p2="7499";
$p3="ZEE";
$p4="";
$p5="";
$p6="";
$res=pg_query($dbh,"select emp_query($p1, $p2, $p3, $p4, $p5, $p6);");

This does not work. How can I correctly call this SP?

Thanks,

-Jim

Previous Message | Next Message


Comments:
Postgres & PHPJim Morrissey02/12/06 08:35
RE: Setup linux Postgres but Windows 2k Clientdevendra12/20/05 07:17
How to connect postgresql Prasobh T.K11/28/05 03:32
RE: returning newly created primary keyMile Zajkovski11/16/05 09:15
Difference between Oracle and PostgresAmol Kelkar07/28/05 06:50
Postgres SQL and Java aplicatio likingprasad07/13/05 03:21
Stored Procedures which returns identity seedRenjitha05/05/05 07:35
password authonticationRamzi05/04/05 05:34
LINUX+POSTGRES+PHPaminata03/15/05 12:11
regarding configuring &starting Postgresqlhemant ambulgekar03/15/05 07:36
problem on quick starting postmastershenxiuer03/07/05 04:02
php problem wahid01/17/05 06:44
which mail server can work with php & howshubhra12/31/04 01:29
RE: Postgres+Windows+PHPDrew McLain03/12/04 10:56
How to Install Postgres in client modeBimal Kanti Dutta11/03/02 12:32
RE: Migration from IRIX to LinuxDavid Bryan10/26/02 21:56
how to store and access a bmp file in postgrerevathi10/26/02 08:34
synonymMichelRueher10/10/02 14:55
Changing default user's passwdReshat Sabiq09/11/02 13:24
RE: error when connecting to dbFabio08/29/02 05:31
error when connecting to dbchristian fanzott08/02/02 04:40
Material ?Flavio Petit07/19/02 19:42
just what I needed!Richard07/11/02 22:50
Newbie Stupid QuestionMarsie07/11/02 09:04
RE: how to migrate data from postgre to oracleDenver G. Vender06/21/02 03:52
how to migrate data from postgre to oraclevinod06/13/02 14:34
RE: libcrypto.so and libssl.soMike06/13/02 09:51
Postgres PermissionsMesonas06/13/02 07:07
Using ODBC over LAN to Linux?postGreSQLAndy Welch06/12/02 21:09
examples won't compile on redhat6.2Joel Chen05/30/02 20:07
PasswordsGustavo Felisberto05/20/02 10:33
Migration from IRIX to LinuxJim05/06/02 10:41
problemas al intalar postgresRomeo Belleza05/02/02 17:41
POSTGRES and HOST Language InterfaceB.Vijayakumar04/08/02 00:49
RE: Como desarrollo en WEb con PostgresRaùl Giucich04/02/02 07:33
Como desarrollo en WEb con PostgresPostgres Web Enable03/26/02 13:31
postgres userKristy03/17/02 10:49
Postgres responding very slow on redhat7.0 Mohit03/08/02 05:32
RE: GUI windows interface for Postgres?Hano de la Rouviere03/05/02 14:19
RE: Compiling php with postgresql.ângelo02/28/02 14:07
libcrypto.so and libssl.soSteve02/21/02 17:57
RE: Setup linux Postgres but Windows 2k ClientFrank Seesink02/21/02 16:25
RE: Postgres+Windows+PHPFrank Seesink02/21/02 15:47
How to select Date Data type from PostgresSunil B. Javeri02/15/02 07:06
how to pg_dumpsenthil kumar02/15/02 03:00
how to php use mail server and mail facilisenthil kumar02/15/02 02:52
RE: GUI windows interface for Postgres?Ted Striker02/14/02 16:46
returning newly created primary keyBrian02/14/02 01:39
Setup linux Postgres but Windows 2k ClientKok Leong02/07/02 21:10
RE: The JDBC of Postgresql did not work!Chris Carter02/07/02 00:48
php + postgresSouhir01/29/02 04:54
About PostgresArthur01/24/02 06:16
GUI windows interface for Postgres?David Paper01/23/02 13:21
copy file to email and check send messageDuong Tran01/18/02 21:32
applet and postgresaditya01/18/02 12:28
ConnectingFrank01/04/02 06:20
download postgresqlshailesh12/16/01 05:15
RE: How can add information to a database A K Maiti12/06/01 00:15
windows INSTALLATION!kamatis12/05/01 22:12
What's phppgadmin?dangyadang12/03/01 19:29
Does Postgres support multiprocessing?Sergio12/01/01 06:40
postmaster -i problemsJustin11/30/01 15:17
how to install php with java supportdavid11/29/01 01:48
Postgres+Windows+PHPAlexandro Laurent11/26/01 12:49
RE: Interface for Windows to admin PostgresPatrick Muldoon11/25/01 19:30
RE: LINUX+POSTGRES+PHPkillerapp11/21/01 13:28
RE: conversion from Ms-Access to postgresql Miron11/16/01 18:11
RE: PostgresJulio Cesar Campos Borges11/14/01 11:57
QuestionJulio Cesar Campos Borges11/13/01 09:47
LINUX+POSTGRES+PHPnirmal11/08/01 07:04
Any Good Books For StartersAustin Joseph11/03/01 07:12
RE: conversion from Ms-Access to postgresql Jesper Hertel10/31/01 16:13
Re: postmaster won't runAnatharyll10/29/01 05:01
error loggingramesh10/19/01 08:20
error on loging ramesh10/19/01 07:50
Re: postmaster won't runGraham10/12/01 08:19
Can't even installBrent09/28/01 14:54
Interface for Windows to admin PostgresMario09/26/01 18:06
RE: The JDBC of PostgresqlD Tim Cummings09/10/01 20:38
Recovering a deleted tableEthan Galloway09/06/01 10:12
RE: is there a table viewer for PostgresSherif Zaroubi09/06/01 07:50
conversion from Ms-Access to postgresql phani09/06/01 01:18
RE: Postgres from PHP on RedHat 7.1Mike Fox09/05/01 07:26
is there a table viewer for PostgresKiran08/25/01 10:51
Postgres for windows EASYJohn Schuhr08/14/01 12:02
How to cancel a query running?Point08/06/01 04:07
RE: diff. between mySQL and postgreSQLEricson07/26/01 10:35
Postgres from PHP on RedHat 7.1Lee Chua07/13/01 22:17
how to format the time in query in postgres kevin07/09/01 12:48
RE: how to create a table in postgress?Brendan Green07/04/01 15:25
The JDBC of Postgresqldangyadang07/03/01 04:24
how to create a table in postgress?NATARAJ06/19/01 23:58
retrieving metadata from postgresJiby06/18/01 02:14
RE: diff. between mySQL and postgreSQLvher06/13/01 19:15
Postgrespatrick06/08/01 15:32
informationharpreet singh s06/05/01 21:16
Compiling php with postgresql.clark05/31/01 10:29
How can add information to a database Francisco04/27/01 12:24
RE: great, kevin! now, about odbc?Kevin04/27/01 06:51
RE: Interesting, but...Kevin04/25/01 22:43
RE: great, kevin! now, about odbc?Kevin04/25/01 22:39
RE: problem starting postmasterKevin04/25/01 22:11
RE: Excellent articleKevin04/25/01 22:09
RE: Postgres for windows, yes:Kevin04/25/01 22:07
great, kevin! now, about odbc?Clayton Vernon04/23/01 18:56
problem starting postmasterTim Caulder04/23/01 09:53
Excellent articleJeremy Pavier04/21/01 11:23
RE: how to compile Kevin04/21/01 10:52
Postgres for windows, yes:Matt04/21/01 09:26
Interesting, but...Sasa Markovic04/20/01 03:34
how to compile kasturi04/20/01 02:09
RE: php = 4.0.1pl2 is needed ..???Kevin04/16/01 07:57
RE: Thanks - well-aimed articleKevin04/16/01 07:55
Postgresql and SSL ???Maikel Verheijen04/13/01 09:57
php = 4.0.1pl2 is needed ..???Casey Chambliss04/11/01 18:22
Thanks - well-aimed articleLee04/05/01 01:38
RE: Running postgresql from a startup scriptMichael Svazas04/04/01 20:29
RE: Postgres for windows pleaseRafael A. Borghi03/30/01 14:43
pgsql-phplehel03/29/01 05:11
Running postgresql from a startup scriptEric03/27/01 23:20
RE: What is it??Steve Brett03/21/01 11:12
RE: Less GUI fluff.... More useful infoBrett Jones03/20/01 13:43
RE: Postgres for windows pleasejerry03/19/01 06:03
RE: pgsql 7.1ß BenefitsDirk03/18/01 10:08
RE: pgsql 7.1ß BenefitsKevin03/16/01 21:57
RE: Less GUI fluff.... More useful infoKevin03/16/01 21:53
Less GUI fluff.... More useful infoBrett Jones03/15/01 22:16
RE: pgsql 7.1ß BenefitsBrad Hubbard03/15/01 17:22
RE: What is it??Andrew Dickinson03/15/01 16:17
RE: What is it??bmpc03/15/01 15:56
RE: Postgres for windows pleasePhill Kenoyer03/15/01 14:07
RE: What is it??Kevin Monroe03/15/01 11:53
RE: Postgres for windows pleaseSimon Willison03/15/01 09:46
What is it??ciaranmg03/15/01 06:38
Postgres for windows pleaseChris03/15/01 04:50
pgsql 7.1ß BenefitsTom Anderson03/14/01 23:29
 

If you are looking for help, please post on the appropriate forum here. Your questions will be answered much more quickly.

Add A Comment:

Name:

Email:

Subject:

Message:

To reduce spam posts, messages are now manually approved

You are not [logged in]. That means your account will not get credit for this post.