Connection with PostgreSQL

DMatt · October 23rd, 2010, 07:59 PM

Hello (sorry for the english but i'm italian)
I've some problem with the connection with a database of PostgreSQL because i don't know the correct syntax, i try this code:

Code:

<?php
$db = pg_pconnect("host=localhost port=5432 dbname=postgres user=postgres password=pass");

$sql = 'CREATE TABLE "widget" (
	"widgetid" SERIAL PRIMARY KEY NOT NULL,
	"name" varchar(255) NOT NULL,
	"description" text
	)';
	
pg_query($db, $sql) or die ("unable to create table");

echo 'success';
?>

The result is an HTTP Error 500, php and apache are correctly configured, i can try all the php functions, but i don't know the correct configuration php-postgresql. With a phpinfo i see a field named "mysqlnd", but i've only install postgresql and never mysql or others.. can you help me please? Thanks a lot.

zz_snow · April 1st, 2011, 12:25 AM

1: make sure your user: postgresm AND password:pass
can Permissions to CREATE TABLE

2:you can write one.php to link database can sure is good
and then to write two.php to write somethig from database

and three.php to insert data into database

you can Step by step to win