Thread: pg_query_params

pg_query_params

From
Carol Walter
Date:
Does pg_query_params return a false if an item is not found in at
database?

Carol


Re: pg_query_params

From
Bill Moran
Date:
In response to Carol Walter <walterc@indiana.edu>:

> Does pg_query_params return a false if an item is not found in a
> database?

What's an item?  That term is does not describe any type of standard
database object.

pg_query_params() will return false if the query was invalid for any
reason.  One such possible reason is that you tried to access a
table that doesn't exist.

If you're getting false as the return value, you should use
pg_last_error() to discover the details of the error.

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/

Re: pg_query_params

From
Carol Walter
Date:
No, I mean if I select select a name from the database but the name
isn't found.  I'm doing a log in form.  I want to check to see if the
user that's logging in exists in my database.  I can check the number
of rows returned or something like that, but I wondered if the
function returns a false.

Carol

On Jul 22, 2009, at 3:29 PM, Bill Moran wrote:

> In response to Carol Walter <walterc@indiana.edu>:
>
>> Does pg_query_params return a false if an item is not found in a
>> database?
>
> What's an item?  That term is does not describe any type of standard
> database object.
>
> pg_query_params() will return false if the query was invalid for any
> reason.  One such possible reason is that you tried to access a
> table that doesn't exist.
>
> If you're getting false as the return value, you should use
> pg_last_error() to discover the details of the error.
>
> --
> Bill Moran
> http://www.potentialtech.com
> http://people.collaborativefusion.com/~wmoran/


Re: pg_query_params

From
Bill Moran
Date:
In response to Carol Walter <walterc@indiana.edu>:
>
> On Jul 22, 2009, at 3:29 PM, Bill Moran wrote:
>
> > In response to Carol Walter <walterc@indiana.edu>:
> >
> >> Does pg_query_params return a false if an item is not found in a
> >> database?
> >
> > What's an item?  That term is does not describe any type of standard
> > database object.
> >
> > pg_query_params() will return false if the query was invalid for any
> > reason.  One such possible reason is that you tried to access a
> > table that doesn't exist.
> >
> > If you're getting false as the return value, you should use
> > pg_last_error() to discover the details of the error.

> No, I mean if I select select a name from the database but the name
> isn't found.  I'm doing a log in form.  I want to check to see if the
> user that's logging in exists in my database.  I can check the number
> of rows returned or something like that, but I wondered if the
> function returns a false.

Please don't top-post.

I assume that (for some reason) you're avoiding using the term "table"
and that you're running a select query against a table and finding that
a particular row is or is no in that table?

If that's correct, you should work on communicating more clearly.  Also,
if that is correct, I already answered your question:

"pg_query_params() will return false if the query was invalid for any
reason."

Meaning, "no, it won't return false if a matching row isn't found, because
the query was still valid."

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/

Re: pg_query_params

From
Raymond O'Donnell
Date:
On 22/07/2009 20:37, Carol Walter wrote:
> No, I mean if I select select a name from the database but the name
> isn't found.  I'm doing a log in form.  I want to check to see if the
> user that's logging in exists in my database.  I can check the number of
> rows returned or something like that, but I wondered if the function
> returns a false.

No, it'll still return a rowset (or whatever such things are called in
PHP), but one that doesn't contain any rows.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

Re: pg_query_params

From
Carol Walter
Date:
Thank you very much.  I understand.

Carol
On Jul 22, 2009, at 5:51 PM, Raymond O'Donnell wrote:

> On 22/07/2009 20:37, Carol Walter wrote:
>> No, I mean if I select select a name from the database but the name
>> isn't found.  I'm doing a log in form.  I want to check to see if the
>> user that's logging in exists in my database.  I can check the
>> number of
>> rows returned or something like that, but I wondered if the function
>> returns a false.
>
> No, it'll still return a rowset (or whatever such things are called in
> PHP), but one that doesn't contain any rows.
>
> Ray.
>
> ------------------------------------------------------------------
> Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
> rod@iol.ie
> Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
> ------------------------------------------------------------------
>
> --
> Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-php


Re: pg_query_params

From
"Hajek, Nick"
Date:
>
> Does pg_query_params return a false if an item is not found
> in at database?


False means the query didn't execute successfully.  A successful query
can return an empty but valid result set.

Nick