Search Postgresql Archives

Re: How to use Php connecting to pgsql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



马庆 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/









[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux