#31702 [Opn->Bgs]: strings returned with 'pg_fetch_result' are incomplete

ID: 31702 Updated by: edink@php.net Reported By: kevin dot bray at utoronto dot ca -Status: Open +Status: Bogus Bug Type: PostgreSQL related Operating System: Mac OS X 10.3.7 PHP Version: 5.0.3 New Comment: You're not fetching array but a single value. $send['sender'] becomes $send[0] which is the first char of the string. Just print $send. Previous Comments: ------------------------------------------------------------------------ [2005-01-26 11:20:38] kevin dot bray at utoronto dot ca Description: ------------ When using pg_fetch_result to obtain field values (in this case, strings), PHP seems to print/echo only the first character in the value, I'm working with the following table (forgive the odd test values): arkhiv=# select * from docsender; doctitle | sender ------------------------------+---------- letter about cheese | bob letter about cheese | george note about peas | helen note about peas | god note about peas | bob Reproduce code: --------------- // pg_connect() code omitted above $result = pg_query("SELECT docSender.sender FROM docSender WHERE docSender.doctitle = 'letter about cheese'"); ?> <table> <? $loopCount=0; $rowCount = pg_num_rows($result); while ($loopCount < $rowCount){ $send = pg_fetch_result($result, $loopCount, 0); ?> <tr> <td> <? print 'Author: ' . $send['sender']; ?> </td> <td> <? var_dump($send); ?> </td> </tr> <? $loopCount++; } //endwhile ?> </table> Expected result: ---------------- I expected to see this: -------------------------------------------- <html> <table> <tr> <td> Author: bob</td> <td> string(3) "bob" </td> </tr> <tr> <td> Author: george</td> <td> string(6) "george" </td> </tr> </table></body> </html> Actual result: -------------- Only the initial characters (ie, 'b' and 'g') of 'bob' and 'george' appeared in the first <td> fields: --------------------------------------------- <html> <table> <tr> <td> Author: b </td> <td> string(3) "bob" </td> </tr> <tr> <td> Author: g </td> <td> string(6) "george" </td> </tr> </table></body> </html> --------------------------------------------- I inserted "var_dump();" to check if postgres was returning the entire value of the field. Apparently it is, so the shortened string must result from a later (ie PHP) problem. Thank you for your attention. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=31702&edit=1