undefined function: pg_connect()
| From: | Michael Hanna | Date: | Mon, 10 Dec 2001 14:33:20 +0000 |
| Subject: | undefined function: pg_connect() | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14901@lists.php.net to get a copy of this message | ||
I'm running apache 1.3.20 with php 4.0.6 and I'm trying to connect to
pgSQL 7.1.3(OS X 10.1.1).
I'm certain pgsql support is on..this is from my ./configure o/p:
checking for PostgreSQL support... yes
but this code:
<html>
<body>
<?php
$db = pg_connect("dbname=contacts user=www");
$query = "SELECT * FROM contacts";
$result = pg_exec($db, $query);
if (!$result) {printf ("ERROR"); exit;}
$row = pg_fetch_row ($result,0);
printf ("Last Name : %s<br>\n", $row[0]);
printf ("First Name: %s<br>\n", $row[1]);
printf ("Email : %s<br>\n", $row[2]);
printf ("Phone : %s<br>\n", $row[3]);
pg_close($db);
?>
</body>
</html>
trips-up PHP..
you can try it at:
elba.dyndns.org/~michael/listcontacts.php
any ideas?
Michael