Re: Configure PostgreSQL on PHP

I don't think you need anything in your php.ini, you should be able to
connect like so:

$connstr = "dbname= user= password= 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.


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Re: 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 =E9crit :
> I don't think you need anything in your php.ini, you should be able to
> connect like so:
>
> $connstr =3D "dbname=3D user=3D password=3D host=
=3D";
>
> $dbh =3D 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 conne=
ct
> > 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 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Re: Configure PostgreSQL on PHP

Hi,

According to a colleague, as well as uncommenting the line in php.ini=20
you also need to copy php_pgsql.dll to somewhere in the PATH (i.e.=20
c:\winnt\system32). The php_pgsql.dll DLL should be in your PHP=20
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 th=
e
>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"
>To: "Adam Witney" ; "Carlos Lopes" t>;
>"pgsql-php"
>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 =E9crit :
> =20
>
>>I don't think you need anything in your php.ini, you should be able to
>>connect like so:
>>
>> $connstr =3D "dbname=3D user=3D password=3D host=
=3D";
>>
>> $dbh =3D pg_connect($connstr);
>>
>>If this fails, what errors do you get?
>>
>>adam
>>
>> =20
>>
>>>Hi, can anyone tell me how to configure my php.ini file, so i can
>>> =20
>>>
>connect
> =20
>
>>>to a pgsql database?
>>>
>>>I already have the database installed and is working under pgAdmin, bu=
t
>>> =20
>>>
>i
> =20
>
>>>can't put the pg_connect() command working.
>>>
>>>Can someone help me?
>>>
>>>Thanks
>>>
>>>Carlos Lopes
>>> =20
>>>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: don't forget to increase your free space map settings
> =20
>

--=20
Matt Goodall, Pollenation Internet Ltd
e: matt@pollenationinternet.com
t: 0113 2252500



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Configure PostgreSQL on PHP

This is a multi-part message in MIME format.

------=_NextPart_000_006B_01C33C98.276CE790
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi, can anyone tell me how to configure my php.ini file, so i can connect t=
o a pgsql database?

I already have the database installed and is working under pgAdmin, but i c=
an't put the pg_connect() command working.

Can someone help me?

Thanks

Carlos Lopes

------=_NextPart_000_006B_01C33C98.276CE790
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Re: Configure PostgreSQL on PHP

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"
To: "Adam Witney" ; "Carlos Lopes" >;
"pgsql-php"
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 =E9crit :
> I don't think you need anything in your php.ini, you should be able to
> connect like so:
>
> $connstr =3D "dbname=3D user=3D password=3D host=
=3D";
>
> $dbh =3D 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, b=
ut
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

Re: Configure PostgreSQL on PHP

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


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Re: Configure PostgreSQL on PHP

--=-tgbAOFCKp0d5qHpSweBs
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: quoted-printable

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=20



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.
>=20
> How do i compile php with the pgsql flag?
>=20
> Carlos Lopes
>=20
> ----- Original Message -----
> From: "DIB Walid"
> To: "Adam Witney" ; "Carlos Lopes" >;
> "pgsql-php"
> Sent: Friday, June 27, 2003 3:01 AM
> Subject: Re: [PHP] Configure PostgreSQL on PHP
>=20
>=20
> I think he forget to compile php with the pgsql flag option.
> Walid
> Le Vendredi 27 Juin 2003 11:50, Adam Witney a =E9crit :
> > I don't think you need anything in your php.ini, you should be able to
> > connect like so:
> >
> > $connstr =3D "dbname=3D user=3D password=3D host=
=3D";
> >
> > $dbh =3D 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, b=
ut
> i
> > > can't put the pg_connect() command working.
> > >
> > > Can someone help me?
> > >
> > > Thanks
> > >
> > > Carlos Lopes
>=20
>=20
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>=20

--=-tgbAOFCKp0d5qHpSweBs
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQA+/QMIazmPVcw0EKwRAnmtAJ98RqtBXlKv2riI1QQ6cy4JloGG0QCe LpXW
xF0x52X7LuJrqf4/5rpv9QY=
=DJ+v
-----END PGP SIGNATURE-----

--=-tgbAOFCKp0d5qHpSweBs--