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.

<title>TESTING PHP4 with PG</title>
<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>
   $conn = pg_connect("host=localhost dbname=databasename");
   if (! $conn) { ?>
      <p> Can not open connection to Database, contact the site
administrator </p> <?php
      $rs = pg_query($SQL, $conn);
      if (! $rs) {?>
         <p> Can not execute SQL statement, contact the site
administrator </p> <?php
         do {
             while ($row = pg_fetch_row($rs)) { ?>
                <p> <?php echo $row; ?> </p> <?php
             } while (pg_next_result($rs));
         pg_close ($conn);

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]

Reply via email to