Re: display query results

You need to fetch the results.  See the pg_fetch_* family of functions for the one of your liking.
 
 $myarray = pg_fetch_all($results);
 print_r($myarray);
 
Greg

________________________________

From: [email protected] on behalf of PJ
Sent: Wed 7/30/2008 10:18 AM
To: [email protected]
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
is this:
Resource id #3
item_idglossary_idnamedescription
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
password=0tscc71");

        if (!$db)
        {
        die("Could not open connection to database server");
        }

         // generate and execute a query
        $query = "SELECT description FROM glossary_item WHERE
name='Alcohol'";
        $result = pg_query($db, $query) or die("Error in query: $query.
        " . pg_last_error($db));

        // Print result on screen
        echo "$result";

        pg_close($db);

What am I doing wrong?


--
Sent via pgsql-php mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php



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.