RE: [PHP-DB] Fatal error: Call to undefined function: pg_connect( ) in ...
| From: | Rick Emery | Date: | Mon, 29 Oct 2001 20:22:49 +0000 |
| Subject: | RE: [PHP-DB] Fatal error: Call to undefined function: pg_connect( ) in ... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-13822@lists.php.net to get a copy of this message | ||
This means that PostgreSQL support was NOT compiled into PHP. Therefore,
you cannot use PostgreSQL commands.
-----Original Message-----
From: Rodolfo Napoles [mailto:rodolfo.napoles@home.com]
Sent: Monday, October 29, 2001 2:17 PM
To: php-db@lists.php.net
Subject: [PHP-DB] Fatal error: Call to undefined function: pg_connect()
in ...
Hello,
I am trying to run my first php script to connect to a PostgreSQL
database on a Linux box with apache web server.
When I try to load the page with the browser i get the following error:
Fatal error: Call to undefined function: pg_connect() in
/dirname/tryit.php on line 9
I was able to create tables on the database via the webadmin tool, so I
know that postgres is running properly.
Here is my code.
<html>
<head>
<title>TESTING PHP4 with PG</title>
</head>
<body bgcolor="#FFFFFF" topmargin="10" leftmargin="10">
<p align="center"><strong>Testing connection to Postgres using php4 from
an apache webserver on Linux Mandrake 8.0</strong></p>
<?php
$conn = pg_connect("host=localhost dbname=databasename");
if (! $conn) { ?>
<p> Can not open connection to Database, contact the site
administrator </p> <?php
}
else
{
$SQL = "SELECT * FROM TABLENAME";
$rs = pg_query($SQL, $conn);
if (! $rs) {?>
<p> Can not execute SQL statement, contact the site
administrator </p> <?php
}
else
{
do {
while ($row = pg_fetch_row($rs)) { ?>
<p> <?php echo $row; ?> </p> <?php
}
} while (pg_next_result($rs));
pg_freeresult($rs);
pg_close ($conn);
}
}
?>
</body>
</html>
Thanks in advance
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
For additional commands, e-mail: php-db-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net