Thread: PHP and POSTGRES under windows

PHP and POSTGRES under windows

From
Raymond Chua Sing
Date:
I have recently installed PHP and postgres(windows
version by peerdirect) I accomplished linking the
extension of postgres to php and made postgres to work
with pgadminnII but I can't connect to the database
using postgres functions this error always shows up on
my page:
"Unable to connect to PostgreSQL server:
connectDBStart() -- socket() failed: errno=2 No such
file or directory "
and this code is what I use to connect to the DB
"<?php
   // Database variables
   // $dbhost      = "db";
   $dbname      = "hbcdb";
   $dbusername  = "Mondi0924";
   $dbpassword  = "1236964";

   $dbconn = pg_connect("dbname=$dbname
user=$dbusername password=$dbpassword port=80");
   if (!$dbconn)
   {
      header("Location: error.php3?errorcode=1");
      exit;
   }
?>"
I have been using postgres in the office using a linux
server thats why I need postgres at home could you
please help me thx.


__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com

Re: PHP and POSTGRES under windows

From
"Grant Henderson"
Date:
We use this at work

pg_connect("host={$hostname} dbname={$dbname} user={$user}
password={$password}"))

I don't think you need to specify the port....

-----Original Message-----
From: Raymond Chua Sing [mailto:mondi0924@yahoo.com]
Sent: 15 February 2003 05:42
To: pgsql-php@postgresql.org
Subject: [PHP] PHP and POSTGRES under windows


I have recently installed PHP and postgres(windows
version by peerdirect) I accomplished linking the
extension of postgres to php and made postgres to work
with pgadminnII but I can't connect to the database
using postgres functions this error always shows up on
my page:
"Unable to connect to PostgreSQL server:
connectDBStart() -- socket() failed: errno=2 No such
file or directory "
and this code is what I use to connect to the DB
"<?php
   // Database variables
   // $dbhost      = "db";
   $dbname      = "hbcdb";
   $dbusername  = "Mondi0924";
   $dbpassword  = "1236964";

   $dbconn = pg_connect("dbname=$dbname
user=$dbusername password=$dbpassword port=80");
   if (!$dbconn)
   {
      header("Location: error.php3?errorcode=1");
      exit;
   }
?>"
I have been using postgres in the office using a linux
server thats why I need postgres at home could you
please help me thx.


__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly


Re: PHP and POSTGRES under windows

From
Frank Bax
Date:
port 80 is typically http - the default for pgsql is 5432.


At 12:41 AM 2/15/03, Raymond Chua Sing wrote:
>I have recently installed PHP and postgres(windows
>version by peerdirect) I accomplished linking the
>extension of postgres to php and made postgres to work
>with pgadminnII but I can't connect to the database
>using postgres functions this error always shows up on
>my page:
>"Unable to connect to PostgreSQL server:
>connectDBStart() -- socket() failed: errno=2 No such
>file or directory "
>and this code is what I use to connect to the DB
>"<?php
>    // Database variables
>    // $dbhost      = "db";
>    $dbname      = "hbcdb";
>    $dbusername  = "Mondi0924";
>    $dbpassword  = "1236964";
>
>    $dbconn = pg_connect("dbname=$dbname
>user=$dbusername password=$dbpassword port=80");
>    if (!$dbconn)
>    {
>       header("Location: error.php3?errorcode=1");
>       exit;
>    }
>?>"
>I have been using postgres in the office using a linux
>server thats why I need postgres at home could you
>please help me thx.