Thread: Fatal error: Call to undefined function pg_connect()
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
Attachment
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/
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. ------------------------------------------------------------------------