Bug #52420 [Csd->Bgs]: json_decode fails when underscores used in names

Edit report at http://bugs.php.net/bug.php?id=52420&edit=1 ID: 52420 Updated by: pajoye@php.net Reported by: php at calendee dot com Summary: json_decode fails when underscores used in names -Status: Closed +Status: Bogus Type: Bug Package: JSON related Operating System: Mac OS 10.6.3, RHEL 5 PHP Version: 5.3.3 Previous Comments: ------------------------------------------------------------------------ [2010-07-23 23:36:20] php at calendee dot com I've actually solved this "bug". It's not a bug at all. The problem was that my json string repeated the same names several times. However, the values were not provided twice. So, when I renamed the "alarms_alarm_num" and "alarms_lsn" names to "alarmsalarmnum" and "alarmslsn", I was actually correcting the fact that those names were listed twice. Sorry for the bother. ------------------------------------------------------------------------ [2010-07-23 22:13:23] php at calendee dot com Description: ------------ There appears to be a bug in json_decode(). In some cases, if there is an underscore in one of the names in a JSON string, json_decode fails to retrieve the value. If the underscore is replaced with nothing, json_decode properly retrieves the value. However, some names with underscores work properly. In Depth Explanation : http://calendee.com/json_decode.php Test script: --------------- URL : http://calendee.com/json_decode.txt <?php $string = '{"alarm_groups_id":"0","start":"2010-07-23 10:23:13","stop":"2010-07-23 12:23:13","model":"","pairs_id":"","alarms_alarm_num":"1044","stps_abbr":"dlls","alarms_lsn":"bm700145","slc":"","card":"","port":"","linksets_company":"","opc":"","dpc":"","aftpc":"","feclli":"","cdpa_addr":"","cdpa_ssn":"","cdpa_tt":"","cgpa_addr":"","cgpa_ssn":"","cgpa_tt":"","translated_pc":"","translated_ssn":"","class":"","cong_card":"","cong_port":"","cpc":"","xmt_lsn":"","rcv_lsn":"","sccp_mt":"","sio":"","alarms_alarm_num":"","stps_abbr":"","alarms_lsn":"","slc":"","card":"","port":"","linksets_company":"","opc":"","dpc":"","aftpc":"","feclli":"","cdpa_addr":"","cdpa_ssn":"","cdpa_tt":"","cgpa_addr":"","cgpa_ssn":"","cgpa_tt":"","translated_pc":"","translated_ssn":"","class":"","cong_card":"","cong_port":"","cpc":"","xmt_lsn":"","rcv_lsn":"","sccp_mt":"","sio":""}'; echo "\nDecode with Underscore in Name\n"; print_r( json_decode($string) ); echo json_last_error() ; $string = '{"alarm_groups_id":"0","start":"2010-07-23 10:23:13","stop":"2010-07-23 12:23:13","model":"","pairs_id":"","alarmsalarmnum":"1044","stps_abbr":"dlls","alarmslsn":"bm700145","slc":"","card":"","port":"","linksets_company":"","opc":"","dpc":"","aftpc":"","feclli":"","cdpa_addr":"","cdpa_ssn":"","cdpa_tt":"","cgpa_addr":"","cgpa_ssn":"","cgpa_tt":"","translated_pc":"","translated_ssn":"","class":"","cong_card":"","cong_port":"","cpc":"","xmt_lsn":"","rcv_lsn":"","sccp_mt":"","sio":"","alarms_alarm_num":"","stps_abbr":"","alarms_lsn":"","slc":"","card":"","port":"","linksets_company":"","opc":"","dpc":"","aftpc":"","feclli":"","cdpa_addr":"","cdpa_ssn":"","cdpa_tt":"","cgpa_addr":"","cgpa_ssn":"","cgpa_tt":"","translated_pc":"","translated_ssn":"","class":"","cong_card":"","cong_port":"","cpc":"","xmt_lsn":"","rcv_lsn":"","sccp_mt":"","sio":""}'; echo "\nDecode without Underscore in Name\n"; print_r( json_decode($string) ); echo json_last_error() ; ?> Expected result: ---------------- Decode with Underscore in Name stdClass Object ( [alarm_groups_id] => 0 [start] => 2010-07-23 10:23:13 [stop] => 2010-07-23 12:23:13 [model] => [pairs_id] => [alarms_alarm_num] => 1044 [stps_abbr] => [alarms_lsn] => bm700145 [slc] => [card] => [port] => [linksets_company] => [opc] => [dpc] => [aftpc] => [feclli] => [cdpa_addr] => [cdpa_ssn] => [cdpa_tt] => [cgpa_addr] => [cgpa_ssn] => [cgpa_tt] => [translated_pc] => [translated_ssn] => [class] => [cong_card] => [cong_port] => [cpc] => [xmt_lsn] => [rcv_lsn] => [sccp_mt] => [sio] => ) Decode without Underscore in Name stdClass Object ( [alarm_groups_id] => 0 [start] => 2010-07-23 10:23:13 [stop] => 2010-07-23 12:23:13 [model] => [pairs_id] => [alarmsalarmnum] => 1044 [stps_abbr] => [alarmslsn] => bm700145 [slc] => [card] => [port] => [linksets_company] => [opc] => [dpc] => [aftpc] => [feclli] => [cdpa_addr] => [cdpa_ssn] => [cdpa_tt] => [cgpa_addr] => [cgpa_ssn] => [cgpa_tt] => [translated_pc] => [translated_ssn] => [class] => [cong_card] => [cong_port] => [cpc] => [xmt_lsn] => [rcv_lsn] => [sccp_mt] => [sio] => [alarms_alarm_num] => [alarms_lsn] => ) Actual result: -------------- Decode with Underscore in Name stdClass Object ( [alarm_groups_id] => 0 [start] => 2010-07-23 10:23:13 [stop] => 2010-07-23 12:23:13 [model] => [pairs_id] => [alarms_alarm_num] => [stps_abbr] => [alarms_lsn] => [slc] => [card] => [port] => [linksets_company] => [opc] => [dpc] => [aftpc] => [feclli] => [cdpa_addr] => [cdpa_ssn] => [cdpa_tt] => [cgpa_addr] => [cgpa_ssn] => [cgpa_tt] => [translated_pc] => [translated_ssn] => [class] => [cong_card] => [cong_port] => [cpc] => [xmt_lsn] => [rcv_lsn] => [sccp_mt] => [sio] => ) 0 Decode without Underscore in Name stdClass Object ( [alarm_groups_id] => 0 [start] => 2010-07-23 10:23:13 [stop] => 2010-07-23 12:23:13 [model] => [pairs_id] => [alarmsalarmnum] => 1044 [stps_abbr] => [alarmslsn] => bm700145 [slc] => [card] => [port] => [linksets_company] => [opc] => [dpc] => [aftpc] => [feclli] => [cdpa_addr] => [cdpa_ssn] => [cdpa_tt] => [cgpa_addr] => [cgpa_ssn] => [cgpa_tt] => [translated_pc] => [translated_ssn] => [class] => [cong_card] => [cong_port] => [cpc] => [xmt_lsn] => [rcv_lsn] => [sccp_mt] => [sio] => [alarms_alarm_num] => [alarms_lsn] => ) ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/bug.php?id=52420&edit=1