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