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.jensen@aisn.net
AIS Network
Internet Services Worldwide
http://www.aisn.net
Office: 847. 202. 1400 x 27
Fax: 847-202-4460
Cell: 847. 530. 7845