Re: pg_query_params

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

Carol

In response to Carol Walter <walterc(at)indiana(dot)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/

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(at)indiana(dot)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/

>
> 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

In response to Carol Walter <walterc(at)indiana(dot)edu>:
>
> On Jul 22, 2009, at 3:29 PM, Bill Moran wrote:
>
> > In response to Carol Walter <walterc(at)indiana(dot)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/

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(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

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(at)iol(dot)ie
> Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
> ------------------------------------------------------------------
>
> --
> Sent via pgsql-php mailing list (pgsql-php(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-php