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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
