Skip site navigation (1) Skip section navigation (2)

Re: Fatal error: Call to undefined function pg_connect()

From: Andrew McMillan <andrew(at)morphoss(dot)com>
To: Steve(dot)Toutant(at)inspq(dot)qc(dot)ca
Cc: pgsql-php(at)postgresql(dot)org
Subject: Re: Fatal error: Call to undefined function pg_connect()
Date: 2010-05-27 23:19:15
Message-ID: 1275002355.3344.2204.camel@happy.home.mcmillan.net.nz (view raw or flat)
Thread:
Lists: pgsql-php
On Thu, 2010-05-27 at 15:30 -0400, Steve(dot)Toutant(at)inspq(dot)qc(dot)ca wrote:
> 
> Hi, 
> I created a php page and the code connects to my postgres database and
> do stuff... 
> that works well when launched from a browser 
> 
> But it doesn't from a command line 
> PHP myFile.php 
> 
> I get this error 
> Fatal error: Call to undefined function pg_connect() 
> 
> It seems that php.exe does not recognize postgres functions. 
> 
> In \ms4w\Apache\cgi-bin\php.ini I have this: 
> extension=php_pgsql.dll and this dll is in \ms4w\Apache\php\ext 

When you run PHP from the command line you will be using a different
php.ini, and it's that one that you need to find and add the above line
to.
> 
> PATH variable contains this 
> C:\Program Files\PostgreSQL\8.3\bin; 
> 
> 
> 
> phpinfo() launched via a browser give me this 

Try launching phpinfo() from a command line.

PHP -r 'phpinfo();'


Not that I've used it on Windows, but that's certainly how it works on
Linux.

Cheers,
					Andrew.


-- 
------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com                            +64(272)DEBIAN
               Chicken Little only has to be right once.
------------------------------------------------------------------------

In response to

pgsql-php by date

Next:From: AI RummanDate: 2010-06-15 08:31:32
Subject: large resultset
Previous:From: ChrisDate: 2010-05-27 22:50:55
Subject: Re: Fatal error: Call to undefined function pg_connect()

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group