You need to fetch the results. See the pg_fetch_* family of functions for the one of your liking.
$myarray = pg_fetch_all($results);
From: pgsql-php-owner(at)postgresql(dot)org on behalf of PJ
Sent: Wed 7/30/2008 10:18 AM
Subject: [PHP] display query results
I am trying to learn postgresql with psql - using FreeBS D7.0,
postgresql 8.3.3 php 5.2.6, apache 2.2.9
How can I echo or print on screen the results; all I get from this code
Resource id #3
which is the field names run together
I am expecting to see several long text sentences.
Here is the snippet and the connection does work and the database is
there and functioning.
$db = pg_connect("host=localhost port=5432 dbname=med user=med
die("Could not open connection to database server");
// generate and execute a query
$query = "SELECT description FROM glossary_item WHERE
$result = pg_query($db, $query) or die("Error in query: $query.
" . pg_last_error($db));
// Print result on screen
What am I doing wrong?
Sent via pgsql-php mailing list (pgsql-php(at)postgresql(dot)org)
To make changes to your subscription:
CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may contain confidential and privileged information for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error; please notify Cranel Incorporated immediately by telephone at 614-431-8000 or 800-288-3475 and destroy all copies of this communication and any attachments.
In response to
pgsql-php by date
|Next:||From: Matthias Ritzkowski||Date: 2008-07-30 16:35:34|
|Subject: Re: display query results|
|Previous:||From: PJ||Date: 2008-07-30 16:18:28|
|Subject: display query results|