[PHP-DEV] Bug #12008 Updated: mysql_fetch_* inconsistent with MySQL C API
ID: 12008 Updated by: zeev Reported By: [EMAIL PROTECTED] Status: Open Bug Type: Feature/Change Request Operating System: RedHat 6.2 PHP Version: 4.0.6 New Comment: fetch_array, in recent versions (4.0.6 inclusive) should actrually populate NULL values in the array. Are you sure you tested it with 4.0.6? How did you arrive to the conlusion they're not there? Previous Comments: [2001-07-10 09:08:13] [EMAIL PROTECTED] The handling of NULL values in mysql_fetch_* function seems to be inconsistent with MySQL C API: in C, mysql_fetch_row() would put nil values in the row array if corresponding value in the select statement is NULL. In PHP it seems, as dicussed on mysql_fetch_array() page, the NULL values would not be stored in the array at all. This poses some problems when migrating from C to PHP. Would it be possible to introduce another function that would be consistent with MySQL C API? ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=12008edit=1 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #12008 Updated: mysql_fetch_* inconsistent with MySQL C API
ID: 12008 Updated by: brianlmoon Reported By: [EMAIL PROTECTED] Old Status: Open Status: Closed Bug Type: Feature/Change Request Operating System: RedHat 6.2 PHP Version: 4.0.6 New Comment: In PHP setting a var to NULL in fact destroys that var so it is not currently possible to have an elelment in an array that has a NULL value. On a side note, if you read the MySQL optimization docs, you will find they reccommend you never use NULL fields. Brian. Previous Comments: [2001-07-10 09:14:34] [EMAIL PROTECTED] fetch_array, in recent versions (4.0.6 inclusive) should actrually populate NULL values in the array. Are you sure you tested it with 4.0.6? How did you arrive to the conlusion they're not there? [2001-07-10 09:08:13] [EMAIL PROTECTED] The handling of NULL values in mysql_fetch_* function seems to be inconsistent with MySQL C API: in C, mysql_fetch_row() would put nil values in the row array if corresponding value in the select statement is NULL. In PHP it seems, as dicussed on mysql_fetch_array() page, the NULL values would not be stored in the array at all. This poses some problems when migrating from C to PHP. Would it be possible to introduce another function that would be consistent with MySQL C API? ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=12008edit=1 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #12008 Updated: mysql_fetch_* inconsistent with MySQL C API
ID: 12008 Updated by: jeroen Reported By: [EMAIL PROTECTED] Status: Closed Bug Type: Feature/Change Request Operating System: RedHat 6.2 PHP Version: 4.0.6 New Comment: About not using NULL values: It is not efficient to use PHP, use C, or even better: assembler if you want the most efficient dynamic website. IMHO, null values are incredibly useful. As is PHP, by the way :) And arrays *do* support NULL values. The only point is that isset($a_var_containing_null) returns false. But with foreach you will go over the value. With var_dump on such an array, you will see the null-values. Zeev: do you know since when it does / doesn't work? Then I'll note it in the docs. Previous Comments: [2001-07-10 13:08:53] [EMAIL PROTECTED] In PHP setting a var to NULL in fact destroys that var so it is not currently possible to have an elelment in an array that has a NULL value. On a side note, if you read the MySQL optimization docs, you will find they reccommend you never use NULL fields. Brian. [2001-07-10 09:14:34] [EMAIL PROTECTED] fetch_array, in recent versions (4.0.6 inclusive) should actrually populate NULL values in the array. Are you sure you tested it with 4.0.6? How did you arrive to the conlusion they're not there? [2001-07-10 09:08:13] [EMAIL PROTECTED] The handling of NULL values in mysql_fetch_* function seems to be inconsistent with MySQL C API: in C, mysql_fetch_row() would put nil values in the row array if corresponding value in the select statement is NULL. In PHP it seems, as dicussed on mysql_fetch_array() page, the NULL values would not be stored in the array at all. This poses some problems when migrating from C to PHP. Would it be possible to introduce another function that would be consistent with MySQL C API? ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=12008edit=1 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]