pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Randy Moller <zoomerz@comcast.net>
To: 'Mag Gam' <magawake@gmail.com>
Cc: pgsql-php@postgresql.org
Subject: Re: HTML FORMS selected question
Date: Sun, 3 Dec 2006 17:23:25 -0700
Message-ID: <20061204002333.056109F9F47@postgresql.org> (raw)
In-Reply-To: <1cbd6f830612031600xb902e5fgf3eb485a8af59a@mail.gmail.com>

Ok, I think you are misunderstanding the process:

 

1.	first, you are querying a database (I assume a postgres db) like
this:

 

$result = pg_query($dbconn, “select…”) , so,

 

$result now is a “resource reference” which contains the “result” of the
query. However, now you need to tell php to return the contents of that
resource to you (you can return in either an indexed, associative, or object
array). So, to get your “array”, you now use $result like this:

 

$myArray = pg_fetch_array($result);

 

Now $myArray is the actual “row/s” you returned in $result.

 

Does that make sense?

 

So, when you first query, $result (or $result_ip) = pg_query(conn, sql), you
need to be consistent with your variables. Either use $result_ip, or
$result, but not both….My guess is that’s your problem.

 

Hope that helps!

Randy

   _____  

From: pgsql-php-owner@postgresql.org [mailto:pgsql-php-owner@postgresql.org]
On Behalf Of Mag Gam
Sent: Sunday, December 03, 2006 5:01 PM
To: Chris
Cc: Randy Moller; pgsql-php@postgresql.org
Subject: Re: [PHP] HTML FORMS selected question

 

Chris + Randy:

Sorry, I may of forgetten to give you this:
$result = pg_query($dbconn, "select id,address from ip");

This is right before the:
$options=pg_fetch_array($result_ip);

so, my $results is really all the ip addresses ($rows after I perform the
pg_fetch_array). 

I will add the var_dump to see it (never done it before, I will do some
googling :) )







On 12/3/06, Chris <HYPERLINK "mailto:dmagick@gmail.com" dmagick@gmail.com>
wrote:

Mag Gam wrote:
> Randy + Chris:
>
> Thx for the quick replies! 
>
> Chris:
>
> $rows contain ip addresses (postgresql inet) type (example: HYPERLINK
"http://192.168.0.1"192.168.0.1
> <HYPERLINK "http://192.168.0.1"http://192.168.0.1;)
> $options contain ip addresses (postgresql inet0 type (example: HYPERLINK
"http://127.0.0.1"127.0.0.1
> <HYPERLINK "http://127.0.0.1"http://127.0.0.1;)
> (keep in mind) they are both arrays. $rows contact all ips, and $options
> contact the ip addresses that were selected 
>
> Randy:
> I am not sure what you mean. The variables look right. I am getting no
> errors! Just the logic is messed up.

I think Randy's right.

At the top you have:

//The values that need to be selected 
$result_ip=pg_query($dbconn,$test_query);
^^^^^^^^^
but you are doing this:

while ($row = pg_fetch_array($result)) {


$result_ip  at the top, $result in the second bit.


If you don't see errors, turn up error reporting & display errors: 

error_reporting(E_ALL);
ini_set('display_errors', true);


Also that's not what I meant. I meant add a var_dump or print_r at each
stage to see what you are *really* getting from the code.


--
Postgresql & php tutorials
HYPERLINK "http://www.designmagick.com/"http://www.designmagick.com/

 

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.15.6/565 - Release Date: 12/2/2006
9:39 PM


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.15.6/565 - Release Date: 12/2/2006
9:39 PM
 

view thread (10+ messages)  latest in thread

Message-ID: <20061204002333.056109F9F47@postgresql.org>
Permalink:  ../20061204002333.056109F9F47@postgresql.org/
Also on:    postgresql.org/message-id/20061204002333.056109F9F47@postgresql.org

 · 

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: zoomerz@comcast.net, magawake@gmail.com
  Subject: Re: HTML FORMS selected question
  In-Reply-To: <20061204002333.056109F9F47@postgresql.org>
  References: <1cbd6f830612031600xb902e5fgf3eb485a8af59a@mail.gmail.com> <20061204002333.056109F9F47@postgresql.org>

* 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