Re: Problem with pg_connect() in PHP - Mailing list pgsql-sql

<div class="Section1"><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D">Can I assume the missing ‘.”’ From the end of PG_PASSWORD is a cut and paste error?</span><p
class="MsoNormal"><spanstyle="font-size:11.0pt;font-family:"Calibri","sans-serif"; 
color:#1F497D"> </span><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D">Edward W. Rouse</span><p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D"> </span><div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in"><p
class="MsoNormal"><b><spanstyle="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">pgsql-sql-owner@postgresql.org
[mailto:pgsql-sql-owner@postgresql.org]<b>On Behalf Of </b>James Kitambara<br /><b>Sent:</b> Friday, September 26, 2008
1:22AM<br /><b>To:</b> pgsql-sql<br /><b>Cc:</b> Kenichiro Arakaki; Ken Arakaki<br /><b>Subject:</b> [SQL] Problem with
pg_connect()in PHP</span></div><p class="MsoNormal"> <table border="0" cellpadding="0" cellspacing="0"
class="MsoNormalTable"><tr><tdstyle="padding:0in 0in 0in 0in" valign="top"><p class="MsoNormal"
style="margin-bottom:10.0pt"><spanstyle="font-family: "Calibri","sans-serif"">Dear Members of </span><p
class="MsoNormal"style="margin-bottom:10.0pt"><span style="font-family: "Calibri","sans-serif"">I have installed the
Apache2.0.61,  PHP 5.2.4 and PostgreSQL 8.1 on my local computer.</span><p class="MsoNormal"
style="margin-bottom:10.0pt"><spanstyle="font-family: "Calibri","sans-serif"">All three software were successfully
tested.I changed “<i>;extension=php_pgsql.dll”</i>  to </span><p class="MsoNormal"
style="margin-bottom:10.0pt"><i><spanstyle="font-family:
"Calibri","sans-serif"">“extension=php_pgsql.dll”</span></i><spanstyle="font-family:"Calibri","sans-serif"">    in the
php.inifile in order to enable PostgreSQL in PHP.</span><p class="MsoNormal" style="margin-bottom:10.0pt"><span
style="font-family:"Calibri","sans-serif"">The problem comes when I try to connect to the PostgreSQL Database using php
functionpg_connect</span><p class="MsoNormal" style="margin-bottom:10.0pt"><span style="font-size:10.0pt;
font-family:"CourierNew";color:#7F9FBF;background:white;mso-highlight:white">$dbconn</span><span
style="font-size:10.0pt;font-family:"CourierNew";color:black;background: white;mso-highlight:white"> = </span><span
style="font-size:10.0pt;font-family:"Courier
New";color:#7F7F9F;background:white;mso-highlight:white">pg_connect</span><span
style="font-size:10.0pt;font-family:"CourierNew";color:black;background: white;mso-highlight:white">(</span><span
style="font-size:10.0pt;font-family:"Courier
New";color:#2A00FF;background:white;mso-highlight:white">"host="</span><span
style="font-size:10.0pt;font-family:"CourierNew";color:black;background:
white;mso-highlight:white">.PG_HOST_NAME.</span><spanstyle="font-size:10.0pt; font-family:"Courier
New";color:#2A00FF;background:white;mso-highlight:white">"port="</span><span
style="font-size:10.0pt;font-family:"CourierNew";
color:black;background:white;mso-highlight:white">.PG_PORT_NUM.</span><spanstyle="font-size:10.0pt;font-family:"Courier
New";color:#2A00FF;background:white;mso-highlight:white">"  dbname="</span><span
style="font-size:10.0pt;font-family:"CourierNew";color:black;background:
white;mso-highlight:white">.PG_DB_NAME.</span><spanstyle="font-size:10.0pt; font-family:"Courier
New";color:#2A00FF;background:white;mso-highlight:white">"user="</span><span
style="font-size:10.0pt;font-family:"CourierNew";
color:black;background:white;mso-highlight:white">.PG_USER.</span><spanstyle="font-size:10.0pt;font-family:"Courier
New";color:#2A00FF;background:white;mso-highlight:white">" password="</span><span
style="font-size:10.0pt;font-family:"CourierNew";color:black;background:
white;mso-highlight:white">.PG_PASSWORD);</span><spanstyle="font-family: "Calibri","sans-serif""> </span><p
class="MsoNormal"style="margin-bottom:10.0pt"><span lang="EN" style="font-family:"Calibri","sans-serif"">All the
argumentsin the function pg_connect() are defined.</span><p class="MsoNormal" style="margin-bottom:10.0pt"><span
lang="EN"style="font-family:"Calibri","sans-serif"">Unfortunately I am getting the Fatal error</span><span lang="EN"
style="font-family:"Calibri","sans-serif"">:“<i>Call to undefined function pg_connect() in
C:\Web\html\Staff_Management\example1.phpon line 23</i>”</span><p class="MsoNormal" style="margin-bottom:10.0pt"><span
lang="EN"style="font-family:"Calibri","sans-serif"">C:\Web\html is my document root.</span><p class="MsoNormal"
style="margin-bottom:10.0pt"><spanlang="EN" style="font-family:"Calibri","sans-serif"">What could be the possible
mistake?</span><p class="MsoNormal" style="margin-bottom:10.0pt"><span lang="EN"
style="font-family:"Calibri","sans-serif"">Anyoneto assist me!</span><p class="MsoNormal"
style="margin-bottom:10.0pt"><spanlang="EN" style="font-family:"Calibri","sans-serif"">Best regards,</span><p
class="MsoNormal"style="margin-bottom:10.0pt"><span lang="EN" style="font-family:"Calibri","sans-serif"">James
Kitambara</span></td></tr></table><pclass="MsoNormal"><span
style="font-size:10.0pt;font-family:"Calibri","sans-serif""> </span></div>