Hello group
I am trying to follow through on advice I received from you earlier. I
would like to check for my database when I logon and if it is not there
create it( I am using php to write web apps). I am able to connect to
the template1 and query for pg_database. But I am getting a parse error
on the following (XXX).

Error message:
"Expected T_STRING or T_VARIABLE"



Code :
$link=pg_connect('user=marcel dbname=template1') or die ("Couldn't
connect to template1 try again.<br>");

$query = "SELECT * FROM pg_database";

$result = pg_query ($query) or die ("Couldn't get the
database names".pg_last_error());

// If it worked get the database names.

$database= pg_fetch_array ($result) or print ("Can't get the
array of databases<br>");

XXX print (" the 1st database is $database['datname'].<br>");

die ("Finshed my test.<br>");

Is this the correct way to query the system catalog for the existing
databases? Is this questions addressed to the wrong group and maybe
should be addressed to the php_pgsql group?
Again thanks for the help
Marcel Wolf

Hi,

I am not a guru of php, so ...

But, if it can help you, here is a little code I use :

$conn=pg_connect("host=localhost user=bruno dbname=agenda");
if (!$conn) {
echo "Couldn't connect to agenda.<BR>";
exit;
}

$query="SET DATESTYLE TO PostgreSQL,European";
# execution de la requete
pg_query($conn, $query);

$query="SELECT * from agenda ";

# execution de la requete
$result = pg_query($conn, $query);

$arr = pg_fetch_all($result);

for ($i=0; $i<$NbLigne;$i++)
{
if ($arr[$i]["heures"] == ....
.....
and so


Bruno

On Tue, 27 Jan 2004, Marcel Wolf wrote:

Bruno LEVEQUE
System Engineer
SARL NET6D
bruno.leveque (AT) net6d (DOT) com
http://www.net6d.com

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Hi Marcel,

I believe your error is a result of lack of braces around
$database['datname']. Try:

print (" the 1st database is {$database['datname']}.<br>");

Hth,
Andre

On Tuesday 27 January 2004 05:07 pm, you wrote:

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match