Trying to SELECT via web server using PHP - Mailing list pgsql-general

From Shawn Pursley
Subject Trying to SELECT via web server using PHP
Date
Msg-id 00b701bf321d$6f313740$0301000a@go.servicetransport.com
Whole thread Raw
List pgsql-general
Greetings,
 
I've got pgsql running fine from the command line, but I'm having problems using PHP to do a select...suggestions?
 
<html>
<body>
<?php
$conn = pg_Connect("host=localhost port=5432 dbname=customers");
$result = pg_exec($conn, 'select * from employees');
echo $result;
pg_exec ($database, "commit");
pg_exec ($database, "end");
?>
</body>
</html>
 
results in:
Warning: PostgresSQL query failed: ERROR: employees: Permission denied. in /home/httpd/html/connect2.php3 on line 6

Warning: 0 is not a PostgresSQL link index in /home/httpd/html/connect2.php3 on line 8

Warning: 0 is not a PostgresSQL link index in /home/httpd/html/connect2.php3 on line 9
If I change the host, the thing really blows a gasket.
 
TIA,
Shawn Pursley(shawn.pursley@service-transport.com)
Network Administrator
Service Transport

pgsql-general by date:

Previous
From: "Moray McConnachie"
Date:
Subject: Rules & cycles
Next
From: Matthew
Date:
Subject: data problem