Thread: Configure PostgreSQL on PHP
Hi, can anyone tell me how to configure my php.ini file, so i can connect to a pgsql database?
I already have the database installed and is working under pgAdmin, but i can't put the pg_connect() command working.
Can someone help me?
Thanks
Carlos Lopes
I don't think you need anything in your php.ini, you should be able to connect like so: $connstr = "dbname=<dbname> user=<user> password=<passwd> host=<host>"; $dbh = pg_connect($connstr); If this fails, what errors do you get? adam > Hi, can anyone tell me how to configure my php.ini file, so i can connect to a > pgsql database? > > I already have the database installed and is working under pgAdmin, but i > can't put the pg_connect() command working. > > Can someone help me? > > Thanks > > Carlos Lopes -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
I'm running php under Windows 2000 and on my php.ini file i uncomment the line regarding the pgsql dll, but doesn't seems to work. How do i compile php with the pgsql flag? Carlos Lopes ----- Original Message ----- From: "DIB Walid" <walid.dib@inria.fr> To: "Adam Witney" <awitney@sghms.ac.uk>; "Carlos Lopes" <clopes@adm.ua.pt>; "pgsql-php" <pgsql-php@postgresql.org> Sent: Friday, June 27, 2003 3:01 AM Subject: Re: [PHP] Configure PostgreSQL on PHP I think he forget to compile php with the pgsql flag option. Walid Le Vendredi 27 Juin 2003 11:50, Adam Witney a écrit : > I don't think you need anything in your php.ini, you should be able to > connect like so: > > $connstr = "dbname=<dbname> user=<user> password=<passwd> host=<host>"; > > $dbh = pg_connect($connstr); > > If this fails, what errors do you get? > > adam > > > Hi, can anyone tell me how to configure my php.ini file, so i can connect > > to a pgsql database? > > > > I already have the database installed and is working under pgAdmin, but i > > can't put the pg_connect() command working. > > > > Can someone help me? > > > > Thanks > > > > Carlos Lopes
Hi, According to a colleague, as well as uncommenting the line in php.ini you also need to copy php_pgsql.dll to somewhere in the PATH (i.e. c:\winnt\system32). The php_pgsql.dll DLL should be in your PHP installation somewhere, you'll have to search for it. Hope this helps, Matt Carlos Lopes wrote: >I'm running php under Windows 2000 and on my php.ini file i uncomment the >line regarding the pgsql dll, but doesn't seems to work. > >How do i compile php with the pgsql flag? > >Carlos Lopes > >----- Original Message ----- >From: "DIB Walid" <walid.dib@inria.fr> >To: "Adam Witney" <awitney@sghms.ac.uk>; "Carlos Lopes" <clopes@adm.ua.pt>; >"pgsql-php" <pgsql-php@postgresql.org> >Sent: Friday, June 27, 2003 3:01 AM >Subject: Re: [PHP] Configure PostgreSQL on PHP > > >I think he forget to compile php with the pgsql flag option. >Walid >Le Vendredi 27 Juin 2003 11:50, Adam Witney a écrit : > > >>I don't think you need anything in your php.ini, you should be able to >>connect like so: >> >> $connstr = "dbname=<dbname> user=<user> password=<passwd> host=<host>"; >> >> $dbh = pg_connect($connstr); >> >>If this fails, what errors do you get? >> >>adam >> >> >> >>>Hi, can anyone tell me how to configure my php.ini file, so i can >>> >>> >connect > > >>>to a pgsql database? >>> >>>I already have the database installed and is working under pgAdmin, but >>> >>> >i > > >>>can't put the pg_connect() command working. >>> >>>Can someone help me? >>> >>>Thanks >>> >>>Carlos Lopes >>> >>> > > >---------------------------(end of broadcast)--------------------------- >TIP 7: don't forget to increase your free space map settings > > -- Matt Goodall, Pollenation Internet Ltd e: matt@pollenationinternet.com t: 0113 2252500
I think he forget to compile php with the pgsql flag option. Walid Le Vendredi 27 Juin 2003 11:50, Adam Witney a écrit : > I don't think you need anything in your php.ini, you should be able to > connect like so: > > $connstr = "dbname=<dbname> user=<user> password=<passwd> host=<host>"; > > $dbh = pg_connect($connstr); > > If this fails, what errors do you get? > > adam > > > Hi, can anyone tell me how to configure my php.ini file, so i can connect > > to a pgsql database? > > > > I already have the database installed and is working under pgAdmin, but i > > can't put the pg_connect() command working. > > > > Can someone help me? > > > > Thanks > > > > Carlos Lopes
On Fri, 27 Jun 2003, Carlos Lopes wrote: > I'm running php under Windows 2000 and on my php.ini file i uncomment the > line regarding the pgsql dll, but doesn't seems to work. If the function pg_connect() is defined (or any of the pgsql functions), it's working. Your problem is not properly using pg_connect(). Regards, Philip
Here is what you will need to do: 1. Put the php_pg.dll file in you windows path. 2. Uncomment the pgsql dll in your php.ini file. 3. Your php.ini file needs to be in your path. 4. Restart your web server and then try running the page again. Hope that helps... -- Ray On Fri, 2003-06-27 at 12:17, Carlos Lopes wrote: > I'm running php under Windows 2000 and on my php.ini file i uncomment the > line regarding the pgsql dll, but doesn't seems to work. > > How do i compile php with the pgsql flag? > > Carlos Lopes > > ----- Original Message ----- > From: "DIB Walid" <walid.dib@inria.fr> > To: "Adam Witney" <awitney@sghms.ac.uk>; "Carlos Lopes" <clopes@adm.ua.pt>; > "pgsql-php" <pgsql-php@postgresql.org> > Sent: Friday, June 27, 2003 3:01 AM > Subject: Re: [PHP] Configure PostgreSQL on PHP > > > I think he forget to compile php with the pgsql flag option. > Walid > Le Vendredi 27 Juin 2003 11:50, Adam Witney a écrit : > > I don't think you need anything in your php.ini, you should be able to > > connect like so: > > > > $connstr = "dbname=<dbname> user=<user> password=<passwd> host=<host>"; > > > > $dbh = pg_connect($connstr); > > > > If this fails, what errors do you get? > > > > adam > > > > > Hi, can anyone tell me how to configure my php.ini file, so i can > connect > > > to a pgsql database? > > > > > > I already have the database installed and is working under pgAdmin, but > i > > > can't put the pg_connect() command working. > > > > > > Can someone help me? > > > > > > Thanks > > > > > > Carlos Lopes > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings >