ID: 48015 User updated by: blackmagic at computer dot org Reported By: blackmagic at computer dot org -Status: Feedback +Status: Open Bug Type: PostgreSQL related Operating System: Centos 5.3 PHP Version: 5.2.9 New Comment:
The scripts in which this implode problem is occurring are remote scripts which are called from a browser by AJAX. AJAX sends the result of 'echo $details' back to the browser. If an error occurs during the running of a script 'echo $details' will return an appropriate error message. Debugging these scripts is more difficult than debugging PHP code that's embedded in HTML code. Since var_dump doesn't return any value I can't see how var_dump($company) is going to help me with scripts of this type. I tried 'echo "var_dump($company)"' and the answer was 'var_dump Array'. This script snippet works: for ($index=0; $index<$db_rows; $index++) { $details = pg_fetch_array($db_result, $index); $company[$index] = $details[0] . '|' . $details[1] . '|' . $details[2]; } $details = implode('^', $company); echo "$details"; 'echo "$details"' returns "1|2|3". This script snippet doesn't work: for ($index=0; $index<$db_rows; $index++) { $details = pg_fetch_array($db_result, $index); $company[$index] = implode('|', $details); } $details = implode('^', $company); echo "$details"; 'echo "$details"' returns "1|1|2|2|3|3". The only difference between the two scripts is the third line, where the array returned by pg_fetch_array() is imploded in the script that doesn't work. This suggests to me that there's something unusual about arrays returned by pg_fetch_array(), ie, they are treated differently by implode(). Previous Comments: ------------------------------------------------------------------------ [2009-04-19 14:18:56] j...@php.net Try 'var_dump($company);' and it should be clear.. ------------------------------------------------------------------------ [2009-04-19 11:20:58] blackmagic at computer dot org Description: ------------ A Postgresql query returns an array. If the array is imploded each value in the original array appears twice in the implosion. Assume a Postgresql result array contains $array[0], $array[1], $array[2]; $x=implode ('|', $array) puts $array[0]|$array[0]|$array[1]|$array[1]|$array[2]|$array[2] into $x. $x=$array[0]. '|' . $array[1]. '|' . $array[2]; works fine. Why is there a difference? Reproduce code: --------------- <?php $company; $details; $index; require_once('../functions/sql_functions.inc'); database_connect(); $db_query = "SELECT * FROM company ORDER BY id "; database_query(__FILE__, __LINE__); if ($db_rows == 0) echo $DB_EMPTY_FILE; else { for ($index=0; $index<$db_rows; $index++) { $details = pg_fetch_array($db_result, $index); $company[$index] = implode('|', $details); } //THE BUG IS HERE// $details = implode('^', $company); echo "$details"; } Expected result: ---------------- I expected to see: $company[$index] = $details[0]|$details[1]|$details[2]. Actual result: -------------- Actual result: $company[$index] = $details[0]|$details[0]|$details[1]|$details[1]|$details[2]|$details[ 2]. This program was working fine until I changed $company[$index] = $details[0]. '|' . $details[1]. '|' . $details[2]; to $company[$index] = implode('|', $details); ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=48015&edit=1