pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Spiegelberg, Greg <gspiegelberg@isodxsolutions.com>
To: PJ <af.gourmet@videotron.ca>
To: pgsql-php@postgresql.org
Subject: Re: display query results
Date: Wed, 30 Jul 2008 12:29:15 -0400
Message-ID: <82E74D266CB9B44390D3CCE44A781ED90B64DC@POSTOFFICE.cranel.local> (raw)
References: <48909454.7040305@videotron.ca>

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: pgsql-php-owner@postgresql.org on behalf of PJ
Sent: Wed 7/30/2008 10:18 AM
To: pgsql-php@postgresql.org
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 (pgsql-php@postgresql.org)
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.
=

view thread (21+ messages)  latest in thread

Message-ID: <82E74D266CB9B44390D3CCE44A781ED90B64DC@POSTOFFICE.cranel.local>
Permalink:  ../82E74D266CB9B44390D3CCE44A781ED90B64DC@POSTOFFICE.cranel.local/
Also on:    postgresql.org/message-id/82E74D266CB9B44390D3CCE44A781ED90B64DC@POSTOFFICE.cranel.local

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: gspiegelberg@isodxsolutions.com, af.gourmet@videotron.ca
  Subject: Re: display query results
  In-Reply-To: <82E74D266CB9B44390D3CCE44A781ED90B64DC@POSTOFFICE.cranel.local>
  References: <48909454.7040305@videotron.ca> <82E74D266CB9B44390D3CCE44A781ED90B64DC@POSTOFFICE.cranel.local>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox