Re: [PHP-DB] pg_connect gets fatal error

2005-08-18 Thread John DeSoi


On Aug 14, 2005, at 2:16 PM, Jon Crump wrote:

I'm guessing you're right, but it's not clear how I could tell. The  
output from ?php phpinfo() ? doesn't really help much unless I  
know what to look for. On the one hand it says that DBX support is  
enabled and PostgreSQL is one of the supported databases, on the  
other, MySQL support is described explicitly, as is ODBC, but there  
is no similar section for the other supported DBs. If php wasn't  
compiled with postgres support, do I have to recompile it? how?  
Apologies if these questions are naive, but I am a rank tyro in  
these matters.


Look at the Configure Command in phpinfo(). It should have the flag  
--with-pgsql.


One of the easiest ways to get PHP/PostgreSQL going on the Mac is to  
use this installer:


http://www.entropy.ch/software/macosx/php/



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP-DB] pg_connect gets fatal error

2005-08-14 Thread Jon Crump

On Sat, 13 Aug 2005, Bastien Koert wrote:


is php compiled with postgre support? probably not from the sounds of it

bastien


I'm guessing you're right, but it's not clear how I could tell. The output 
from ?php phpinfo() ? doesn't really help much unless I know what to 
look for. On the one hand it says that DBX support is enabled and 
PostgreSQL is one of the supported databases, on the other, MySQL support 
is described explicitly, as is ODBC, but there is no similar section for 
the other supported DBs. If php wasn't compiled with postgres support, 
do I have to recompile it? how? Apologies if these questions are naive, 
but I am a rank tyro in these matters.


Jon

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP-DB] pg_connect gets fatal error

2005-08-14 Thread Bastien Koert
http://ca.php.net/manual/en/ref.pgsql.php is the manual place to start 
looking...


i just enabled pg support with my windows machine..pgsql does show up as a 
separate entity in the php info listings...


Because you mentioned Postgre I am assuming your dev machine is a linux box.
http://ca.php.net/manual/en/install.unix.php
are the install notes for php, these will guide you in re compiling PHP to 
include postgre


bastien


From: Jon Crump [EMAIL PROTECTED]
To: Bastien Koert [EMAIL PROTECTED]
CC: php-db@lists.php.net
Subject: RE: [PHP-DB] pg_connect gets fatal error
Date: Sun, 14 Aug 2005 11:16:39 -0700 (PDT)

On Sat, 13 Aug 2005, Bastien Koert wrote:


is php compiled with postgre support? probably not from the sounds of it

bastien


I'm guessing you're right, but it's not clear how I could tell. The output 
from ?php phpinfo() ? doesn't really help much unless I know what to look 
for. On the one hand it says that DBX support is enabled and PostgreSQL is 
one of the supported databases, on the other, MySQL support is described 
explicitly, as is ODBC, but there is no similar section for the other 
supported DBs. If php wasn't compiled with postgres support, do I have to 
recompile it? how? Apologies if these questions are naive, but I am a rank 
tyro in these matters.


Jon


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] pg_connect gets fatal error

2005-08-13 Thread Jon Crump

Dear all,

I'm brand new at this and I'm trying to get Darwin/Apache/Php/PostgresSQL 
running on my iBook (OS X 10.4.2) with Tiger newly installed. Apache 1.3 
is running fine, PostgresSQL 8.0.1 working fine, PHP 4.3.11 works except 
when I try to call a postgres function I get:


Fatal error: Call to undefined function: pg_connect() in 
/Users/jjc/Sites/PHPtesting/hello.php on line 12


looking at /private/etc/php.ini.default, it looks like postgres is 
enabled, so why doesn't php like any pg_ functions?


I've scoured the faqs and the archives. I've found this question asked 
before, but not answered.


Any help for a tyro?

Jon

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP-DB] pg_connect gets fatal error

2005-08-13 Thread Bastien Koert

is php compiled with postgre support? probably not from the sounds of it

bastien


From: Jon Crump [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] pg_connect gets fatal error
Date: Sat, 13 Aug 2005 11:29:59 -0700 (PDT)

Dear all,

I'm brand new at this and I'm trying to get Darwin/Apache/Php/PostgresSQL 
running on my iBook (OS X 10.4.2) with Tiger newly installed. Apache 1.3 is 
running fine, PostgresSQL 8.0.1 working fine, PHP 4.3.11 works except when 
I try to call a postgres function I get:


Fatal error: Call to undefined function: pg_connect() in 
/Users/jjc/Sites/PHPtesting/hello.php on line 12


looking at /private/etc/php.ini.default, it looks like postgres is 
enabled, so why doesn't php like any pg_ functions?


I've scoured the faqs and the archives. I've found this question asked 
before, but not answered.


Any help for a tyro?

Jon

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php