php errors
Posted: Mon Apr 07, 2003 5:04 am
I've written a code to test postgres in php and I get the following errors
Warning: pg_connect() unable to connect to PostgreSQL server: FATAL 1: user "apache" does not exist in /var/www/html/testdb.php on line 2
Warning: pg_exec(): supplied argument is not a valid PostgreSQL link resource in /var/www/html/testdb.php on line 4
There's been an error
and my code:
<?php
$conn=pg_connect("dbname =mobiledb");
$sql = "select * from users";
$result = pg_exec($conn,$sql);
if (!$result) {printf("There's been an error");exit;}
$row=pg_fetch_row($result,0);
printf("Phone number:%s<br>\n",$row[1]);
printf("Service Provider:%s<br>\n",$row[2]);
pg_close();
?>
What am I doing wrong?
Warning: pg_connect() unable to connect to PostgreSQL server: FATAL 1: user "apache" does not exist in /var/www/html/testdb.php on line 2
Warning: pg_exec(): supplied argument is not a valid PostgreSQL link resource in /var/www/html/testdb.php on line 4
There's been an error
and my code:
<?php
$conn=pg_connect("dbname =mobiledb");
$sql = "select * from users";
$result = pg_exec($conn,$sql);
if (!$result) {printf("There's been an error");exit;}
$row=pg_fetch_row($result,0);
printf("Phone number:%s<br>\n",$row[1]);
printf("Service Provider:%s<br>\n",$row[2]);
pg_close();
?>
What am I doing wrong?