Fatal error: Call to undefined function pg_connect()

Поиск
Список
Период
Сортировка
Искать

Fatal error: Call to undefined function pg_connect()

От:
Steve.Toutant@inspq.qc.ca
Дата:
Вложения:

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

PATH variable contains this
C:\Program Files\PostgreSQL\8.3\bin;



phpinfo() launched via a browser give me this

This command php -i from a command prompt doesn't return any pgsql extension

What should I do to be able to call the postgres functions when using php.exe from a command line?

thanks

steve



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

От:
Chris <dmagick@gmail.com>
Дата:
On 28/05/10 05:30, Steve.Toutant@inspq.qc.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

Any errors in apache or system logs ?

Could there be something this dll is missing? I don't know much about 
windows unfortunately but this may help figure out what else you need to 
include:

http://www.dependencywalker.com/

-- 
Postgresql & php tutorials
http://www.designmagick.com/

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

От:
Andrew McMillan <andrew@morphoss.com>
Дата:
Вложения:
On Thu, 2010-05-27 at 15:30 -0400, Steve.Toutant@inspq.qc.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.
------------------------------------------------------------------------

FAQ