From: | Noel Faux <noel(dot)faux(at)med(dot)monash(dot)edu(dot)au> |
---|---|
To: | pgsql-php(at)postgresql(dot)org |
Subject: | [Fwd: Re: unable to connect to datadase....] |
Date: | 2006-03-21 23:38:20 |
Message-ID: | 44208E6C.5090206@med.monash.edu.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
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...
>
>
> <http://adworks.rediff.com/cgi-bin/AdWorks/sigclick.cgi/www.rediff.com/signature-home.htm/1507191490(at)Middle5?PARTNER=3>
Attachment | Content-Type | Size |
---|---|---|
noel.faux.vcf | text/x-vcard | 260 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Announce | 2006-03-22 01:02:39 | unsubscribe |
Previous Message | Ash | 2006-03-21 10:04:36 | unsubscribe |