ID: 48015
User updated by: blackmagic at computer dot org
Reported By: blackmagic at computer dot org
Status: Bogus
Bug Type: PostgreSQL related
Operating System: Centos 5.3
PHP Version: 5.2.9
New Comment:
Scott,
OK. I know how to fix the problem now.
Thanks for getting back to me.
MJR
Previous Comments:
------------------------------------------------------------------------
[2009-04-20 10:46:28] scott...@php.net
The default value is PGSQL_BOTH so I can use
$result[0] OR $result['columnName']
That is the reason for this, if you don't want to then change the
parameter like you've done. The end.
It's been this way for several years and changing it would break
backwards compatibility.
------------------------------------------------------------------------
[2009-04-20 09:07:01] blackmagic at computer dot org
Why would the function return the data twice? What good is that to
anyone?
If you were to say 'it returns the data and the column headings in
default mode' I would say 'that's useful'. However that's not what the
function is doing in default mode. It is returning the data twice, which
is of no use to anyone.
------------------------------------------------------------------------
[2009-04-20 08:18:24] j...@php.net
Like already said above: By default the function returns all fields
twice. Once with numeric index and once with the field name as the
index.
------------------------------------------------------------------------
[2009-04-20 04:53:08] blackmagic at computer dot org
Changing pg_fetch_array() to:
$details = pg_fetch_array($db_result, $index, PGSQL_NUM);
produces correct results with the implode() and foreach() methods. But
it doesn't explain the behaviour I've been experiencing before including
the PGSQL_NUM parameter in the parameter list.
Clearly I was getting a result that wasn't the intended result, ie,
instead of getting values and column names I was getting repeated
values.
------------------------------------------------------------------------
[2009-04-20 04:22:12] blackmagic at computer dot org
I understand that the array contains the column names and the
corresponding key values.
The problem is I'm not getting back the column names and the key
values, I'm getting the key values twice.
I thought I would try something else:
foreach($details as $value) $result .= ($value . '|');
instead of $company[$index] = implode('|', $details);
The results are the same for the implode() method and the foreach()
method: The key values are doubled up in the result the script sends
back to the browser.
I've captured the result with a window.alert, but can't paste it into
this reply. I'm sending it to you as a separate e-mail with an Word
attachment.
Thanks for your assistance.
MJR
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/48015
--
Edit this bug report at http://bugs.php.net/?id=48015&edit=1
