Database connection

From: "Jill Jensen" <jill(dot)jensen(at)aisn(dot)net>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Database connection
Date: 2003-01-27 01:03:08
Message-ID: 08a101c2c59f$db7a6a20$ea265e40@aisn.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


Hello:

I cannot connect to my database::

the code is this:

<html>
<body>
<?php

$host = "localhost";
$user = "srproject";
$pass = "56364563";
$db = "srproject";

//open a connection to the database server
$connection = pg_connect ("host=$local host dbname=$srproject
user=$srproject password=$56364563");

$connection = pg_connect ("host=$host dbname=$dbuser=$user password=$pass");

if (!$connection)
{
die("Could not open connection to database server");
}

$query = "INSERT INTO student(firstname, lastname) VALUES ('jill',
'jensen')";

if (!$result) {
printf ("ERROR");
$errormessage = pg_errormessage($db);
echo $errormessage;
exit;
}
printf ("These values were inserted into the database - %s %s", $firstname,
$lastname);
pg_close();
?>
</body>
</html>

-------------------------------------

the error I get is this:

Warning: pg_connect() unable to connect to PostgreSQL server: unknown host
name: host in /home/srproject/webpage/action.php on line 13

Warning: pg_connect() unable to connect to PostgreSQL server: could not
connect to server: Connection refused Is the server running on host
localhost and accepting TCP/IP connections on port 5432? in
/home/srproject/webpage/action.php on line 15
Could not open connection to database server

I have been assure that port 5432 is open for connections on the localhost,
and that tcp/ip connections are accepted.
Best regards,

Jill Jensen, MCP
Operations Manager

jill(dot)jensen(at)aisn(dot)net

AIS Network
Internet Services Worldwide
http://www.aisn.net

Office: 847. 202. 1400 x 27
Fax: 847-202-4460
Cell: 847. 530. 7845

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Art Fore 2003-01-27 04:21:22 Re: postgresql with SuSE 8.0
Previous Message Art Fore 2003-01-27 01:02:43 Re: postgresql with SuSE 8.0