Compile a dynamic module for use with the dl() function or the php.ini.
./configure --with-pg=shared
make
cp the module in the src/module (pgsql.so) into the location defined for
modules in your php.ini.
either add line to the ini or use the dl('pgsql.so') in your script to call
it.
if you are using a windows box i'm not sure what you do, besides first
switching to an open source OS =). they may already have binaries for
windows modules, though in my experience on unix boxes is that it compares
the the version of php you are running against the version it was compiled
with. if they are different it will error. so watch for that if you find a
compiled module to use. if you do not have access to modify the ini or place
files in the appropriate library directory you will have to request your
admin to do it. if they do not you will need to find another host or use
your own server.
> -----Original Message-----
> From: Rodolfo Napoles [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 29, 2001 1:43 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Fatal error: Call to undefined function:
> pg_connect() in ...
>
>
> Is there a way to configure php (through the conf file?) to support the pg
> commands? Is there a manual (link) where I can find how to
> compile postgreSQL
> support into PHP? does it mean to compile PHP ?
>
> Thanks
>
> Rick Emery wrote:
>
> > This means that PostgreSQL support was NOT compiled into PHP.
> Therefore,
> > you cannot use PostgreSQL commands.
> >
> > -----Original Message-----
> > From: Rodolfo Napoles [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, October 29, 2001 2:17 PM
> > To: [EMAIL PROTECTED]
> > 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: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
> --
> 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]
>
--
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]
