Thread: Using php and postgres

Using php and postgres

From

Edouard DESSIOUX

Date:

15 October 1999, 09:07:40

Hello,
I'm using apache postgres and php,
I created a database called "manip"
and i want to acces this database via a web page

I use the following php script to connect to the base:
<HTML>
<?php
$database = pg_connect ("dbname=manip port=5432");
?>
</HTML>

And i obtain :
Warning: Unable to connect to PostgresSQL server: FATAL 1: Database www does not exist in pg_database in
/www/dooz.corp.intrinsec.com/mail/essai.php3 on line 3

Warning: 0 is not a PostgresSQL link index in /www/dooz.corp.intrinsec.com/mail/essai.php3 on line 4

Postmaster is started, and in psql, i can read :
manip=> FATAL 1:  Database www does not exist in pg_database

Anyone know what i done wrong ?

-- 
Edouard DESSIOUX
Proverbe chien :
"Si ca se mange pas,Si ca se baise pas,Pisse dessus !!"

Re: [INTERFACES] Using php and postgres

From

gravity

Date:

15 October 1999, 10:28:38

At 12:08 14-10-99 +0200, Edouard DESSIOUX wrote: 
>
> Hello,
> I'm using apache postgres and php,
> I created a database called "manip"
> and i want to acces this database via a web page
>
> I use the following php script to connect to the base:
> <?php $database = pg_connect ("dbname=manip port=5432"); ?> 

use pg_connect ("dbname=manip user=USERNAME password=PASSWORD port=5432")

>
> And i obtain :
> Warning: Unable to connect to PostgresSQL server: FATAL 1: Database www does
> not exist in pg_database in
> /www/dooz.corp.intrinsec.com/mail/essai.php3 on line 3

if you don't declare user then the connection will be made with the user
running php/apache: in this case 'www'.
the connection fails because the username is not correct and I guess pg then
tries to connect you to your own database, named after the user: 'www'