Обсуждение: Problem with pg_connect() in PHP
<table border="0" cellpadding="0" cellspacing="0"><tr><td style="font: inherit;" valign="top"><p class="MsoNormal" style="MARGIN:0in 0in 10pt"><font face="Calibri" size="3">Dear Members of </font><p class="MsoNormal" style="MARGIN: 0in0in 10pt"><font face="Calibri" size="3">I have installed the Apache 2.0.61,<span style="mso-spacerun: yes"> </span>PHP5.2.4 and PostgreSQL 8.1 on my local computer.</font><p class="MsoNormal" style="MARGIN: 0in 0in 10pt"><font face="Calibri"size="3">All three software were successfully tested. I changed “<i style="mso-bidi-font-style: normal">;extension=php_pgsql.dll”</i><span style="mso-spacerun: yes"> </span>to </font><p class="MsoNormal" style="MARGIN:0in 0in 10pt"><font size="3"><font face="Calibri"><i style="mso-bidi-font-style: normal">“extension=php_pgsql.dll”</i><span style="mso-spacerun: yes"> </span>in the php.ini file in order to enable PostgreSQLin PHP.</font></font><p class="MsoNormal" style="MARGIN: 0in 0in 10pt"><font face="Calibri" size="3">The problemcomes when I try to connect to the PostgreSQL Database using php function pg_connect</font><p class="MsoNormal" style="MARGIN:0in 0in 10pt"><span style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f9fbf; LINE-HEIGHT: 115%; FONT-FAMILY:'Courier New'; mso-highlight: white">$dbconn</span><span style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black;LINE-HEIGHT: 115%; FONT-FAMILY: 'Courier New'; mso-highlight: white"> = </span><span style="FONT-SIZE: 10pt; BACKGROUND:white; COLOR: #7f7f9f; LINE-HEIGHT: 115%; FONT-FAMILY: 'Courier New'; mso-highlight: white">pg_connect</span><spanstyle="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; LINE-HEIGHT: 115%; FONT-FAMILY: 'CourierNew'; mso-highlight: white">(</span><span style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; LINE-HEIGHT:115%; FONT-FAMILY: 'Courier New'; mso-highlight: white">"host="</span><span style="FONT-SIZE: 10pt; BACKGROUND:white; COLOR: black; LINE-HEIGHT: 115%; FONT-FAMILY: 'Courier New'; mso-highlight: white">.PG_HOST_NAME.</span><spanstyle="FONT-SIZE: 10pt;BACKGROUND: white; COLOR: #2a00ff; LINE-HEIGHT: 115%; FONT-FAMILY:'Courier New'; mso-highlight: white">" port="</span><span style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black;LINE-HEIGHT: 115%; FONT-FAMILY: 'Courier New'; mso-highlight: white">.PG_PORT_NUM.</span><span style="FONT-SIZE: 10pt;BACKGROUND: white; COLOR: #2a00ff; LINE-HEIGHT: 115%; FONT-FAMILY: 'Courier New'; mso-highlight: white">" <span style="mso-spacerun:yes"> </span>dbname="</span><span style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; LINE-HEIGHT:115%; FONT-FAMILY: 'Courier New'; mso-highlight: white">.PG_DB_NAME.</span><span style="FONT-SIZE: 10pt; BACKGROUND:white; COLOR: #2a00ff; LINE-HEIGHT: 115%; FONT-FAMILY: 'Courier New'; mso-highlight: white">" user="</span><spanstyle="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; LINE-HEIGHT: 115%; FONT-FAMILY: 'Courier New';mso-highlight: white">.PG_USER.</span><span style="FONT-SIZE: 10pt; BACKGROUND: white;COLOR: #2a00ff; LINE-HEIGHT: 115%;FONT-FAMILY: 'Courier New'; mso-highlight: white">" password="</span><span style="FONT-SIZE: 10pt; BACKGROUND: white;COLOR: black; LINE-HEIGHT: 115%; FONT-FAMILY: 'Courier New'; mso-highlight: white">.PG_PASSWORD);</span><font face="Calibri"size="3"> </font><p class="MsoNormal" style="MARGIN: 0in 0in 10pt"><span lang="EN" style="mso-ansi-language:EN; mso-bidi-font-weight: bold"><font size="3"><font face="Calibri">All the arguments in the functionpg_connect() are defined.</font></font></span><p class="MsoNormal" style="MARGIN: 0in 0in 10pt"><font size="3"><fontface="Calibri"><span lang="EN" style="mso-ansi-language: EN; mso-bidi-font-weight: bold">Unfortunately I amgetting the Fatal error</span><span lang="EN" style="mso-ansi-language: EN">: “<i style="mso-bidi-font-style: normal">Callto undefined function pg_connect() in <span style="mso-bidi-font-weight: bold">C:\Web\html\Staff_Management\example1.php</span>on line <span style="mso-bidi-font-weight: bold">23</span></i><spanstyle="mso-bidi-font-weight: bold">”</span></span></font></font><p class="MsoNormal" style="MARGIN:0in 0in 10pt"><span lang="EN" style="mso-ansi-language: EN; mso-bidi-font-weight: bold"><font size="3"><fontface="Calibri">C:\Web\html is my document root.</font></font></span><p class="MsoNormal" style="MARGIN: 0in0in 10pt"><span lang="EN" style="mso-ansi-language: EN; mso-bidi-font-weight: bold"><font size="3"><font face="Calibri">Whatcould be the possible mistake? </font></font></span><p class="MsoNormal" style="MARGIN: 0in 0in 10pt"><spanlang="EN" style="mso-ansi-language: EN; mso-bidi-font-weight: bold"><font size="3"><font face="Calibri">Anyoneto assist me!</font></font></span><p class="MsoNormal" style="MARGIN: 0in 0in 10pt"><span lang="EN"style="mso-ansi-language: EN; mso-bidi-font-weight: bold"><font size="3"><font face="Calibri">Best regards,</font></font></span><pclass="MsoNormal" style="MARGIN: 0in 0in 10pt"><span lang="EN" style="mso-ansi-language: EN;mso-bidi-font-weight: bold"><font face="Calibri" size="3">James Kitambara</font></span></td></tr></table><br />
Looks like you are missing the php_pgsql extension (I assume you
are running on a Windows server). On Debian GNU/Linux, it is called
php5-pgsql (or php4-pgsql, as appropriate). Not sure what it would
be called for Windows, but something similar.
Simply enabling it (by uncommenting the line in your php.ini file)
is not sufficient - the actual library needs to be installed as well.
Cheers,
Bob Edwards.
James Kitambara wrote:
> Dear Members of
>
> I have installed the Apache 2.0.61, PHP 5.2.4 and PostgreSQL 8.1 on my
> local computer.
>
> All three software were successfully tested. I changed
> “/;extension=php_pgsql.dll”/ to
>
> /“extension=php_pgsql.dll”/ in the php.ini file in order to enable
> PostgreSQL in PHP.
>
> The problem comes when I try to connect to the PostgreSQL Database using
> php function pg_connect
>
> $dbconn = pg_connect("host=".PG_HOST_NAME." port=".PG_PORT_NUM."
> dbname=".PG_DB_NAME." user=".PG_USER." password=".PG_PASSWORD);
>
> All the arguments in the function pg_connect() are defined.
>
> Unfortunately I am getting the Fatal error: “/Call to undefined function
> pg_connect() in C:\Web\html\Staff_Management\example1.php on line 23/”
>
> C:\Web\html is my document root.
>
> What could be the possible mistake?
>
> Anyone to assist me!
>
> Best regards,
>
> James Kitambara
>
>
Can I assume the missing ‘.”’ From the end of PG_PASSWORD is a cut and paste error?
Edward W. Rouse
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of James Kitambara
Sent: Friday, September 26, 2008 1:22 AM
To: pgsql-sql
Cc: Kenichiro Arakaki; Ken Arakaki
Subject: [SQL] Problem with pg_connect() in PHP
Dear Members of I have installed the Apache 2.0.61, PHP 5.2.4 and PostgreSQL 8.1 on my local computer. All three software were successfully tested. I changed “;extension=php_pgsql.dll” to “extension=php_pgsql.dll” in the php.ini file in order to enable PostgreSQL in PHP. The problem comes when I try to connect to the PostgreSQL Database using php function pg_connect $dbconn = pg_connect("host=".PG_HOST_NAME." port=".PG_PORT_NUM." dbname=".PG_DB_NAME." user=".PG_USER." password=".PG_PASSWORD); All the arguments in the function pg_connect() are defined. Unfortunately I am getting the Fatal error: “Call to undefined function pg_connect() in C:\Web\html\Staff_Management\example1.php on line 23” C:\Web\html is my document root. What could be the possible mistake? Anyone to assist me! Best regards, James Kitambara |
On Sep 26, 2008, at 12:23 PM, Edward W. Rouse wrote:
Can I assume the missing ‘.”’ From the end of PG_PASSWORD is a cut and paste error?Edward W. RouseFrom: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of James Kitambara
Sent: Friday, September 26, 2008 1:22 AM
To: pgsql-sql
Cc: Kenichiro Arakaki; Ken Arakaki
Subject: [SQL] Problem with pg_connect() in PHP
Did you re-start apache after you made the changes to the php.ini file?
Ries
--- On Fri, 9/26/08, Edward W. Rouse <erouse@comsquared.com> wrote:
> From: Edward W. Rouse <erouse@comsquared.com>
> Subject: Re: [SQL] Problem with pg_connect() in PHP
> To: "'pgsql-sql'" <pgsql-sql@postgresql.org>
> Date: Friday, September 26, 2008, 5:23 PM
> Can I assume the missing ‘.”’ From the end of
> PG_PASSWORD is a cut and paste error?
>
>
>
> Edward W. Rouse
>
>
>
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of James
> Kitambara
> Sent: Friday, September 26, 2008 1:22 AM
> To: pgsql-sql
> Cc: Kenichiro Arakaki; Ken Arakaki
> Subject: [SQL] Problem with pg_connect() in PHP
>
>
>
>
> Dear Members of
>
> I have installed the Apache 2.0.61, PHP 5.2.4 and
> PostgreSQL 8.1 on my local computer.
>
> All three software were successfully tested. I changed
> “;extension=php_pgsql.dll” to
>
> “extension=php_pgsql.dll” in the php.ini file in
> order to enable PostgreSQL in PHP.
>
> The problem comes when I try to connect to the PostgreSQL
> Database using php function pg_connect
>
> $dbconn = pg_connect("host=".PG_HOST_NAME."
> port=".PG_PORT_NUM."
> dbname=".PG_DB_NAME." user=".PG_USER."
> password=".PG_PASSWORD);
>
> All the arguments in the function pg_connect() are defined.
>
> Unfortunately I am getting the Fatal error: “Call to
> undefined function pg_connect() in
> C:\Web\html\Staff_Management\example1.php on
> line 23”
>
> C:\Web\html is my document root.
>
> What could be the possible mistake?
>
> Anyone to assist me!
>
> Best regards,
>
> James Kitambara
first create a file that contains this
<? phpinfo(); ?>
save this with php extension, run this file from the browser and seek for the directory extension, then look if the
filephp_pgsql.dll is there