Re: How to use Php connecting to pgsql

From: Ireneusz Pluta <ipluta(at)wp(dot)pl>
To: 马庆 <ma(dot)qing(at)staples(dot)sh(dot)cn>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to use Php connecting to pgsql
Date: 2006-12-30 06:52:06
Message-ID: 45960C96.60304@wp.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

马庆 napisał(a):
> Dear All:
> I come across a problem that I can't solve it, Can anyone help me, Thanks.
> My configuration is RedHat AS4 + php5.0 + pgsql 8.1. When I finish install php, I install php_pgsql module in order to use php connecting pgsql. To my surprised , I can't get access to pgslq, there's nothing show on the page.
> So I write <?php phpinfo() ?> it works.
> I write <?php echo "hello world" ? $db = pg_connect(dbname=foo, user=foo,password=foo); if(!$db) print("error")?> ,
shouldn't the connection string in pg_connect be quoted, like:
pg_connect("dbname=foo, user=foo,password=foo")
?
> it doesn't work , only print "hello world" on the page.
>
how do you test your script? If through http - check your http server
error log.
But generally, with such a basic test it is a far better idea to run a
test script from command line like:
php your_script.php
Then you can see all errors on your STDERR.
Make sure that error related parameters in your php.ini let you see
warnings and errors you want to see, or use an adequate ini_set() in
your script.
> But I use psql command with the same username and the same password, I can access to the pgsql.
> Does anybody know how to solve it? Thanks
> MARK
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
>
>
>
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dennis 2006-12-30 08:22:23 Re: Geographical redundancy
Previous Message 马庆 2006-12-30 03:32:12 How to use Php connecting to pgsql