[Fwd: Re: unable to connect to datadase....]

[Noel Faux <noel(dot)faux(at)med(dot)monash(dot)edu(dot)au>]

Make sure that the postmaster is running with the -i flag allowing tcp\ip connections

I suggest you use pg_last_error() and pg_last_notice() to see detailed errors if any.

Cheers
Noel

manashi chakraborty wrote:

 
hi...
    I am doin my project in PHP with PostgreSQL as backend...
        Both r very new to me....
My OS is LINUX 
I am trying to connect to the database bt its not getin connected...
  By using
    "su postgres" command
  i hav created user "root" and database "sample"
    By using
    "psql -U root sample" command
      i hav created table "login" and inserted 3 data's...
  Now through code using PHP i am trying to insert the data but  connection is not getin established.. 
  the code to connect to the datadase is :-
 
<?php
  require_once "DB.php";
  $uname=$_POST['uname'];
  $pass=$_POST['pass'];

$username="root";
$password="";
$hostname="localhost";
$dbname="sample";

$db=new DB;
$dsource=$db->factory("pgsql");

$dcon=pg_connect("dbname=sample user=manashi");

$sql="insert into login values('$uname','$pass')";

$rs=$dsource->pg_query($sql);
?>

  is there anythin wrong with tthe code or sum other problem
    waiting for the reply...

begin:vcard
fn:Noel Faux
n:Faux;Noel
org:Monash University;Biochemistry and Molecular Biology
adr:;;;Clayton;Vic;3800;Australia
email;internet:noel(dot)faux(at)med(dot)monash(dot)edu(dot)au
tel;work:+61 03 9905 1418
url:http://vbc.med.monash.edu.au/~fauxn
version:2.1
end:vcard